Where to start

[Paul B.]

Hello all,

I need to have access automatically tell the user that a vehicle is overdue
and I am not sure how to proceed.

I have a field 'ReturnDate' in the 'tblVehicles' and what I need to do is
when the user opens the database, run some sort of check to see if any
vehicles that should have been returned the day before, were not. The
'ReturnDate' field should be empty / null if the vehicle was returned. If it
will help, the 'Disposition' for these vehicles would be set to 'Out of
Service'.

Thanks in advance for your ideas.....


Cheers

 

[tina]

one way to do it is to write a query to pull the overdue vehicle records,
i'll call it qryOverdueVehicles. create an autoexec macro to check the query
and display a message if necessary, as

Macro Name: AutoExec
Condition: DCount(1, "qryOverdueVehicles","[ReturnDate] < #" & Date() &
"#") >= 1
Action: Msgbox
Message: There are overdue vehicles in the database.

instead of, or in addition to, the msgbox, you could automatically open (or
print) a report bound to qryOverdueVehicles.

hth

 

[Paul B.]

Thanks Tina, that gives me a start....

Cheers

one way to do it is to write a query to pull the overdue vehicle records,
i'll call it qryOverdueVehicles. create an autoexec macro to check the query
and display a message if necessary, as

Macro Name: AutoExec
Condition: DCount(1, "qryOverdueVehicles","[ReturnDate] < #" & Date() &
"#") >= 1
Action: Msgbox
Message: There are overdue vehicles in the database.

instead of, or in addition to, the msgbox, you could automatically open (or
print) a report bound to qryOverdueVehicles.

hth

Hello all,

I need to have access automatically tell the user that a vehicle is overdue
and I am not sure how to proceed.

I have a field 'ReturnDate' in the 'tblVehicles' and what I need to do is
when the user opens the database, run some sort of check to see if any
vehicles that should have been returned the day before, were not. The
'ReturnDate' field should be empty / null if the vehicle was returned. If it
will help, the 'Disposition' for these vehicles would be set to 'Out of
Service'.

Thanks in advance for your ideas.....


Cheers