databasedev.co.uk - database solutions and downloads for microsoft access

Microsoft Access Database Modules and VBA Programming and Coding

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.

Hopefully you will find something of interest, whether you need to display the user's name when using the database, validate information being entered into your Microsoft Access forms, to showing the common dialog box that many Microsoft Windows users are used to seeing. These VBA programming routines will help automate some of the common tasks performed in your Microsoft Access development.

Microsoft Access Modules and VBA

Topic Date Submitted Downloadable File
Capturing the Network User Name

Tested on Access 2000

23/05/2002 N/A
Creating a Progress Meter

Tested on Access 2000

13/07/2002 N/A
How to Disable/Enable the Shift Bypass Key

Tested on Access 2000

11/10/2002 N/A
How to use the Common Dialog API in an Access Database

Tested on Access 2000

10/04/2003 [36 KB]
Convert Text to Proper Case or Upper Case

Tested on Access 2000, Access XP and 2003

21/06/2004 N/A
How to list All tables contained in a Database

Tested on Access 2000, XP and 2003

09/07/2004 N/A
Requiring Data Entry into Form Fields

Tested on Microsoft Access 2000, XP and 2003

13/08/2004 N/A
Recover a Deleted Database Table

Tested on Microsoft Access 2000, XP and 2003

19/08/2004 N/A
Stop mouse wheel from scrolling through records in a Microsoft Access form

Tested on Microsoft Access 2000

01/09/2004 [50 KB]
Get UserName of User logged into the network or retrieve the current ComputerName

Tested on Microsoft Access 2000

15/10/2004 N/A
Preventing Numeric Data from being entered into a Text field

Tested on Microsoft Access 2000 and 2002

19/10/2004 N/A
Validating Required Data in Microsoft Access Text boxes

Tested in Microsoft Access 2000 and 2002

18/02/2005 N/A
Exporting Data from Microsoft Access with VBA Code 06/02/2008 [29 KB]
Importing Data into Microsoft Access using VBA 07/02/2008 [29 KB]
Input validation with VBA 05/07/2008 N/A
Using Text Files with Microsoft Access 07/06/2009 N/A
Control Structures in VBA 13/04/2010 N/A
Prompt For Saving a Record in VBA 27/07/2010 N/A
Calculating Working Days in Microsoft Access 14/11/2010 N/A
Error Handling In Microsoft Access 28/11/2010 N/A

Microsoft Access Database Development With VBAStill using Macros to automate tasks in your database? Then you should be looking at using VBA. Take a look at the following ebook for lots of information and exercises.

Microsoft Access Database Development with VBA

This electronic book (ebook) teaches how to create database applications using the Microsoft Visual Basic For Applications (VBA) language as it is implemented in Microsoft Access. The lessons follow our detailed step-by-step approach with clear instructions and real-life exercises.

Topics covered in this book are:

  1. Introduction to VB Access
  2. Objects Fundamentals
  3. Introduction to Collections
  4. Data Types and Variables
  5. DAO, ADO, ADOX, and SQL
  6. Modules, Procedures, and Functions
  7. Conditional Statements
  8. Error Handling
  9. The Tables of a Database
  10. The Columns of a Table
  11. The Forms of an Application
  12. The Windows Controls of a Form
  13. The Records of a Database
  14. Data Entry and Record Maintenance
  15. Introduction to Built-In Functions
  16. Strings
  17. Querying a Database
  18. Printing
  19. Relationships and Data Integrity
  20. Data Joins
  21. Details on Creating Queries
  22. Data Analysis
  23. Queries-Based Functions
  24. Relationship-Based Operations
  25. Introduction to Record Sets
  26. Operations on Record Sets
  27. Data Views and Stored Procedures

Download the ebook now - Microsoft Access Database Development With VBA