Search results

**SOLVED**Calculated field in query not showing up in report **SOLVED** I have a query which has 14 calculated fields. I've found that, at least by default and the ways I've tried so far, that the only calculated fields in that query which will display are the ones which are in the last of...

Okay, so I have included the project in a download link because it's far easier to show someone what I am talking about rather than tell them. In short, I have an aircraft flight log that incrementally logs each aircraft flight hour and flight cycle. This is summed using the aggregate Sum() in a...

I am designing a way in Access to track parts that have been added to a specific aircraft. Parts have a consumption in Hours, Days, and Cycles. Parts have a lifespan in Hours, Days and Cycles. One table I have is: [NNumber] (an associated foreign key in the Aircraft_Table) , [PartID]...

Well, turns out I needed to add 'Parent.' to the calculation controls.. now the aggreg function can work within a form/sub-form setup :)

Okay, I am using this syntax as the control source for an unbound textbox which is supposed to display the calculated unbound textbox in the footer of a sub-form: =Sum([ACTimeInitial]+[txtHourSum]) and =Sum([ACCyclesInitial]+[txtCycleSum]) txtCycleSum and txtHourSum are the names of the...

***********UPDATE*********** Okay, I am using this syntax as the control source for the unbound textbox which is supposed to display the calculated unbound textbox in the footer of the sub-form. =Sum([ACTimeInitial]+[txtHourSum]) and =Sum([ACCyclesInitial]+[txtCycleSum]) txtCycleSum and...

Linq, you are > than great! This is working great so far! Now I can use this same setup to start tracking associated parts which have a consumption and life limit. The part has a life-span (either in hours, days, or cycles). The part can already have consumption on it when it is associated...

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

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

Well, that functionality would be great. Because, ideally the customers want to have an ActionLog which would show 'which user entered what and when to where'. So, yes, you are right! We are under pressure from the FAA right now and we need something that is going to track and update flight...

And what sort of control would be used for the user to enter the value to be added? A TextBox? Thanks btw for the quick reply! Also, I have very limited VBA coding experience :)

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

Hello, I made a form which is called 'Flight_Log_Update'. The objective here is to be able to input new flight data to update the associated aircraft records. Is it possible to be able to have some sort of input field in the form that allows you to type in, for example, '3.9' which would then...