warning of an approaching date

[David B]

I have a table containing a number of dates when action lists need to be
printed.
When the start form opens I want the system to check of any datediff is between
0 and -5 and if yes open the form which allows the user to select and print the
list.
Also if the list was printed on day -4 I want to cancel the routine on days - 3
to 0
Any thoughts on how to do this ?
TIA
David B
Hexham UK

[Bob Quintal]

"David B" <da***@marleycotenospam.fsnet.co.uk> wrote in
news:bo**********@newsg4.svr.pol.co.uk:

I have a table containing a number of dates when action lists
need to be printed.
When the start form opens I want the system to check of any
datediff is between 0 and -5 and if yes open the form which
allows the user to select and print the list.
Also if the list was printed on day -4 I want to cancel the
routine on days - 3 to 0
Any thoughts on how to do this ?
Second answer first.
Add a yes/no field to the actiondates table to mark its been
printed.

That done, build a query that returns the records that fall between
now and five days in the future, and AlreadyPrinted = no. Open the
query as a recordset from vba in your start form's Open Event and
check if the recordcount is > 0. If it is, open the form. Better
yet, run the report directly. set AlreadyPrinted to yes. Close the
recordset.
Bob Q

TIA
David B
Hexham UK