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

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

   ► KB ►► Desktop Data...Access & VBA   Print This    All Groups  

Microsoft Access Most Read KB Posts

Page Contents


Most Read KB Articles Since 3/28/2008

Microsoft Access Group

  KB Article    

Mike Prestwood
1. 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  
26095
Hits

Mike Prestwood
2. Access VBA Comments (' or REM)

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 to KB Topic: Language Basics
11 years ago, and updated 10 years ago
(5 Comments , last by Schnell.h )

Code

KB Post
Nothing New Since Your Last Visit
21790
Hits

Mike Prestwood
3. 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  
21564
Hits

Mike Prestwood
4. Access VBA Associative Array (Collection)

In addition to Add and Item, collections also offer Count and Remove. Notice that Add uses the format of Value, Key (which is backwards from many other languages).

Posted to KB Topic: Language Details
11 years ago, and updated 10 years ago

Code
Nothing New Since Your Last Visit
18651
Hits

Mike Prestwood
5. 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
17208
Hits

Mike Prestwood
6. Access VBA Custom Routines (Sub, Function)

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 to KB Topic: Language Details
11 years ago, and updated 10 years ago

Code

KB Post
Nothing New Since Your Last Visit
14903
Hits

Mike Prestwood
7. 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
14644
Hits

Mike Prestwood
8. 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  
12235
Hits

Mike Prestwood
9. Access VBA Parameters (ByRef, ByVal)

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Posted to KB Topic: Access & VBA
11 years ago, and updated 10 years ago
(3 Comments , last by Owen.G )

Code
Nothing New Since Your Last Visit  
11751
Hits

Mike Prestwood
10. 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  
11448
Hits



Most Read by Members

Microsoft Access Group

  KB Article    

Mike Prestwood
1. Access VBA Comments (' or REM)

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 to KB Topic: Language Basics
11 years ago, and updated 10 years ago
(5 Comments , last by Schnell.h )

Code

KB Post
Nothing New Since Your Last Visit
21790
Hits

Mike Prestwood
2. Access Team Blog http://blogs.msdn.com/access/
11 years ago
(3 Comments , last by pham.y )

Link
Nothing New Since Your Last Visit
6545
Hits

Wes Peterson
3. Don't overlook the power of a relational database! 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 to KB Topic: Language Basics
12 years ago, and updated 12 years ago
(2 Comments , last by cruz.j )

KB Post
Nothing New Since Your Last Visit
9205
Hits

Mike Prestwood
4. 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
14644
Hits

Mike Prestwood
5. 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  
11448
Hits

Mike Prestwood
6. 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  
26095
Hits

Mike Prestwood
7. Access VBA Parameters (ByRef, ByVal)

By Reference or Value
For parameters, you can optionally specify ByVal or ByRef. ByRef is the default if you don't specify.

Posted to KB Topic: Access & VBA
11 years ago, and updated 10 years ago
(3 Comments , last by Owen.G )

Code
Nothing New Since Your Last Visit  
11751
Hits

Mike Prestwood
8. Access Version Compatibility Can I use an Access 2002 application in Access 2003?
11 years ago, and updated 11 years ago
(2 Comments , last by pham.y )

FAQ
Nothing New Since Your Last Visit
9376
Hits

Mike Prestwood
9. Microsoft Access 1.0 Released Microsoft releases MS Access early in order to beat Paradox to market.
11 years ago, and updated 11 years ago
(3 Comments , last by Armstrong.S3 )

News
Nothing New Since Your Last Visit
4630
Hits

Mike Prestwood
10. 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  
12235
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