Help me finialize my form (1 Viewer)

[alguzman]

I'm just about finished my membership database and need some cosmetic tricks to gain some points with my boss. On the form I have information on their dues, like due start date and dues end date. I would like to know how to have their membership number or the fixed dues amount on the form blink in red when there is seven days left to their dues end date. Any help would be great. Al

 

[capri]

start by looking at the Employee Sales by Country in the Northwinds database.It shows and "Exceeds goal" in red that is dependant on criteria. You could refine that method to suit your database. As for the blinking can't help you there. I know you can do it in Word, but haven't come across it in Access yet. Sure there is likely to be some code that you could use, but I don't know enough at this point to even suggest what it might be.

 

[mrabrams]

This is how I make a Label "blink".
It's probably not very elegant, but the label blinks!!

In the Timer Interval property of the form, I use 500.
Then , I placed the following code in the Form's Timer Event:

Private Sub Form_Timer()

If Label0.Visible = True Then
Label0.Visible = False
Else
Label0.Visible = True
End If
End Sub

Like I said, it ain't very pretty, but it works!!!

HTH

Michael Abrams