Make Table Query

G

gavinw71

I have created a number of Make Table queries that I have
running as part of a Macro. I would like to automate the
macro as much as possible. Problem is Access continually
prompts for the creation and deletion of the tables when
I run the macro (queries). Is there a way to suppress
these messages and have Access just run the queries
without being prompted. I use Access 97.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Chart on form from selected data in query. 0
Confirm action query runtime option 1
Error on Access Query 10
Macro for Table of Contents 2
Is It Possible to Control Access Warning Pop-Up Message Boxes? 6
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top