Home » Microsoft Access » Modules and VBA

Access/VBA Tutorials

Microsoft Access Modules and VBA tutorials

When a record is deleted from a form's recordset, then bookmarks are used to go to another record more than 262 records away from the deleted one, it appears as though the record with the correct ID is being edited, but in fact a record offset positively from that one number of records deleted) is actually edited. What you see is NOT what you get - the wrong record is edited.

Related Tutorials

VBA For MS Access
Microsoft Access is a development environment used to create computer-based databases. To complement it, it ships with a programming language called Visual Basic For Application (VBA). This tutorial provides, examples, and tutorials on how to use VBA in MS Access.

VBA For MS Access
Microsoft Access is a development environment used to create computer-based databases. To complement it, it ships with a programming language called Visual Basic For Application (VBA). This FunctionX site provides lessons, examples, and tutorials on how to use VBA in MS Access.

VBA Basics in Access 2003/XP/2000/97 (page 1 of 7)
What is VBA? VBA standards for Visual Basic for Applications and is the language embedded within your Access database.

Microsoft Access Tutorial
The programming of Access is divided into two pieces: macros and Visual Basic for Applications (VBA). The response to an event can be either a macro or VBA procedure (also called code). You can also create VBA code for general use throughout Access.

VBA - Accessing Access
The inner circle of the VBA hosting environment includes all of the Office applications. Access, Frontpage, PowerPoint, and Outlook all have VBA environments ... but there aresome very significant differences between them. Of the non-Office applications, Visio, Project and MapPoint also have VBA environments.

Microsoft Access Tutorials
Microsoft Access Beginners Tutorial including Mail Merge, Labels and VBA Tips & Tricks.

Microsoft Access Report Tutorials
Here you will find articles and tutorials relating to Microsoft Access Database report designs, from customising the layout of the report to including parameters and images. You will also find articles relating to generating your Microsoft Access database reports from forms in your Microsoft Access application, and how to modify database reports using VBA programming and Microsoft Access expressions.

Jump Start VBA Skills with MS Access Macros
Macros help to speed up the performance of certain repetitive tasks when using an application. They are used extensively in all office-related software. As a programmer, you can leverage the built-in macro object in MS Access to get a head start in understanding VBA. This article explains how. TOC: Jump Start VBA Skills with MS Access Macros; Creating and running a macro in MS Access: opening the macro designer; Creating the first macro; Converting this macro to VBA code; Creating the second macro.

Automate applications with macros in Access 2007
If you have been using Access in the past, the easiest way to automate the tasks would have been by using the macros. On the other hand, programmers might have realized that writing VBA (visual basic for applications) modules is the best way to automate things in any Access database. Access 2007 makes it very easy to create macros. In previous versions, many macros could not have been created without using VBA code but in Access 2007 new features have been added to eliminate the need of using VBA code.

Preventing Changes to your Microsoft Access VBA Code
If your database contains Visual Basic for Applications (VBA) code procedures, you want to ensure that your users can't make changes unless authorised or qualified to do so. Access to the code can be prevented in a couple of different ways: Password protecting your VBA code.Saving the database as a Microsoft Database Executable (MDE) format.

MS Visual Basic for Applications
How to use Visual Basic for Applications (VBA) with MS Office tools, including VBA for MS Excel, VBA for MS Word, VBA for MS Access, and a general overview of Microsoft Visual Basic for Applications.

Copy SQL statement from query to VBA
Rather than typing complex query statements into VBA code, developers often mock up a query graphically, switch it to SQL View, copy, and paste into VBA. If you've done it, you know how messy it is sorting out the quotes, and the line endings. Learn how to build a form that massages the SQL statement from a query, so it can be pasted into a VBA procedure in Microsoft Access.

Exporting Data from Microsoft Access with VBA Code
Access gives you two ways to export data, visually by going to File-Export and then selecting an export format from a dialog box or by using VBA code. In this article we will be looking at how to export Access data using VBA code, since even a beginner can use the visual interface to export data. Using VBA code requires some ability to write code and also a basic understanding of the target application’s object model. So why code? Because it offers you a wider choice of formats to export data to. It supports all the formats that is available in the dialog box as well as a whole host of others such as Microsoft Outlook contacts, appointments or a Word document.

Compact your database with VBA
Have you experienced the problem with increasing size of your MS Access files? Do you need to compact your databases from time to time, especially when they reach specific file size? Then we have a solution build in VBA that could be easily implemented to any MS Access database (this code applies to Access Version 2000 and later).

Access Tutorials
Download MS Access tutorials in pdf and doc file format.

Modules and VBA Programming
Here you will find articles relating to Microsoft Access Modules and Microsoft Access VBA Programming and Coding. These programming routines will allow you to add customised features to your Microsoft Access database applications.

MS Access 2000 Tutorials and Documentation
Some of the following tutorials are available as .PDF files which you can download and print. Others can be run from the Web. In that case, a sample Access database is usually available for download from the first page of the tutorial.

Microsoft Access Tutorials
Looking to learn about Microsoft Access? This collection of tutorials includes materials for novices and advanced users alike.

Access 2007
A complete series of Microsoft Access 2007 Tutorials in pdf file format. (More than 50 ready to download tutorials).

Free Microsoft Access 2007 Video Tutorials
These are short Microsoft Access 2007 video tutorials on some common basic Access database development tasks.

Table of Contents
A complete set of Microsoft Access Tutorials (pdf file format, install Acrobat Reader to read these tutorials).

Access Help, Tips and Tutorials
If you are finding that you are getting unexplained errors with your applications as you develop or you have noticed that it seems to be running slower then it may be time to use the rarely mentioned decompile option on your application. When you compile VBA code various pieces of old code often get left behind. Decompile is a relatively unknown Access feature than can help drastically reduce the size of front end databases and also reduce bloating and decrease start-up times is the /decompile option. The /decompile command line option cleans out these bits of code and allows for a fresh start.

MS Access, ODBC, SQL, year 2000, tutorials
Microsoft Access Page includes tutorials, solutions, SQL, ODBC, Oracle and more.

Get started with Access programming
When you create a new database, you typically begin by creating a few database objects such as tables, forms, and reports. Eventually, you reach a point where you need to add some programming to automate certain processes and tie your database objects together. This article helps orient you to the programming tools in Microsoft Office Access 2007 and points you to some resources where you can learn more about programming. In this article: What is programming? Should I use macros or should I use VBA code? Use the Command Button Wizard to perform common programming tasks, Understand macros, Understand VBA code, Convert macros to VBA code, Learn how to use the Help system.

Introduction to DAO, ADO, ADOX, and SQL
Microsoft Access ships with a language named Visual Basic For Applications, or VBA. This allows you to complement MS Access with code that can perform complex operations. This language is used throughout the Microsoft Visual Office family of applications, including Microsoft Excel, Work, PowerPoint, Visio, etc. This language is also used by applications published by companies other than Microsoft. An example is Autodesk that publishes AutoCAD. To customize the VBA language for our database environment, Microsoft Access includes a library called Microsoft Access Object Library. Topics Microsoft Access Object Library and VBA, Microsoft Data Access Objects, Database Creation With DAO, The Structured Query Language, Introduction to SQL Operators, Unary Operators, Binary Operators, Microsoft ActiveX Data Objects, ADOX Fundamentals, The Data Source of an Application and The Connection to a Database.

Database variable not defined error
I'm running an Access 2003/XP/2000/97 database with some VBA code in it. Within the VBA code, a database object is declared as follows: (Dim db As Database) When this code is encountered, Access highlights the line and I receive the following error message: (Compile error: User-defined type not defined) I've seen this code work in other Access databases. How come it does not work in mine?

Forms
Form Basics (Understanding and creating forms), Combo Box Basics, Tab Control (Creating tabbed pages on a form), VBA Basics (Understanding the VBA environment), Debugging VBA Code (Understanding VBA's Debugging Environment) in Access 2003/XP/2000/97

How to make design changes to an Access MDE file
A common question in Access database newsgroups and forums is 'How can I convert my Access database from MDE format into an MDB file?' If your file contains VBA code then the correct answer is that you can't since the MDE file is locked and protected. However, the protection isn't the main obstacle in trying to convert the MDE file, the main issue is that all VBA modules are saved in a compiled state with any original source-code being stripped out.

Advanced Ideas using VBA
You need a procedure that will work on a list of items, and you don't know ahead of time how many there will be. You know that VBA will allow you to use optional parameters, but this requires you to know exactly how many items you might ever need to pass, and in your case, it's impossible to predict that value. How can you accomplish this? TOC: Advanced Ideas using VBA; Sort an Array in VBA; Fill a List Box with a List of Files; Handle Object Properties, in General; Detect Whether an Object Exists

VBA how tos
How to add a field to a table. How to assign a primary key to a table, a foreign key to another table and establish a relationship between these two tables. How to back up files from one directory to another. How to compact the current database automatically when it reaches a certain size. How to compare the contents of two directories. How to connect to an Access database with ADO after it has been secured with user-level security. How to connect to an Access database with ADO after it has been secured with shared-level security. How to copy the current record on the form. How to create a desktop shortcut to open a database with a command line parameter. How to create a listing of the Access and Jet errors. How to delete a field from a table in VBA. How to delete a file in VBA. How to delete a table in VBA. How to determine a file's size. How to determine the default file format. How to format a string with varying numbers of leading zeros. How to get individual items passed to another form using OpenArgs. How to get the Error Description from the Error Number. How to hide tables in VBA. How to link to a table located a database that has a database password. How to modify the system warning messages. How to prevent "Invalid use of Null" error when using the DLookup( ) function. How to prevent users from sharing a common front end database file located on a networked server. How to rename a file in VBA. How to programmatically select the first record on the subform. How to set database options using VBA while creating a new database. How to set the macro security level in Access 2003 runtime.

Building an Access Database From the Ground Up
In this series of Microsoft Access tutorials, we follow the database administrators for Patrick's Widgets as they build a Microsoft Access database from the ground up. Below you'll find the complete listing of tutorials in this series.

PIE Chart Object and VBA
This is the continuation of a discussion on working with Chart Object in VBA. We have created a small Table and a Report with a Chart Object on it, in the earlier Post Working with Chart Object in VBA and gone through few simple Property changes on the Chart Object to get prepared for the Demo of the VBA Programs. Please go through Steps 1 to 7 explained in the earliest Post, by following the link above, and continue.

Learning the basics of programming
ACCESS provides two ways of interacting with the VBA language. The most useful of the two is saved modules that contain VBA procedures. Procedures are batches of programming commands that can be executed 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. When you type a statement into the interpreter, it is executed immediately. Although there is little business use for this feature, it does making learning the language and testing new statements easier. (pdf file, install Acrobat Reader to read this tutorial)

Database Connection String Properties
Opening external data sources like dBase, Excel, Table from another MS-Access Database directly in VBA Code is only one of the options available to us. Those who are not comfortable with VBA have a better and much easier method available, without linking them permanently to MS-Access Database. In either case one thing is certain that we must know how to reference different external data sources correctly with Source Database Path and Connection String Values. But, these are very easy to learn.

Microsoft Access help, tutorials, examples
Brief tutorials and help for novices and database developers. Examples and solutions to implement. Bugs and traps to avoid. Sample code and utilities to download.

Microsoft 2007 Office Tutorials
Because of the significant enhancements from Office 2003 to 2007 we created an Introduction to 2007 Office tutorial to give you an overview of the new features across all of the 2007 Office applications. The content for the PowerPoint, Access, Excel, Publisher and Outlook Mail tutorials remains consistent from previous versions - only updated to include the new features of 2007 Office. You can find what is covered in each tutorial by clicking the individual content links on the left (for example - Access Database Modules 1 & 2, etc). All of the 2007 Office Tutorials are saved in "old" Word format for your convenience.

Import an Access 95 database into an Access 2007 file
If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format. What do you want to do? * Import data from an Access 95 database * Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

Importing Data into Microsoft Access using VBA
You might be wondering why you would want to use VBA code to import data while you have so many other options available when doing it the visual way. Well, there are two main reasons: Importing data through VBA code enables you to work with a variety of formats that is not available when you do it using the visual interface such as delimited text in a text file or data in a word table. On a more practical level, if you need to make the same import every time, then simply creating a function to do the job for you will make the process faster and easier as opposed to going through the import wizard every time.

DataPig Access Training
Learn basic access concepts; improve your Access Reports; advanced Query tips; user Form basics and tricks; getting started with VBA

Access/VBA Tutorials

View Tutorial