Category Archives: Access Functions

Clear multiple temp tables on Access close

This code is for illustration purposes only.  ALWAYS back up your database before you make changes. We all use temporary tables in Access but we don’t always remember to clear them.  You can write a query to clear each temp … Continue reading

Posted in Access Functions | Tagged , | Leave a comment

Combine Records Function for Access

What if you want to attach a report to an email that goes to all of your customers?  You can write code to create the report and send it via the DoCmd.SendObject method.  That will create the report and attach … Continue reading

Posted in Access Functions | Tagged | Leave a comment