text transfer

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I'm trying to create a macro and the best i can come up with is as follows:

step 1 - Run Query (the action is "openquery" which will open a query which
is a "make table query"

step 2 - Transfer Text. This takes the table created by the make table
query and transfers the data into an html file .

Problems:
1) i need the system to automatically run these two steps every 5 minutes
(bascially updating data which is sent to a server and viewable over the
internet)I don't see a macro function which will let me do this

2) the Run Query keeps prompting me "you are about to run a query that will
modify your data etc..." and "the existing table will be deleted before the
query will run etc..." and " you are about to paste 10 rows into the new
table etc..." i need this to be automated behind the scenes i can't have
these prompts coming up.

Can anyone suggest how i can get this to function behind the scenes
automatically every 5 minutes?

Your assistance is greatly appreciated.
Steve
 
To avoid the warning message, use SetWarnings action (with a value of No) in
the macro just before you run the query.

To run it every five minutes, you'll need to open a hidden form and use that
form's Timer event to run your macro every five minutes (Timer Interval
value of 300000).
 
Steve,

Ken has already answered your questions, but I have another one for you:
do you really need the make table query? That is, do you really need the
table? If the only purpose it serves is for exporting, then you can use
a plain Select query instead and export that one, saving unnecessary
database bloat.

HTH,
Nikos
 
Back
Top