How to Display Arrow Characters in MS Access
If you want to display arrows (up, down, left, right, etc) within your Microsoft Access data, you can use the ChrW() function in your VBA code or within your queries….
How to a Create Dynamic Search Form in MS Access
If you want to add an awesome dynamic search box to one of your Microsoft Access forms, this is the post for you. This search box will start filtering the…
How to Reset AutoNumber in MS Access
There are a couple of different ways you can go about resetting an AutoNumber field in a Microsoft Access table. The first method uses the Compact and Repair Database utility…
How to Loop Through Recordset in MS Access
The following VBA example below shows you how to loop through a recordset in Microsoft Access. In this example, we are going to loop through a set of personnel records….
Function to Remove Unwanted Characters from String in MS Access
The following custom function can be used in Microsoft Access to remove or strip out unwanted characters from a string. In the above function, we have defined a list of…
Microsoft Access is a fantastic desktop database application. Using Visual Basic for Application (VBA) in your database can greatly extend it’s functionality. In the above articles, we explore ways to enhance MS Access that have proven useful for us in our many years building custom database applications for customers.