Hello,
I am running an make table query via VBA. My problem is that while the query is running a message will pop up (ACCESS Dialog Box) stating
1. I am about to delete an existing table (Then you have a choice of answer Yes/No or Help)
2. Then it states that XX number of lines will be written to the new table (again Yes/No).
As I am very new to VBA, I would like to know,
How can a sequence a code such that I can answer automatically when these dialog boxes appear. I know through ACCESS I can disactivate these confirmations (dialog boxes) but I would like to know how I can adjust my responses since it is possible in the 1st popup it will require a YES and in the 2nd a No.
Thank you,
DAX1
I am running an make table query via VBA. My problem is that while the query is running a message will pop up (ACCESS Dialog Box) stating
1. I am about to delete an existing table (Then you have a choice of answer Yes/No or Help)
2. Then it states that XX number of lines will be written to the new table (again Yes/No).
As I am very new to VBA, I would like to know,
How can a sequence a code such that I can answer automatically when these dialog boxes appear. I know through ACCESS I can disactivate these confirmations (dialog boxes) but I would like to know how I can adjust my responses since it is possible in the 1st popup it will require a YES and in the 2nd a No.
Thank you,
DAX1