pop up message

  • Thread starter Thread starter jiji
  • Start date Start date
J

jiji

I am looking for a way to have a pop up message saying that my clients are
due to pay their bill with 3 days. pls help, I am not too much familiar with
macro or any other programmation but i can catch fast if you explain to me
in details. thank you

jiji
 
Hi,
create a query on the table which holds the date you want to calculate on.
Then in the criteria of the field use: DateAdd("d",-3,[YourDateField]) !
Now run the query and it should show you all people who are due in 3 days.
You can now use a dcount function on any event (maybe your first forms on
open event) to check if the query has values and give a msgbox, something
like:

If Dcount("*","yourquery") > 0 Then
MsgBox("You have poeple who will be due in 3 days!")
End If

HTH
Good luck
 
Back
Top