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

August 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    

Douglas.M
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
4 months ago

Article
Nothing New Since Your Last Visit
111
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
57 months ago

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

Code
Nothing New Since Your Last Visit  
11570
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
10 years ago
(1 Comments , last by petter.s )

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

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

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

Code

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

Code
Nothing New Since Your Last Visit
11151
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
10 years ago
(1 Comments , last by Andrea.D )

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

Code
Nothing New Since Your Last Visit  
21930
Hits




Recently Updated

(Microsoft Access Group)

  KB Article    

Douglas.M
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
4 months ago

Article
Nothing New Since Your Last Visit
111
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
57 months ago

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

Code
Nothing New Since Your Last Visit  
11570
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
10 years ago
(1 Comments , last by petter.s )

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

Code

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

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

Code
Nothing New Since Your Last Visit
8406
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
11 years ago, and updated 10 years ago

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

Code

KB Post
Nothing New Since Your Last Visit
14847
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
11 years ago, and updated 10 years ago
(1 Comments , last by verma.r )

Code
Nothing New Since Your Last Visit
9324
Hits
Icon Legend:
Recent or not:
- Recent activity (within last two weeks).
- No activity last two weeks.
 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).
Follow PrestwoodBoards on: 


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