Create Macro from Append Query

[stacie]

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

 

[Wolfgang Kais]

Hello stacie.

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 don't understand the question, and I quess many other don't either.
What is "refreshing an append query"? Do you want to automate running
the 50 append queries when opening the database? If so, create a macro
and name it "AutoExec". Use the "SetWarnings" action to disable warnings
for your append queries and then use the RunQuery action 50 times for
the 50 append queries in the correct order.
Although it is not necessary, use SetWarnings in the end to re-enable
warnings.

I have never written query's in access before only excel.

Well, you have written 50 append queries, didn't you?