Recent content by la1814

Galaxiom, Thanks for the info. I will surely take it...I will likely have many more changes as I am new to this and self taught. Do you have a god book on "Designing Databases" that you would recommend? Thanks, la1814

Ugly...but it works...thanks again. You have been a wealth of knowledge and outstanding help! Expr1: IIf(([AllRead] Or ((DateDiff("d",Date(),Nz([PhysicalExpires],#12 Dec 2099#)))<14) Or ((DateDiff("d",Date(),Nz([EFExpires],#12/12/2099#)))<14) Or...

Thanks again vbaINet...ended up doing it as an expression...my eyes hurt!

Good morning. Enjoy the day...after some good sleep!

Thanks vbaInet. This is going to blow my mind trying to convert the vba to an expression. Have a good evening.

vbaInet, Great point on the Date, thanks. Just so I am not confused. Do I convert the code into an expression for an Update Query criteria? Then when the form loads it will go through all the names. Thanks, la1814

When I Load a Datasheet Form I am attempting to check every record and 'flag' it if it meets my criteria. Each record consists of a persons name and a long set of qualifications with expiration dates. The code to check the expirations and set the blFlag works as advertised. The Loop I am...

I started with two separate forms because they have much more info that what I am presenting here and will be viewed by different parties that only need certain data. So I built the forms separately then realized I needed to do what you have been helping me with. I will still keep two forms...

vbaINet, I think I have solved it! I decided to use my original AirOpsPlanForm and add the 'Flight Status' Field from the AircraftForm since they have a relationship. I then wrote an event to update the Flight Status when Airborne/Fifteen/OnDeck is checked. I will then Requery the...

vbaNet, Sorry not to get back to you earlier. I have been busy the last couple days. Here is what I came up with. Two different ways of doing it in the attachment. Note the AirOpsForm on the Example attachment from previous...I added the code below and when Fifteen is checked it will ask for...

Am I hearing there is no way to do what I want here? I tried joining the Forms but that did not work the direction I wanted it to (putting a check on AirOpsForm feeds Aircraft Form). It only worked in the opposite direction. I can try to make the Aircraft Form a subform of AirOps and then put...

Both the Aircraft and AirOpsForm are Datasheet forms. Ultimately they will both be put into a Navigation Form. The Database (a few posts earlier) is the code I am referring to. It updates Airborne/Fifteen/OnDeck when I open the Forms, but it updates for all 'Side's. The code does not work on...

vbaInet, Still have an issue with this one. The 'FlightStatus' is nicely updated, however it updates the same for every 'Side' in the Aircraft Form, not just the particular side that was just noted Airborne/Fifteen/OnDeck. I want it to update only for the 'Side' that is Airborne/Fifteen/OnDeck...

Re: [SOLVED] Driving input from one form to update another Figured my issue out with downloading. Thanks for the fix. With a few tweaks it will do exactly what I need. Brilliant...again, thanks for the help and enjoy the rest of your weekend.

vbaInet, Apologize for the delayed response. I have been out of town for the past few days. I can't thank you enough for the help you have provided. I have incorporated the time stamps you mentioned. The actual database goes into much more detail. I sent you the most basic to keep...