Popup Reminder

  • Thread starter Thread starter dc
  • Start date Start date
D

dc

Hi, I was wondering if someone out there knows the best way to build a popup
reminder?

What I would like to do is when you select an individual member and a bill
is due to be sent an automatic popup appears. I have my query designed and
appears to work fine and I have my forms built. My trouble is trying to get
these two forms to work together. I don't seem to be able to have the popup
only appear when it matches a certain record.

Any suggestions?
 
There are lots of ways to do what you want but maybe the simplest would be to
include the owed amount on the form (could be hidden if you like).
Something like this in the base query the form is based on

Item cost ###
Amout paid ###
Total owing ###

If the total owing is more than 0.01 then show the popup

You could do this on load of the record in the form - that way it will show
when someone looks at the record on the form

DoCmd.OpenForm "SomeFormName", acNormal, "", "[RecordID]=###", , acNormal

Or you could just have a small subform set to "visible = No" unless the
amount owing is >0.01

Private Sub Form_Load()
If Me.AmountOwing > 0.01 Then
Me.SomeFormName.Visible = True
Else
Me.SomeFormName.Visible = False
End If
End Sub
 
dc said:
Hi, I was wondering if someone out there knows the best way to build a
popup
reminder?

What I would like to do is when you select an individual member and a bill
is due to be sent an automatic popup appears. I have my query designed
and
appears to work fine and I have my forms built. My trouble is trying to
get
these two forms to work together. I don't seem to be able to have the
popup
only appear when it matches a certain record.

Any suggestions?
Click to expand...

Here's a sample app to remind one when a birthday approaches:

http://www.datastrat.com/Download/Birthday2K.zip
 
Back
Top