automation of a make table query

sha7jpm

Registered User.
Local time
Today, 01:31
Joined
Aug 16, 2002
Messages
205
I have a make table query that populates a email list in a table from MS outlook.

I need a way to automate this so that every time the user opens the database or once a week etc, the query runs and the table is updated.

so...
1. I need a way to do this automatically.
2. I need to find a way of disabling the msgboxes that appear when you run a make table query. so that the update runs in the background and the user does not see any messages relating to the make query routine,


any pointers?

ta

John
 
Hi

Not sure about getting a table from email but the 2nd part is done with the SetWarnings command.

SetWarnings = No switches off all the messageboxes etc. you do need to remember to reset the SetWarnings to Yes when the query has run though.

Sorry I can't be more helpful, I'm sure someone will respond to the first part though.

Col
 
no that is really useful.

many thanks

I have the email link all sorted.

using a MS exe patch,

it was the disabling of the message boxes that I needed to solve,

thanks for the help.

I'll give that a go.

ta

John
 
Hi,

I know of one way to handle your second question.
Create a macro like this :
SetWarnings - No
OpenQuery - YourMakeTableQuery.

Good luck :)
Gina.
 
success!

cheers Gina,

that worked perfectly.

much obliged.

John
 

Users who are viewing this thread

Back
Top Bottom