Showing Messages after Queries Run

  • Thread starter Thread starter Noel
  • Start date Start date
N

Noel

Hi. I have a few Update and Amend queries in my mdbs.
When the users run these, there is no visible indication
that the query had completed, apart from watching the
little progress indicator at the bottom left of the
window. I thought it would be a bit more user friendly if
I could make access present a message, with an OK button,
when certain queries have been run. The message could say
something like Action Completed. Is this possible? Im
using XP and Access 2002. Thanks, Noel
 
DoCmd.SetWarnings False before you run the query, DoCmd.SetWarnings True
after you've run it.
 
Thanks Doug. Sorry but I dont understand. Surely your
suggestion will stop warning messages appearing while a
Query is running. Thats not what I want. I want to be
albe to create a message that the query presents to the
user when it has completed. Could you expand a little on
your answer please? Thanks, Noel PS - I thought Id posted
this in the queries section - will repost there.
 
How are you running the queries? Assuming it's through VBA code (or even
using a Macro), simply pop up a message box after you run the last query.
 
Thanks Doug. I havent used message boxes anywhere yet.
Ill have a look at help. Thanks again for your help. Noel
 
MsgBox "Your Message Here",,"Your Caption For The Message Box Here"

You will get a message box with "Your Message Here" in the body, ",,"Your
Caption For The Message Box Here" as the tiitle in the blue bar and an OK
button.
 
Thanks for this. Cheers, Noel
-----Original Message-----
MsgBox "Your Message Here",,"Your Caption For The Message Box Here"

You will get a message box with "Your Message Here" in the body, ",,"Your
Caption For The Message Box Here" as the tiitle in the blue bar and an OK
button.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com





.
Click to expand...
 
Back
Top