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

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

Prestwood eMagazine

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

   ► 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
30 months ago, and updated 12 months ago
(2 Comments , last by ava.c )

Article
Nothing New Since Your Last Visit
640
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
7 years ago

KB Post
Nothing New Since Your Last Visit
2856
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
11 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
12484
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
12 years ago
(1 Comments , last by mchv.a )

Code
Nothing New Since Your Last Visit
18601
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
12 years ago

Code
Nothing New Since Your Last Visit
12002
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
12 years ago

Code
Nothing New Since Your Last Visit
9165
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
12 years ago, and updated 12 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
27638
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
12 years ago

Code
Nothing New Since Your Last Visit
11949
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
12 years ago
(3 Comments , last by renzy.m )

Code
Nothing New Since Your Last Visit  
13336
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
12 years ago
(1 Comments , last by verma.r )

Code
Nothing New Since Your Last Visit  
23333
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
30 months ago, and updated 12 months ago
(2 Comments , last by ava.c )

Article
Nothing New Since Your Last Visit
640
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
7 years ago

KB Post
Nothing New Since Your Last Visit
2856
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
11 years ago
(2 Comments , last by shravi.v )

Code
Nothing New Since Your Last Visit  
12484
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
12 years ago
(1 Comments , last by mchv.a )

Code
Nothing New Since Your Last Visit
18601
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
12 years ago, and updated 12 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
27638
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
12 years ago

Code
Nothing New Since Your Last Visit
12002
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
12 years ago

Code
Nothing New Since Your Last Visit
9165
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
13 years ago, and updated 12 years ago

Code
Nothing New Since Your Last Visit
8807
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
13 years ago, and updated 12 years ago
(2 Comments , last by Sabina.J )

Code

KB Post
Nothing New Since Your Last Visit
15771
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
13 years ago, and updated 12 years ago
(2 Comments , last by renzy.m )

Code
Nothing New Since Your Last Visit
10148
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-2021 Prestwood IT Solutions.   [Security & Privacy]