I currently have a macro setup in Access 2007. What I would like to do is use this macro but before the changes are made, import a file from a network drive. I'm not sure if that has to be done through a module. How can I have the file automatically imported into access 2007 and then call on the macro in Access 2007?
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.