Flagging up service intervals using hours recorded (1 Viewer)

Sam Summers

Registered User.
Local time
Today, 18:25
Joined
Sep 17, 2001
Messages
892
Hi Guys,

I am far too useless and stupid to solve this effectively!
Tried and tried but just cannot see it!

I have different components that have different service intervals based on hours entered by the user when the item is first entered.
I need to set a warning that flags up as in this example:

Main Engines - service at 250 hours, with a warning of the service approaching at 175 hours and then this of course continues at every 250 hour interval.

I have created a service history table which gathers the running hours logged by the user after every use.

My idea was to possibly use vba to add 250 to the warning total each time the next 250 is reached but these seems inefficient?

Many thanks for any help in advance
 

theDBguy

I’m here to help
Staff member
Local time
Today, 10:25
Joined
Oct 29, 2018
Messages
18,788
Can you show us your table structure?
 

Sam Summers

Registered User.
Local time
Today, 18:25
Joined
Sep 17, 2001
Messages
892
Can you show us your table structure?
You need to use the bypass key to open it.

So its from two forms - 'Maintenance' and 'Service' and the warnings will be at 75 hours prior to service interval of 250 and then warning when the 250 interval is reached.
Hours entered may be anything as small as 6 hours
 

Attachments

  • Tanera Fleet Management.zip
    576.3 KB · Views: 227

Users who are viewing this thread

Top Bottom