• Sample Visual Basic Program Code
• Using Visual Basic In Access
• Visual Basic Code Examples For Access Point

Example: Visual Basic - Access and return data by a call to a procedure A Visual Basic example demonstrates creating, preparing, binding, and calling a DB2 for IBM i procedure. Examples: ILE RPG - Host code for ODBC procedures In this example, the program, SPROC2, is called from the client as a procedure via IBM i Access ODBC using a CALL. In Access, programming is the process of adding functionality to your database by using Access macros or Visual Basic for Applications (VBA) code. For example, suppose that you have created a form and a report, and you want to add a command button to the form that, when clicked, opens the report. Before we write the code that connects our visual basic program to ms access, we will first add the Microsoft ADO 2.8 library in our visual basic. To add the Microsoft ADO 2.8 library, in the menu bar select Project and select References.

This MSAccess tutorial explains the VBA environment in Access 2003 (with screenshots and step-by-step instructions).

See solution in other versions of MSAccess:

What is VBA?

This is what the VBA environment looks like in Microsoft Access 2003:

VBA standards for Visual Basic for Applications and is the language embedded within your Access database.

Sample Visual Basic Program Code

You use VBA whenever you do one of the following:

Using Visual Basic In Access

1. Create a new function.
2. Create a new subroutine.
3. Define a global variable.
4. Place code behind an event procedure such as the 'On Click' event of a command button.
5. Execute the RunCode action in a macro.

Visual Basic Code Examples For Access Point

These are just some of the examples of when you might be running VBA code.