Sam Summers
Registered User.
- Local time
- Today, 23:40
- Joined
- Sep 17, 2001
- Messages
- 939
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
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