Create a Macro w/Append Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I have about 50 append query's created that are based on both linked and
imported tables. I have set up each append query to once refreshed to
repopulate my master table, however, I don't want to have to refresh the
query's daily. How do I set something up to automate the process once the
file has been opened. I have never written query's in access before only
excel.

Please help!!!
s
 
Stacie,

I am not sure what you mean by "refresh the queries". But you can
certainly use an OpenQuery action in a macro to run each of your append
queries. And this can be automated by assigning this macro on a
suitable event property, let's say the Open event of a form, or the
Click event of a command button.
 
Back
Top