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

SQL Insert without warning

Status
Not open for further replies.
pbcharlie

pbcharlie

Technical User
Jan 16, 2002
55
Is it possible to have access to run a macro to insert a line of data without the screen message saying you are about to insert a line of data?
Thanks in advance
Charlie
 
Sort by date Sort by votes
In the macro actions you will see a SetWarning action. Before your insert action, use SetWarnings False and then after the Insert use SetWarnings True. You want to be sure to always turn them back on after you've turned them off.

Paul
 
Upvote 0 Downvote
Easy when you know how. Thank you very Much



Charlie
Thanks in advance
Charlie
 
Upvote 0 Downvote
alternativly in tools / options on edit/find tab untick 'confirm action queries' then you will not recieve any warnings regarding action queries but you will still get error msgs
(this is useful when you are troubleshooting)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
ADO UpdateBatch SQL Server Example?
Replies
2
Views
316
Andrzejek
Andrzejek
Sajjad668
  • Locked
  • Question
insert multiple image on single row in ms access database using vba
Replies
1
Views
188
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Why can't I suppress warnings after Update Query? 3
Replies
14
Views
255
xweyer
xweyer
BJZeak
  • Locked
  • Question
SQL Solution?
Replies
1
Views
135
Darrylles
Darrylles
monkeysee
  • Locked
  • Question
Warning Message for change of data in a Form Field 3
Replies
4
Views
159
monkeysee
monkeysee

Part and Inventory Search

Sponsor

Back
Top