Early Warning on Date Field

[PicassoB]

I have a form with a estimated job completion Date
and I need to create a warning system (2 days prior to completion date)
can anyone help with me with any idears or code to do this

 

[KeithG]

What do you mean by warning system? What do you want to happen? Maybe a message to pop up when the user open the db?

 

[GaryPanic]

what you should have is a form that users have to go through to get tot he system on this form should be a list box - this list box can be run off a query that is


if the job is not finished
and is <>2 days (you wil have to mess around getting the right data- if you can get your qry to work then the list box will do what you want..
if however you want something a bt more flashy then that will involve a bit more outline on what you had in mind - you could have emails ping off - but these can get annoying

 

[PicassoB]

I was thinking of a button on the switchboard that runs a report showing all jobs with 2 days left