message box or beep sound notification on basis of dates

[Guest_imported]

I have to deposit my sale tax quarterly .I want that one week before the required date access warn me that on this date you have to deposit your bill and this message i will see everyday till that date whenever i open access daily in the morning.

 

[jimmythegeek]

Create a public function and attach it to the On Open of your first form, or in an AutoExec macro.

Something like this should work (changing the appropriate fields of course):

==========
Public Sub PayTaxes()
Dim paydate as Date, start as Date, finish as Date
start = Date()-8
finish = Date()+1
paydate = DLookUp("YourDateField", "YourTableName", "WhereCriteria&quot

If paydate > start AND paydate < finish Then
MsgBox &quot;You need to pay your taxes&quot;
End If
End Sub
==========

Now OnOpen of your first form put this:

Call PayTaxes Jim Lunde
compugeeks@hotmail.com
Custom Application Development