Hi everyone,
I've just started back on MS Access after not using it for a couple years since learning the program in University. I'm definitely feeling some growing pains so came here to see if anyone could help.
I'm taking over the management of a remote property in the Bahamas that is going through some modernization and as such, we are trying to move all paper forms to a digital format. I've really been spear heading the whole thing since I have more experience that anyone else on property with Access (doesn't really say much). I've manged to set up most of our forms to record data into new sheets (the easy stuff). But, now I'm working on our maintenance forms and logs.
We rely on generators for power and as such, have to do a lot of maintenance on them. We have 2 generators and each is a different brand and size that requires different filters and oil and coolant quantities (one is a 4 cylinder John Deere, the other a 3 cylinder Yanmar). I'm trying to set up a form that will allow me to just put check boxes for the various items changed/replaced that will automatically deduct them from the inventory. How can i set it up so that it does this process and selects the correct filter/ deducts the right oil level out of the inventory? Is there also a way that I can set up the hours entered into the form to update the the "Generator Master" with the total hour information?
Thank you in advance for any assistance.
I've just started back on MS Access after not using it for a couple years since learning the program in University. I'm definitely feeling some growing pains so came here to see if anyone could help.
I'm taking over the management of a remote property in the Bahamas that is going through some modernization and as such, we are trying to move all paper forms to a digital format. I've really been spear heading the whole thing since I have more experience that anyone else on property with Access (doesn't really say much). I've manged to set up most of our forms to record data into new sheets (the easy stuff). But, now I'm working on our maintenance forms and logs.
We rely on generators for power and as such, have to do a lot of maintenance on them. We have 2 generators and each is a different brand and size that requires different filters and oil and coolant quantities (one is a 4 cylinder John Deere, the other a 3 cylinder Yanmar). I'm trying to set up a form that will allow me to just put check boxes for the various items changed/replaced that will automatically deduct them from the inventory. How can i set it up so that it does this process and selects the correct filter/ deducts the right oil level out of the inventory? Is there also a way that I can set up the hours entered into the form to update the the "Generator Master" with the total hour information?
Thank you in advance for any assistance.