Solved

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

Posted on 2003-12-04
2
570 Views
Last Modified: 2006-11-17
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
Comment
Question by:indyng
2 Comments
 
LVL 8

Expert Comment

by:Benjamin_Luk
ID: 9880274
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
 
LVL 3

Accepted Solution

by:
Drizzt95 earned 500 total points
ID: 9880560
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now