I'm trying to run a make table query, and I'd like to automate it. Is there any way I can do this through a script so that I don't have to answer Yes/No to any of the pop ups? I turned off the notifications, but I still get the odd pop up.
Automated Query
- Thread starter dgmorr
- Start date
boblarson
Smeghead
- Local time
- Today, 07:14
- Joined
- Jan 12, 2001
- Messages
- 32,040
1. Do you have to use a make table query? It will cause your database to bloat excessively if you keep running that over and over. If you use a delete query to delete the data and either an append query or import to import the data to the existing table, that is more efficient.
2. To run action queries without the warnings you can use
CurrentDb.Execute "YourQueryNameHere'
2. To run action queries without the warnings you can use
CurrentDb.Execute "YourQueryNameHere'
