Update Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to customise the message the user sees when the query is run.
Instead of the standard message I would like to put in something like:
"Are you sure you have sent your report and have saved a copy. Please make
sure as this query will change the status to Completed and Done!"
 
I would like to customise the message the user sees when the query is run.
Instead of the standard message I would like to put in something like:
"Are you sure you have sent your report and have saved a copy. Please make
sure as this query will change the status to Completed and Done!"
Click to expand...

You have no control over the message if you run the query directly
from the main application folder.
You can do this if you run the query from an event using VBA:

DoCmd.SetWarnings False
If MsgBox("Are you sure you have sent your report and have saved a
copy." & vbNewLine & "Please make sure as this query will change the
status to Completed and Done!",vbExclamation + vbYesNo) = vbYes Then
DoCmd.OpenQuery "UpdateQueryName"
End If
DoCmd.SetWarnings True

Only your message will display.
The query will only run if Yes is selected.
 
Back
Top