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

Prevent Confirmation of update 1

Status
Not open for further replies.
delpino

delpino

Programmer
Dec 29, 2000
17
0
0
GB
I'm running a Module which updates a table, but unfortunately it asks for confirmation of the update process. can i prevent that somehow, cause its a bit annoying to confirm hundreds of times..
 
Sort by date Sort by votes
SetWarnings to False at the start
Code: 
DoCmd.SetWarnings False
and then remember to SetWarnings to true again at the end ( And also in any Error routine that you have to ensure Warnings are set regardless of how the module ends.
Code: 
DoCmd.SetWarnings True


G LS
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Spurious Change of Fonts
Replies
3
Views
96
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Hyperlink Text of a field
Replies
1
Views
66
caykamanj1966
caykamanj1966
TrekBiker
  • Locked
  • Question
Forcing Form Updates
Replies
2
Views
85
TrekBiker
TrekBiker
priac
  • Locked
  • Question
Create a Duplicate of an Existing Record in Microsoft Access but leave some fields blank.
Replies
7
Views
183
Andrzejek
Andrzejek
TrekBiker
  • Locked
  • Question
Prevent opening form from Navigation Pane 1
Replies
2
Views
46
TrekBiker
TrekBiker

Part and Inventory Search

Sponsor

Back
Top