Microsoft Access Tech Articles
These Articles are contributed by you (our online community members). They are organized by our knowledge base topics. Specifically, by the Access sub-topics.
5 Microsoft Access Articles
Group: Microsoft Access
Topic: Language Basics
Access VBA, like all the VB-based languages, uses a single quote (') or the original class-style basic "REM" (most developers just use a quote). Access VBA does NOT have a multiple line comment. Directives are sometimes called compiler or preprocessor directives. A # is used for directives within Access VBA code. Access VBA offers only an #If..then/#ElseIf/#Else directive.
Same as VB. Access VBA logical operators:
||and, as in this and that|
||or, as in this or that|
||Not, as in Not This|
Access VBA is a loosely typed language. Declaring variables is optional unless you use the Option Explicit statement to force explicit declaration of all variables with Dim, Private, Public, or ReDim. Using Option Explicit is strongly recommended to avoid incorrectly typing an existing variable and to avoid any confusion about variable scope. Variables declared with Dim at the module level are available to all procedures within the module. At the procedure level, variables are available only within the procedure.
Access is a wonderful desktop database. It makes it easy to do so many things. Many beginning users, though, fail to take advatage of one of Access's greatest strengths.
Posted By Wes Peterson,
Post #100555, KB Topic: Language Basics
Topic: Language Details
Access VBA is a non-OOP language with some OOP features. It offers both Subs and Functions. A Sub does not return a value while a Function does. When Subs and Functions are used in a class module, they become the methods of the class.