Search results

Dear arnelgp, Thank you so much, your help was very useful for me, this Forum is amazing. Thanks,,,,

Do you mean a data like I provide before in Excel (last Tuesday)? or another data?

No problem take take your time

Dear arnelgp, in the Machine Form, can we add a new textbox next to the Label lblWarn “Maintenance needed!” to show which frequency is due as the activities (tasks) of the maintenance are deference from one frequency to another? I mean to show the suitable HourBeforePM in that new textbox.

Thank you very much, appreciated

Dear pbaldy, Thanks for reply Yes the same services of maintenance are repeated to the machine every term "frequency", but another maintenance service happened to the same machine in another term "frequency". for example the same machine maybe every 100 hrs cleaning and checking oil, and same...

Thanks you I appreciate all of this, It is good idea to put this textbox to get the Tag No, also I want to make a report on the machines that are due for maintenance to provide it to the Maintenance Team to start maintenance accordingly

Thank you so much, For the previous readings and also for the pm or am it doesn't matter because we took the current reading per week at anytime then record with the Date of this reading

Here you go

Dear Arnelgp, Thanks for your reply, I looked in your demo and tried to adapt my data with it but unfortunately it is mingled and doesn't accept the reading (give me error in VBA code), anyway I attached my data in excel format which I want to change it to Access database. thank you for your...

Thank you so much, I'll look then tell you

First thanks for quick answer, Yes it is continuous going up.

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...

I'm working in database Dept. at a Company working in Egypt and I interesting the Database field specially Access VBA