Access Tutorial 12: An Introduction to Visual Basic
Programming can be an enormously complex and difficult activity. Or it can be quite straightforward. In either case, the basic programming concepts remain the same. This tutorial is an introduction to a handful of programming constructs that apply to any “third generation” language, not only Visual Basic for Applications (VBA).
Strictly speaking, the language that is included with Access is not Visual Basic—it is a subset of the full, stand-alone Visual Basic language (which Microsoft sells separately). In Access version 2.0, the subset is called “Access Basic”. In version 7.0, it is slightly enlarged subset called “Visual Basic for Applications” (VBA). However, in the context of the simple programs we are writing here, these terms are interchangeable.
Interacting with the interpreter
Access provides two ways of interacting with the VBA language. The most useful of these is through saved modules that contain VBA procedures. These procedures (subroutines and functions) can be run to do interesting things like process transactions against master tables, provide sophisticated error checking, and so on.
The second way to interact with VBA is directly through the interpreter. Interpreted languages are easier to experiment with since you can invoke the interpreter at any time, type in a command, and watch it execute. In the first part of this tutorial, you are going to invoke Access’ VBA interpreter and execute some very simple statements.
Get pdf Access Tutorial 12: An Introduction to Visual Basic
Related Tutorial
Tags: access tutorial, access vba, basic language, handful, interesting things, interpreter, languages, microsoft, programming concepts, programming constructs, subroutines, subset, third generation language, time type, two ways, vba language, vba procedures, visual basic for applications, visual basic programming
Comments
Leave a Reply