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.
|
7 Microsoft Access Articles
Group: Microsoft Access
Topic: Access & VBA
This article discusses a programming technique I used in a Microsoft Access database application to display a multiple page PDF document and make it position itself at a specific page.
+Add Comment
( 2 Comments)
Queries on a Microsoft Access database linked to MySQL tables failed with errors like ODBC--data out of range and the VBA code not recognizing fields from a sub-form query definition, insisting that it could not find the fields that I was referencing (Microsoft Access cannot find the field "fieldname" referred to in your expression).
Posted By Laura Lage,
Post #102704, KB Topic: Access & VBA
+Add Comment
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.
+Add Comment
( 7 Comments)
Same as VB. Access VBA logical operators:
and |
and, as in this and that |
or |
or, as in this or that |
Not |
Not, as in Not This |
+Add Comment
( 3 Comments)
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.
+Add Comment
( 2 Comments)
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
+Add Comment
( 2 Comments)
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.
+Add Comment
( 1 Comments)
|
|