Form only when needed
tbl_members contains a list of member information, including a Yes/No field if they are current in their training. (field name Current)
Once a member signs in, I have a macro that runs and brings up a form to indicate successful login. (on update of the id field)
However, I also want to check to see if tbl_members shows they are not current ([tbl_members].[current]=f
If they are, I want to put up a form that indicates such, that also plays a wave file or at a minimum beeps several times.
If they are current, the form is not needed.
Once a member signs in, I have a macro that runs and brings up a form to indicate successful login. (on update of the id field)
However, I also want to check to see if tbl_members shows they are not current ([tbl_members].[current]=f
If they are, I want to put up a form that indicates such, that also plays a wave file or at a minimum beeps several times.
If they are current, the form is not needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The sound is to let me know across the room that people are not current. If the training is not current, they must complete a training module prior to attending the meeting.
The sound is to let me know across the room that people are not current.Ok
In most cases the sound may become annoying after a while.
;-)
I typically try to employ a "visual" cue, like conditional formatting (but not anything flashing)
Also remember that if the user mutes the speakers, it won't be heard.
For example, a user may turn off the volume while watching a youtube video, (or muting an annoying self-playing ad) and not remember to turn it back on/up.
In any event, I am not sure you will get two (or more) distinct beeps unless you set some type of wait or delay in our code...
This popular code (to play a wav file) has been around for a while.
http://www.techonthenet.com/access/questions/play_wav2.php
Hope this helps as well...
Jeff