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).

--

Ken Snell
<MS ACCESS MVP>

"steve" <(E-Mail Removed)> wrote in message
news:Xns9628CAD87FC3Aspamspamcom@216.196.97.142...
> 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

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

steve wrote:
> 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

thanks works perfectly!

"Ken Snell [MVP]" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> 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).
>