nAll continued code lines must end in <space>_ (an space
must precede the underscore)
nAll procedures must be called as if functions:
n xyx(a,b,c) (not xyz a b c).
nAll variables must be declared before use
nPreferred: All variables, parameters, and functions should be
typed (e.g., DIM I AS Integer). This causes the
code to execute much faster.
nInstead of declaring public variables that are global to all
the code, make variables public properties of objects that are
instantiated and call them as such, e.g., nDefaultIncrement becomes v.nDefaultIncrement.
nAdded after evaluations of fields oRS(“…<field
name>…”) the explicit property specification
.Value., e.g.:
n oRS(“ID”).Value (not oRS(“ID”))
nRecast the code into vb code modules as described on next
slides