Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / November 2005

Tip: Looking for answers? Try searching our database.

Set warnings on/off in queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JOM - 17 Nov 2005 17:37 GMT
by pressing one button am running 3 update queries that would update 3
different fields in 3 different tables at once and would not like to the
warning that you about to update 3 records three times, however I would like
the user to be informed that the following [Fields] in the following [tables]
with [countRecords] were updated.
I have set the warnings as DoCmd.SetWarnings False.

E.g, Should be like
Fields          Table      Records (This line is just an illustration can be
ignored)

FinalAns       tblNo1     5
FinalAns       tblNo2     5
FinalAns       tblNo3     5

George Nicholson - 17 Nov 2005 19:04 GMT
One possible answer in access.formscoding

Signature

George Nicholson

Remove 'Junk' from return address.

> by pressing one button am running 3 update queries that would update 3
> different fields in 3 different tables at once and would not like to the
[quoted text clipped - 13 lines]
> FinalAns       tblNo2     5
> FinalAns       tblNo3     5
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.