MS Access VBA Code Fragments

The VBA code fragments below are included in the Code VBA fragments library. Fragments are snippets of code you can insert in your procedures. Each item between braces correspond to a variable of the given type. They are replaced with the new or existing variables by Fragment Builder in Code-VB tools.

General Access fragments

• Access Version Major
• Uses Access Runtime
• Wait

Other Access VBA groups

• AccessObjects
• Access Controls
• Access Datasheet Conditions
• Access Forms
• Access Query
• Access Record Navigation
• Access Reports
• Access Security
• Access Sizing
• Access SQL
• Access StatusBar

Access Version Major

Left(Application.SysCmd(acSysCmdAccessVer), Instr(Application.SysCmd(acSysCmdAccessVer),".") - 1)

Uses Access Runtime

SysCmd(acSysCmdRuntime) 

Wait

{DATE:StartTime} = Timer
While Timer < {DATE:StartTime} + {INTEGER:WaitSeconds}
    DoEvents
Wend