Access Database Recovery

How to Export Your Access Report to a PDF File via VBA

Learn how you can create a VBA function that will allow you to save your Access Report as PDF with just a click of a button. No need to go to the Access Ribbon every time! Access Reports can be manually saved as PDF file. All you have to do is: Open the report. Go to the Access Ribbon: External Data > PDF or XPS. Select the filename and folder path where you would like it to be saved. Click Publish and you’re done. Easy, right? However, if there is a need for you to...

Read more »

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 »