Difference between revisions of "Category:VBA"

From database24
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 15: Line 15:
  
 
== Access specific ==
 
== Access specific ==
* ! vs . (see Discussion)
+
* ! vs . (see [[Category_talk:VBA|Discussion]])
 +
* Me.Control vs Control
  
 
== Code ==
 
== Code ==
 
* [[Microsoft Access VBA Code Snippets|Code Snippets]]
 
* [[Microsoft Access VBA Code Snippets|Code Snippets]]
 +
 +
=== Code Base ===
 +
* [[Microsoft Access Backend|Backend]]
 +
* [[Microsoft Access Log|Log]]
 +
* [[Microsoft Access Status|Status]]
  
 
=== Modules ===
 
=== Modules ===
Line 26: Line 32:
 
* [[Microsoft Access modFso|modFso]]
 
* [[Microsoft Access modFso|modFso]]
 
* [[Microsoft Access modFunction|modFunction]]
 
* [[Microsoft Access modFunction|modFunction]]
 +
* [[Microsoft Access modList|modList]]
 
* [[Microsoft Access modSetting|modSetting]]
 
* [[Microsoft Access modSetting|modSetting]]
 
* [[Microsoft Access modSql|modSql]]
 
* [[Microsoft Access modSql|modSql]]

Latest revision as of 01:40, 5 August 2012

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

Code

Code Base

Modules

Lookup

Management