Automatically ran queries!!!

[Airbiskit]

Hi,

Is it possible for Access 2000 to prompt when a date is nearing expiry? Say for instance I would like to know 3 months in advance when expiry dates are up so I can take relevent action, easy with just a query but can Access run this query automatically when a date gets within 3 months of the expiry date?

If yes then where do I start?

All help, as always, is very appreciated.

Thanks

Steve

 

[Telumendil]

I would create a form launched at DB start up, which checks if there is any date nearing expiry, closes if not and displays it if there's any...

 

[Airbiskit]

Thanks for the reply. I think I will use something similar to this. From a button I open a form, can the button also run a query?

The code for the button is as follows...

Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Training"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.DESCRIPTION
Resume Exit_Command2_Click

End Sub


I don't know the first thing about code so if I can how can I make the button do 2 seperate things?

Many Thanks

Steve