Create a Macro w/Append Query

S

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Creating a Chart on form from selected data in query. 0
help VBA code in macro 2
Create Macro from Append Query 1
Append Queries in a Macro 6
Creating relationships 0
Append query in macro get key violation - by itself no problem 3
Append and delete query through marco 5

Top