How to create a message to user?

[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

 

[Rick Brandt]

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.

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.

 

[Trip Levert]

Thanks!

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.