Automatic ALERT popup needed

[taurz]

I have an Access database keeping track of the number of cars registered under the company. The cars have details like type, make, license plate number, road permit dates, etc.

I would like to get alerts 3 days before the expiry date of the road permit. which is the best way to go about it?

Thanx in advance

 

[Smart]

You can create a query tha selects all the info you need and add the fields below to the query
SELECT Table1.expdate
FROM Table14
WHERE (((Table1.expdate)=Date()+3));

Create a report based on the query

in the start up forms on load do a dlookup on the above query if it has info open the newly created report

Dim expirefound as string
Dim stDocname as string

expirefound = nz(dlookup("[Fieldname]","[queryname]"),"")
stDocname = "Reportname"
if expirefound <> "" then
DoCmd.OpenReport stDocName, acPreview
end if

 

[taurz]

hey thanx smart.....

i think that could do the trick.... i havent tried it yet.... but got the logic.... thanx a MILLION...!!