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

Append Row without Confirmation

Status
Not open for further replies.
Max1mum2

Max1mum2

Programmer
Jan 30, 2003
13
US
How could I do this without the : "You are about the append (x) Rows" Confirmation?

DoCmd.RunSQL(SQL)


THANKS IN ADVANCE


- Maximum
 
Sort by date Sort by votes
Docmd.setwarnings False

'Your code here

Docmd.setwarning True

Note your error handling should also set warnings back to True in case you prematurely exit routine.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PCX
  • Locked
  • Question
TransferSpreadsheet method omits last row if there are headers
Replies
1
Views
130
Andrzejek
Andrzejek
Sajjad668
  • Locked
  • Question
insert multiple image on single row in ms access database using vba
Replies
1
Views
104
dhookom
dhookom
nikademous
  • Locked
  • Question
Email Report as Attachment using Caption Name and without Outlook Reference
Replies
1
Views
60
Andrzejek
Andrzejek
03Explorer
  • Locked
  • Question
Append and update SQL table (is this an SSIS task or VBA) within MS Access?
Replies
1
Views
54
simian336
simian336
mmogul
  • Locked
  • Question
Improve Append Query Performance
Replies
5
Views
89
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top