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. The ChrW() function takes a “Decimal Numeric Character Reference” as an input and returns a character as the output. The ChrW() function can be used …
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 data in your form as you soon as you begin typing. The more you type, the more it will filter the data. The search box …
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 built into Access. To run it, select Database Tools from the menu and then select Compact and Repair Database. The second method is to run …
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. Every time we find a record where the person is from Texas, we will write this record to the output table. Finally, after we finish …
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 characters we want to keep. In this example, we wish to keep numbers 0 through 9 and letters A through Z. All other characters will …