Hello,
I want to make an Access database using VBA to control the maintenance of some machines by recording the running hours Reading from its meter-monitor (No connection, I will input Reading by hand) to calculate the running hours and tell the user when maintenance is due based on frequency (3000 hours, 5000 hours, 10000 hours, …. Noticing that one machine maybe has many frequencies) to start the maintenance.
Could you please give me an imagine to the Tables, Queries, Forms and VBA codes?
I want to make an Access database using VBA to control the maintenance of some machines by recording the running hours Reading from its meter-monitor (No connection, I will input Reading by hand) to calculate the running hours and tell the user when maintenance is due based on frequency (3000 hours, 5000 hours, 10000 hours, …. Noticing that one machine maybe has many frequencies) to start the maintenance.
Could you please give me an imagine to the Tables, Queries, Forms and VBA codes?