I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

December 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 Douglas.M, Post #103857, KB Topic: Access & VBA
  +Add Comment  (1 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  (5 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


Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech