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