Flashing Alert messages

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I have a Form in Access 2000 that requires a Flashing
Alert message to be displayed when a specific Yes/No field
is marked and set to Yes. This Flashing Message must
display when the form is opened for one specific record
that might have the field set at yes or if viewing a
number of records with that form and when moving on to the
next record and that record may have the specified field
marked as yes. How can this be accomplished? Thanks
 
Hi Ron
If I understand you right, when you move to a new record,
you want to display a message if one of the fields
contains a certain value?

If so, you need to find the event that is activated on
change of record (put MsgBox ("test") in them one by one
till you find right one.
When you find right event, use an if statement to check
for value and if true, put MsgBox "this record contains
special data".
If you want to make it flash, change a label from
invisible to visible and make it red and big and bold or
something! Use the timer function to make it flash.

Sorry I don't have time to come up with any more but it
might help - bit of a challenge on weekends!
Stephen
 
I have a Form in Access 2000 that requires a Flashing
Alert message to be displayed when a specific Yes/No field
is marked and set to Yes. This Flashing Message must
display when the form is opened for one specific record
that might have the field set at yes or if viewing a
number of records with that form and when moving on to the
next record and that record may have the specified field
marked as yes. How can this be accomplished? Thanks
Click to expand...

Well, you can probably make a form flash by using a Timer event and
changing the Form.BackgroundColour property.

You could call it in dialog mode from the AfterUpdate or Change event of
the Yes/No control (checkbox?), and from the AfterUpdate event of the form
itself, to detect moving off the record -- I can't think of an event that
will fire on leaving an unchanged record (as opposed to On Current, which
can see the new record's values, not the old ones).

Hope that helps a bit...


Tim F
 
Back
Top