Access Developer 3
01. Variables (22:12)
Docmd.OpenTable
DLOOKUP
Exit Sub
Line Continuation Character
Variables
DIM ID As Long
On Error Resume Next
On Error Goto 0
Initializing Variables
MsgBox as a Function
vbYesNoCancel
vbYes, vbNo, vbCancel
02. Random Numbers (9:33)
Rnd
Randomize
Int()
Const - Constants
03. For Next Loops (21:47)
Looping Math Quiz
Set NumLoops
For Next
InputBox
Format Function, Percent
Format Function, 0.0%
Data Types in Access VBA
Boolean
Integer, Long Integer
Single, Double
Currency
Date, Date Time
String
Variant
04. Quick Add Sales Rep (21:10)
Add Link on Commission Form
InputBox First, Last, Com Rate
DCount, DMax, CDbl
Run Another Objects Event
|