Run series of query -- I don't want any pop-up

[ali]

I have generated 4 queries (1. empty all, 2. import data, 3. generate
information, 4. Make a new table)

I've created a button to run these 4 quries sequencially.
------------------------------------------------------------------------------------
Problem:

MS ACCESS pops up "confirmation dialog" to ask me whether to delete/modify
the table.

------------------------------------------------------------------------------------
Question:


I don't want any question to be asked. I just want those queries to be
executed once i press my button.

 

[Duane Hookom]

You can run some code like:

DoCmd.SetWarnings False
' your action queries
DoCmd.SetWarnings True

 

[ali]

Works perfectly !! thanks a lot Duane !