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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do you suppress the message from an APPEND QUERY about adding

Status
Not open for further replies.
ToyFox

ToyFox

Programmer
Jan 24, 2009
161
US
I have an append query that runs as part of a nightly batch. How can I suppress the prompt that asks if I want to add the records to the table. The setwarnings don't seem to work anymore. Thanks
 
Sort by date Sort by votes
Use DAO and a querydef.execute method, that should take the warnings away.
--Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
707
dhookom
dhookom
YoBi4Ever
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
151
dhookom
dhookom
lmcate
  • Locked
  • Question
How to Open ACCESS (MDB) from an HTML Page 1
Replies
2
Views
3K
lmcate
lmcate
Moss100
  • Locked
  • Question
Upgrading from Access 2013 - whats the best option
Replies
2
Views
2K
Moss100
Moss100
OCM
  • Locked
  • Question
Populate access table from excel
Replies
6
Views
3K
OCM
OCM

Part and Inventory Search

Sponsor

Back
Top