Your full service technology partner! 
-Collapse +Expand
Search Access Group:

-Collapse +Expand Access To/From
-Collapse +Expand Access Store

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► KBAccess Knowledge Base  Print This    All Groups  

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.

Contribute an Article

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.

Posted By NE Ohio Computer Guy, Post #103857, KB Topic: Access & VBA
  +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.

Posted By Mike Prestwood, Post #101499, KB Topic: Language Basics
  +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

Posted By Mike Prestwood, Post #101890, KB Topic: Language Basics
  +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.

Posted By Mike Prestwood, Post #101571, KB Topic: Language Basics
  +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.

Posted By Mike Prestwood, Post #101596, KB Topic: Language Details
  +Add Comment  (1 Comments)

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2022 Prestwood IT Solutions.   [Security & Privacy]