How to create a message to user?

  • Thread starter Thread starter Trip Levert
  • Start date Start date
T

Trip Levert

Hi All,
MS Access 2002. How do I create a message that will open and display (and
stop the query) when a querry is run? I would like the user to know
sompthing about the query before it continues.

Thanks
Trip
 
Trip Levert said:
Hi All,
MS Access 2002. How do I create a message that will open and display (and
stop the query) when a querry is run? I would like the user to know
sompthing about the query before it continues.
Click to expand...

How is the user running the query? If he is pressing a command button on a form
to run it, then you simply use the MsgBox function to display a message in a
line of code the precedes the line that runs the query. You can then even
provide the option to cancel it. If they are just launching the query from the
db window then there is nothing you can do. Queries and tables do not have
events that you can utilize.
 
Thanks!


Rick Brandt said:
How is the user running the query? If he is pressing a command button on a form
to run it, then you simply use the MsgBox function to display a message in a
line of code the precedes the line that runs the query. You can then even
provide the option to cancel it. If they are just launching the query from the
db window then there is nothing you can do. Queries and tables do not have
events that you can utilize.
Click to expand...
 
Back
Top