IT SOLUTIONS
Your full service technology partner! 
+Expand
   ► KB ►► Desktop Data...Access & VBA   Print This    All Groups  

Microsoft Access New and Updated KB Posts

Page Contents


Recently Created

(Microsoft Access Group)

  KB Article    

NE Ohio Computer Guy
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 to KB Topic: Access & VBA
6 years ago, and updated 51 months ago
(2 Comments , last by ava.c )

Article
Nothing New Since Your Last Visit
1278
Hits

Laura Lage
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 to KB Topic: Access & VBA
11 years ago

KB Post
Nothing New Since Your Last Visit
3378
Hits

Mike Prestwood
3. Access VBA Array (x = Array())

Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: Access & VBA
15 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
13837
Hits

Mike Prestwood
4. Access VBA Empty String Check (Len(s&vbNullString))

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: Access & VBA
16 years ago
(1 Comments , last by mchv.a )

Code
Nothing New Since Your Last Visit
20198
Hits

Mike Prestwood
5. Access VBA Self Keyword (Me)

Same as VB. The Me keyword is a built-in variable that refers to the class where the code is executing. For example, you can pass Me from one module to another.

Posted to KB Topic: Language Details
16 years ago

Code
Nothing New Since Your Last Visit
12971
Hits

Mike Prestwood
6. Access VBA Deployment Overview

You can deploy your Microsoft Access application either with the full version of Access or with the Access Runtime (see Deploying Applications Using the Access Runtime).

Posted to KB Topic: Language Basics
16 years ago

Code
Nothing New Since Your Last Visit
10633
Hits

Mike Prestwood
7. 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 to KB Topic: Language Basics
16 years ago, and updated 16 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
30307
Hits

Mike Prestwood
8. Access VBA Interfaces

Same as in VB6. Access VBA has limited support for interfaces. You can create an interface of abstract methods and properties and then implement them in one or more descendant classes. It's a single level implementation though (you cannot inherit beyond that). The parent interface class is a pure abstract class (all methods and properites are abstract, you cannot implement any of them in the parent class).

In the single level descendant class, you have to implement all methods and properties and you cannot add any. Your first line of code is Implements InterfaceName.

Posted to KB Topic: OOP
16 years ago

Code
Nothing New Since Your Last Visit
13120
Hits

Mike Prestwood
9. Access VBA Destructor

When an object instance is destroyed, Access VBA calls a special parameter-less sub named Class_Terminate. For example, when the variable falls out of scope. Since you cannot specify parameters for this sub, you also cannot overload it.

When an object instance is created from a class, Access VBA calls a special sub called Class_Initialize.

Posted to KB Topic: OOP
16 years ago
(3 Comments , last by renzy.m )

Code
Nothing New Since Your Last Visit  
14576
Hits

Mike Prestwood
10. Access VBA Constructors (Class_Initialize)

When an object instance is created from a class, Access VBA calls a special parameter-less sub named Class_Initialize. Since you cannot specify parameters for this sub, you also cannot overload it.

When a class is destroyed, Access VBA calls a special sub called Class_Terminate.

Posted to KB Topic: OOP
16 years ago
(1 Comments , last by verma.r )

Code
Nothing New Since Your Last Visit  
25730
Hits




Recently Updated

(Microsoft Access Group)

  KB Article    

NE Ohio Computer Guy
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 to KB Topic: Access & VBA
6 years ago, and updated 51 months ago
(2 Comments , last by ava.c )

Article
Nothing New Since Your Last Visit
1278
Hits

Laura Lage
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 to KB Topic: Access & VBA
11 years ago

KB Post
Nothing New Since Your Last Visit
3378
Hits

Mike Prestwood
3. Access VBA Array (x = Array())

Arrays in Access VBA use a 0-based indice. UBound returns -1 if the array has no elements, 0 if it has 1, 1 if it has 2, etc.

Posted to KB Topic: Access & VBA
15 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
13837
Hits

Mike Prestwood
4. Access VBA Empty String Check (Len(s&vbNullString))

In Access VBA, you have to add an empty string to the value being compared in order to get consistent results. For example, add &"" to your string varilable or it's code equivalent &vbNullString. Then compare to an empty string or verify it's length to 0 with Len.

Posted to KB Topic: Access & VBA
16 years ago
(1 Comments , last by mchv.a )

Code
Nothing New Since Your Last Visit
20198
Hits

Mike Prestwood
5. 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 to KB Topic: Language Basics
16 years ago, and updated 16 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
30307
Hits

Mike Prestwood
6. Access VBA Self Keyword (Me)

Same as VB. The Me keyword is a built-in variable that refers to the class where the code is executing. For example, you can pass Me from one module to another.

Posted to KB Topic: Language Details
16 years ago

Code
Nothing New Since Your Last Visit
12971
Hits

Mike Prestwood
7. Access VBA Deployment Overview

You can deploy your Microsoft Access application either with the full version of Access or with the Access Runtime (see Deploying Applications Using the Access Runtime).

Posted to KB Topic: Language Basics
16 years ago

Code
Nothing New Since Your Last Visit
10633
Hits

Mike Prestwood
8. Access VBA Unary Operators

An operation with only one operand (a single input) such as + and -.

Posted to KB Topic: Language Basics
17 years ago, and updated 16 years ago

Code
Nothing New Since Your Last Visit
9929
Hits

Mike Prestwood
9. 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 to KB Topic: Language Basics
17 years ago, and updated 16 years ago
(2 Comments , last by Sabina.J )

Code

KB Post
Nothing New Since Your Last Visit
17078
Hits

Mike Prestwood
10. Access VBA Constants (Const kPI = 3.1459)

Scope can be Public, Global, or Private. The use of the newer Public keyword is preferred to the older Global. Private Const is the same as just specifying Const.

Posted to KB Topic: Language Basics
17 years ago, and updated 16 years ago
(2 Comments , last by renzy.m )

Code
Nothing New Since Your Last Visit
11240
Hits
Icon Legend:
Since your last logged visit:
- New to you or updated since your last visit (sign in now to activate).
- NOT new to you since your last visit (sign in now to activate).
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


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