Where to start

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks Tina, that gives me a start....

Cheers


tina said:
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. said:
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
Click to expand...
Click to expand...
 
Back
Top