Macro for making Query's run automaticlly?

  • Thread starter Thread starter NervousFred
  • Start date Start date
N

NervousFred

I have built a database in access that is linked directly to a server we have
at my office that brings in outside market information in and stores it. The
information is updated daily. I have created several queries for different
parts of the database would just like to know what the best way (if there is
a way) is to make all my queries run when I open the file. With the querys
run I can just save the file and the new info from the queries will be
updated.

Thanks!
 
Fred,

I assume you are talking about Action Queries (i.e. Append, or Update,
or Make-Table). If so, you can use the OpenQuery action in your macro
to run each query.
 
would just like to know what the best way (if there is a way) is to make
all my queries run when I open the file.
Create you macro and name it Autoexec.
It will run everytime you open the database unless you hold down the shift
key.
You could have a table to record each date it is run and use a condition to
not run if already run on the current date.
 
Back
Top