Difference between revisions of "Category:VBA"

From database24
Jump to navigation Jump to search
Line 2: Line 2:
 
* [[Microsoft Access VBA Coding Conventions|Coding Conventions]]
 
* [[Microsoft Access VBA Coding Conventions|Coding Conventions]]
 
* [[Microsoft Access VBA Naming Conventions|Naming Conventions]]
 
* [[Microsoft Access VBA Naming Conventions|Naming Conventions]]
 +
 +
== General ==
 +
* SQL vs DAO/ADO
 +
 +
== Advanced ==
 +
* Variables and Classes: WithEvents
 +
* Parameters: ByRef / ByVal
 +
* ParamArray
 +
* Enum
 +
* Set Nothing
 +
* Nothing vs Null vs 0 vs Empty vs ...
 +
 +
== Access specific ==
 +
* ! vs .
  
 
== Code ==
 
== Code ==

Revision as of 01:42, 30 July 2010

Conventions

General

  • SQL vs DAO/ADO

Advanced

  • Variables and Classes: WithEvents
  • Parameters: ByRef / ByVal
  • ParamArray
  • Enum
  • Set Nothing
  • Nothing vs Null vs 0 vs Empty vs ...

Access specific

  • ! vs .

Code

Modules

Lookup

Management