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

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE
   ► KBDesktop Data...Access & VBAAccess VBALanguage Basics   Print This     

Access KB: Language Basics Topic



20 Articles Found in the Language Basics Topic 

  KB Article    

Mike Prestwood
1. Access VBA Assignment (=)

Access uses = for it's assignment operator.

9 years ago

Code
Nothing New Since Your Last Visit
4142
Hits

Microsoft Access

Mike Prestwood
2. Access VBA Case Sensitivity (No)

Access VBA is not case sensitive. Like VB Classic, if you type any other case for command or variable names, Access VBA will change it to the "accepted" or "defined" case. For example, if you type msgbox it is converted to Msgbox.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit  
7877
Hits

Microsoft Access

Mike Prestwood
3. Access VBA Code Blocks (End Xxx)

Access VBAcode blocks are surrounded by statement ending keywords that all use End such as End Sub, End If, and WEnd.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
6229
Hits

Microsoft Access

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

9 years ago, and updated 8 years ago
(1 Comments , last by Jasmine.C )

Code

KB Post
Nothing New Since Your Last Visit
17063
Hits

Microsoft Access

Mike Prestwood
5. Access VBA Comparison Operators (=, <>)

Save as VB Classic.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
6934
Hits

Microsoft Access

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

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
7328
Hits

Microsoft Access

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).

8 years ago

Code
Nothing New Since Your Last Visit
6526
Hits

Microsoft Access

Mike Prestwood
8. Access VBA Development Tools

Languages Focus: Development Tools

Primary development tool(s) used to develop and debug code.

Access VBA Development Tools

Microsoft Office Access is the primary tool and does include pretty good debugging features, some limited OOP features such as designing a class and instantiating an object, and, best of all, MS still has developers working on MS Access (as opposed to Corel Paradox).

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
4673
Hits

Microsoft Access

Mike Prestwood
9. Access VBA End of Statement (Return)

Languages Focus: End of Statement

In coding languages, common End of statement specifiers include a semicolon and return (others exist too). Also of concern when studying a language is can you put two statements on a single code line and can you break a single statement into two or more code lines.

Access VBA End of Statement

A return marks the end of a statement and you cannot combine statements on a single line of code. You can break a single statement into two or more code lines by using a space and underscore " _".

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
4589
Hits

Microsoft Access

Mike Prestwood
10. Access VBA File Extensions (.MDB)
  • .MDB - Access Database
  • .MDE - Protected Access Database
9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
7280
Hits

Microsoft Access

Mike Prestwood
11. Access VBA If Statement (If..ElseIf..Else..End If)

The End If is optional if you put your code on a single line.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
5808
Hits

Microsoft Access

Mike Prestwood
12. Access VBA Literals (quote)

Literals are quoted as in "Prestwood". If you need to embed a quote use two quotes in a row.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
6586
Hits

Microsoft Access

Mike Prestwood
13. 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

8 years ago, and updated 8 years ago
(3 Comments , last by Uwais.Q )

Code

Article
Nothing New Since Your Last Visit  
21031
Hits

Microsoft Access

Mike Prestwood
14. Access VBA Overview and History

Microsoft Access is a class-based language. Although you can create classes, Access VBA is not fully OOP. You can create classes, but not inherit from them. It is a traditional language with a few OOP extensions. You code in a traditional approach using functions, procedures, and global data, and you can make use of simple classes to help organize your reusable code. Microsoft Access is most suitable for creating business desktop applications that run within Microsoft Access for Windows.

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
5799
Hits

Microsoft Access

Mike Prestwood
15. Access VBA Report Tools Overview (Built-In)

Microsoft Access offers a built-in reporting tool that will suffice for most desktop database applications.

9 years ago, and updated 9 years ago
(1 Comments , last by Anonymous )

Code
Nothing New Since Your Last Visit
6140
Hits

Microsoft Access

Mike Prestwood
16. Access VBA String Concatenation (& or +)

Although you can use either a & or a + to concatenate values, my preference is to use a + because more languages use it. However, if you use & then some type conversions are done for you. If you use + you will sometimes have to cast a value to concatenate it. For example, you will have to use CStr to cast a number to a string if you use the + operator as a concatenation operator.

9 years ago, and updated 8 years ago
(1 Comments , last by robert.h5 )

Code
Nothing New Since Your Last Visit
7176
Hits

Microsoft Access

Mike Prestwood
17. Access VBA Unary Operators

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

9 years ago, and updated 8 years ago

Code
Nothing New Since Your Last Visit
6181
Hits

Microsoft Access

Mike Prestwood
18. 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.

9 years ago, and updated 8 years ago

Code

KB Post
Nothing New Since Your Last Visit
11986
Hits

Microsoft Access

Wes Peterson
19. 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.
10 years ago, and updated 10 years ago

KB Post
Nothing New Since Your Last Visit
6151
Hits

Microsoft Access

Mike Prestwood
20. Watch Your Access Evaluations!

Execute more common evaluations first! Short-circuit evaluation is a feature of most languages where once an evaluation evaluates to False, the compiler evaluates the whole expression to False, exits and moves on to the next code execution line. In Access VBA, the if statement does not support short-circuit evaluation but you can mimic it. Use either an if..else if..else if statement or nested if statements. You will find that your code that makes use of this technique will be clearer and easier to maintain than the short-circuit equivalent and will execute faster than ignoring this issue.

9 years ago

Tip
Nothing New Since Your Last Visit
5284
Hits

Microsoft Access

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).

New Microsoft Access Knowledge Base Post...

Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).

Post New...

Tidbit Post: Short Flashcard FAQ Definition Quick Tip Code Snippet
Longer Post: Full Article General Post File Link Error News
Other: Blog Topic
Or, if YOU have a question...
  Microsoft Access Message Board
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

1,940 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


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