Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with Make-Table Queries

Status
Not open for further replies.
ITGUY99

ITGUY99

MIS
Jan 17, 2002
31
US
Does anyone know how to automate a MAKE-TABLE QUERY so that I do not get any dialog boxes telling me that it is going to overwrite the existing table.

Thanks in advance.
 
Sort by date Sort by votes
in a macro choose ECHO and set ECHO ON to no then choose set warnings to NO. Then put in the RUN QUery command.

That should take care of it.


HTH,


Danny
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

A
  • Locked
  • Question
Print Table attachment
Replies
2
Views
317
andre.meyer
A
ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
5K
OCM
OCM
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
982
renigar
renigar
TheresAlwaysAWay
  • Locked
  • Question
Crazy question: Can anyone help me create a routine to roll 2 dice 1000x and sum them? 4
2
Replies
22
Views
6K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top