Require Mouse Click

[alex]

Require Mouse Click

Hello All,

Using Access ’03…

I have a form that’s used for receiving physical files using a wand
and barcode (each file is barcoded). I have code in the before update
event that checks the database to see if the file has already been
received, if so a msgbox appears seeking instructions.

The problem is that the barcodes have a character at the end that acts
like a return key…

So, for example, if data entry person is wanding a group a files and
one of them is in the database the msgbox will appear, but if the
person ignores (or doesn’t see) the msgbox and wands another file,
Access thinks the person hit enter and proceeds accordingly (as if the
enter key was pushed).

What I need is the message box to appear and to stay there until it’s
clicked with a mouse; that should ensure the data entry person sees
the message.

Can I code a msgbox to only respond to a mouse click? Our computers
do not have speakers so beeping doesn’t help.

Thoughts?
alex

 

[John W. Vinson]

Can I code a msgbox to only respond to a mouse click? Our computers
do not have speakers so beeping doesn’t help.

I'd pop up a Form in Dialog view instead; it will hog the focus until it's
dismissed, unlike a msgbox.

 

[alex]

I'd pop up a Form in Dialog view instead; it will hog the focus until it's
dismissed, unlike a msgbox.

Thanks John. I'll give that a try.
alex