Access Solutions

How to Check if a String Contains an Alphabetical (Non-Numerical) Character via Access VBA

“Cleaning” information before you import it into your database is pretty standard – after all, one of the reasons you’ve started to use a database is so that you can predictably query that database for set criteria right…right? So how you handle external situations where, for example, you have to import info from a file where one person enters “$” but another assumes you know it’s a monetary value – or worse, where someone enters “am” or “pm” but another person uses...

Read more »

How to Replace Texts in a File before Importing It Into Access

As part of our ongoing series of articles covering importing data into MS Access we’re going to cover another common aspect of getting a file ready to be imported – namely, what do you do when you have files to import that have header lines or footers with page numbers on them? Again, as common as this is, MS Access doesn’t have a built in method for handling these files so traditionally you’re left with having to use text processing tools like Monarch Pro to pre-process the files...

Read more »

How to Export the Results of a Query to Multiple Files with Access VBA

Exporting information from Microsoft Access is incredibly easy – assuming you only want to produce a single export file. But what do you do when you need to split a query (or table) into multiple export files? For example, if you need to export a list of customer transactions each month – each customer having their own export file? That’s where this article can help you. Producing an export of 2, 10, or a hundred different exports will be as simple as running a little VBA code snippet and...

Read more »