1. How I Make a Multiple Page PDF File Scroll to a Specific Page in a Browser

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.

Posted By Douglas.M, Post #103857, KB Topic: Access & VBA

2. MySQL Connectors and MSAccess Office 2007 Errors

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

3. Access VBA Comments (' or REM)

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.

Posted By Mike Prestwood, Post #101499, KB Topic: Language Basics

  To/From Code Guide: Access VBA Comments ... vs. Other Languages

4. Access VBA Logical Operators (and, or, not)

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

Posted By Mike Prestwood, Post #101890, KB Topic: Language Basics

  To/From Code Guide: Access VBA Logical O... vs. Other Languages

5. Access VBA Variables (Dim x as Integer)

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.

Posted By Mike Prestwood, Post #101571, KB Topic: Language Basics

  To/From Code Guide: Access VBA Variables... vs. Other Languages

6. Don't overlook the power of a relational database!

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

7. Access VBA Custom Routines (Sub, Function)

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.

Posted By Mike Prestwood, Post #101596, KB Topic: Language Details

  To/From Code Guide: Access VBA Custom Ro... vs. Other Languages