Ideas/Coding needed for outlined database situation!!

[PhilG]

I don't know what I am doing. (I read the forum topic guidelines!)

Basically, I need to associate a specific 'part' with an aircraft that is in the 'Aircraft_Table'. This 'part' can have three variables associated with it upon being added to the aircraft. They are: 'Time in Hours already on the part when added to aircraft' , 'Cycles already on the part when added to aircraft' , and/or 'Days already on the part when added to aircraft'. Now, each part has an associated 'Limiter, or Maximum Safety Rating'. Let's say that a 'propeller', has a 'maximum safety rating' of '500 hours'. Also, this 'propeller' had 200 hours of time on it when it was added to the aircraft. It is now left with 300 hours. So, when the 'Cycles' and 'Hours' are entered in the 'Flight_Log_Update' form (for a specific airplane record), then Access subtracts, say, '3.9' hours from how much 'life' is left on the part. So, 3.9 hours are added to the a plane using the 'Flight_Log_Update' form. Then, 3.9 hours are taken away from the 300 hours left on the propeller and updates that part record. Multiple parts per plane are needed to be tracked. If anyone can help with this I would greatly appreciate it. Please ask any questions you need to further assist me.


The goal is to be able to have a report display a specific airplane's associated parts and sort/filter that data in different useful ways. E.g. have Access display which parts have the least amount of hours left on them based on the calculations and ordered in ascending. Hopefully this diagram will help with the formula needed:




Any takers? Thanks in advance!

 

[spikepl]

Don't mix too many things together. Each part has a running consumption of time and cycles and days. Log that in a table. Parts can migrate from plane to plane, so somewhere you need to associate a given part to a given plane (or not - if floating around in the workshop or sent off for repairs)

Also, each part has a given lifetime when acquired, some of which already is spent, if the part is not new. Those are all permanent properties of the part, no matter where it is, unless overhauled.

You could then calculate the life remaining at any point in time in a query, based on time consumed and the life available.

 

[spikepl]

On reflection, have you checked commercial systems? Because you are not the only one with this problem, and I'm sure there must be some tools around.

 

[PhilG]

Thanks, spikepl!

I appreciate how you outlined the structure.

I am working for my Grandpa, he is an airline consultant. He hired a programmer in 1994 to write a program in Access to do just this. I have all the Business, Element, Container, etc Routines he originally wrote with all the forms, queries, and reports. I just don't have enough coding experience to get what he had pieced together. I've removed the missing/broken library references and have gotten it open in Access 2007. But, that is where I am stuck. The back-end is largely intact, I just need someone who can help me with the front-end aspect of it (i.e. OLE objects and forms which just didn't convert well into 2007). I have analyzed the code and am pretty confident it is DAO and not ADO (which apparently was the standard in 1994). I have updated all the 'RecordSet' references to 'DAO.RecordSet' and 'Open_Dynaset_DB' to 'dbOpenDynaSet'.

If I attach what I have, do you think someone could take a look at it for me? We are under the pressure of the FAA; which is due in about a week for another visit. Any help would be appreciated!

Well, I cannot add a URL yet..

You will need to reassign the 'System Info Data Record'. A macro was included to do this called 'OpenRPMATSInfoForm'. If you know how to manually point to the included .mdb file then more power to you.. no security threat is intended with the macro! You will find the .mdb file under the .DATA\PROGS\RPMATS\ subdirectory. Thanks again in advance if anyone takes a look at this for me. It may be a simple fix! I am at odds and ends with it!

 

[PhilG]

Okay , finally figured out I had to go into the 'Advanced' post menu
Here is the attached db!!! Please re-point from the switchboard to the .mdb data file included in zip sub-directory!