• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 740
  • Last Modified:

How can I automatically answer "yes" to pop up windows in Access?

Hi Experts,

How can I automatically answer "yes" to msgbox windows in Access?

A Yes/No msgbox pops up when I run a Make Table Query. How can I send a "yes" using VBA?

Thanks
0
indyng
Asked:
indyng
1 Solution
 
Benjamin_LukCommented:
Please use code to do Make Table Query
First delete the old table,and make the table using SQL:

On error resume next
DoCmd.DeleteObject acTable, "Your Table"
DoCmd.OpenQuery "Make Table Query"

You can create  one button, and add this code, but please revise the table name & SQL first

Regards

Ben
0
 
Drizzt95Commented:
Just add the following before your make table query code:

Docmd.Setwarnings False

And the after make table query code add:

Docmd.Setwarnings True
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now