Solved

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

Posted on 2003-12-04
2
663 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in June's Course of the Month

June’s Course of the Month is now available! Experts Exchange’s Premium Members, Team Accounts, and Qualified Experts have access to a complimentary course each month as part of their membership—an extra way to sharpen your skills and increase training.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

726 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