Create an alert based on mileage

[Mcal6096]

Hello,

I used a template for Access to create a fleet management maintenance and fuel trackers. Is there a way to get an alert when a specific mileage threshold is hit? Like if I am entering fuel for a certain vehicle and it tallys until 5000 miles driven, then I get an alert?

[CJ_London]

not much to go on - suggest investigate conditional formatting

[ranman256]

i have a tConfig table that holds this criteria. you can have [MilageLimit] field
set it to 5000.

then when you sum a persons milage ,add in this table, DO NOT JOIN the table.
bring in tConfig.MilageLimit in the query
then you can put a message in another field in the query: MsgFld: IIF([sumMilage]=> tConfig.MilageLimit,"LIMIT REACHED")

or on a form, when the data loads,display a message:
if [sumMilage]>= tConfig.MilageLimit the msgbox "LIMIT REACHED"

[Bulzie]

Yes but would need to know exactly what field, what condition for the alert to trigger and what kind of alert you want(color the field, pop up message box)? In your above example, you say tally to 5000 miles driven? Do you mean you are entering this data and when it totals > 5000 you want an alert?

[Mcal6096]

Yes. For instance, when we fuel our fleet of vehicles, we log the mileage along with Gallons Price etc for each car.. So each time we log the mileage for a specific vehicle, when it catches that it has been 5,000 miles, I would like an alert, if that makes sense.

[Bulzie]

What kind of alert, you have to be specific on what you want. You can add conditions on AfterUpdate event of your mileage field that basically says If Me.Mileage > 5000 then "Do your Alert". Or Ranman has another method. Few ways to do depending on when, where and how you want it to work.

[Mcal6096]

I am sorta new to Access and all of its functions. I like the AfterUpdate idea you stated. What other information could I provide to get this question answered?

[pbaldy]

If you're doing fleet maintenance, it gets a lot more complicated. If 5000 is the oil change interval, you want to be alerted at 5000 since the last oil change, not just at 5000. I've got a couple of vehicle maintenance apps running. I had tables for vehicles of course, also service types (oil change, transmission service, etc), service performed (type, odometer, date, etc), and intervals (vehicle ID, type ID, mileage). With those I can produce a report of vehicles that are coming due for service, based on the current odometer, the last service performed and the interval.