Back To Top

MS Access VBA Examples 2000, 2002, 2003, 2007

Eraserve AP - MS Access VBA Code Index.

Visual Basic for Applications or VBA, is Built into Microsoft Office Applications so Developers can create their own custom solutions. MS Access 2000-2007 all have the ability to use VBA.
This page is dedicated to listing all of our MS Access VBA Tutorials and Examples. All Listings include written and sample code. In the Table below you will find the MS Access Listings and a brief descriptions about the listings. Feel free to link to this page if you find it useful.





All MS Access VBA tutorials and Examples are created in MS Access 2003 and tested in MS Access 2007

All listings include an Access VBA Sample Database .

  • MS Access Autonumber Field with VBA
    Creates an Autonumber field using VBA in Access, Changes a current fields name, Adds a regular Text Field all in VBA on an Existing Table
    "Not Enough Space on Temporary Disk" error work around
    Makes use of a MS Access Form and Module

  • MS Access VBA Append All Tables To Another
    VBA Append All Tables Function, VBA Code to Make a Table and Append all other Tables to it

  • MS Access Append Query in SQL
    Shows how to view the MS Access Append Query In SQL View Not VBA related but it does prove useful when you need to craft SQL statements for VBA Code usage.

  • MS Access VBA Copy Table
    Using VBA Code to Copy a Table in a current Access Database and append the date to the new Table's name

  • MS Access VBA Create Database
    Using VBA to create a new MS Access Database

  • MS Access VBA Create Sample Table
    VBA Make Random Sample Table in a current MS Access Database from another Table

  •  MS Access VBA Create Table
    Using VBA Code to Make a Table in a current Access Database

  • MS Access VBA Change Field Data Type
    Using VBA to Change a Fields Data Type, VBA Code that changes a Fields data Type using ALTER Table ALTER Column

  • MS Access VBA Check if External Table Exists
    VBA Check if External Table Exists, VBA Code to Check for an External table 

  • MS Access VBA Check if Field Exists DAO or ADO
    VBA Check if Field Exists, VBA Code to Check for a Field in a Table

  • MS Access VBA Check if Table Exists
    Access VBA Check if Table Exists, VBA Code to Check for a table

  • MS Access VBA Check if Query Exists
    VBA Check if Query Exists, VBA Code to Check for a Query in a Database

  • MS Access VBA Count All Fields
    Using VBA to Count All Fields, VBA Code that Returns the Number Fields Within a Table

  • MS Access VBA Create Field
    Using VBA Code to create a new Field with several data types available

  • MS Access VBA Count All Tables
    Using VBA to Count All Tables, VBA Code that Returns the Number Tables Within a Database

  • MS Access VBA Delete All Tables
    VBA Delete All Tables Function, Access VBA Code to Delete all Tables using the DROP method in a current Database

  • MS Access VBA Delete Field
    VBA Delete Field Function, VBA Code to Delete a Field in a Table

  • MS Access VBA Delete Table
    VBA Delete Table Function, Access VBA Code to Delete a Table using the DROP method

  • MS Access VBA Delete Records
    Using VBA Delete Query, Access VBA Code to Delete existing records given Criteria

  • MS Access VBA Export Table To CSV
    VBA Export Table Function, VBA Code to Export a Table in a delimited format

  • MS Access VBA Get All Fields
    Using VBA to Get All Fields, Access VBA Code that Returns all Field Names Within a Table

  • MS Access VBA Get all Indexed Fields and Primary Key
    Access VBA Get all Indexed Fields and Primary Key, VBA Code to find a Field's Index and/or find the Primary Key

  • MS Access VBA Get All Tables
    Using VBA to Get All Tables, VBA Code that Returns all Table Names Within a Database

  • MS Access VBA Get All Tables from an External Access Databases
    Using VBA to Get All External Access Database Tables, VBA Code that Returns all the Table Names Within an External MS Access Database

  • MS Access VBA Get SQL string from Query
    VBA Get Query's SQL, Access VBA Code to grab a Query's SQL string

  • MS Access VBA Import all Access Files in a Directory
    Import all External MS Access Database Tables Function, VBA Code to Import all the Tables from all the MS Access Databases in a Directory

  •  MS Access VBA Import all Files in a Directory
    VBA Import File Function, VBA Code to Import all CSV Files in a Directory

  • MS Access VBA Index Field
    VBA Index Field Function, Access VBA Code to set a Fields Index and/or Set a field to Primary Key

  • MS Access VBA Insert Into Select
    VBA Append Query, VBA Code to Append/Insert Into one table from another

  • MS Access VBA Re-Link Tables Function
    VBA Refresh Table Links, VBA Code to Re-Link Tables within a database
  • MS Access VBA Rename Field
    Using VBA to Rename a Field, VBA Code to rename existing fields

  • MS Access VBA Update Field
    Using VBA to Update a Field, VBA Code to Update an existing field

  • MS ACCESS VBA Update Field From Joined Table
    Using VBA to Update Field From Joined Table, VBA Code to Update an Existing Field From a Joined Table

  • MS Access VBA Stop and Wait
    Access VBA Stop and Wait Sub, VBA Code to Stop the application and wait n Seconds