Search results

I have two forms each having one common field (aircraft #). In Form A there is a list of all the aircraft in the squadron (100, 101, 102...). In Form B is the daily schedule for each of them to fly (sometimes multiple times in a day). Relationship built through a lookup of aircraft from Form...

Jdraw...apologies on the second thread. Oversight. Everyone, appreciate the guidance and help here. Steep learning curve. Have a good evening.

Thanks so much for the help with this. Being as new as I am with this I had not looked at it in this way. Shows a much neater code as well. Great lessons. I am sure I will have many more trials and tribulations. Nanscombe...you have gone above and beyond!!! I can't thank you enough...

The intent is to flag '^' if any one of the dates or yes/no fields are true (=yes). When I run this with a date outside of 14 (no flag) and the other date empty with both yes/no values false (no flag) it results in a flag. I believe the empty value is what results in the flag the way I have...

If the date is within 14 days of its expiration it will place a '^' next to the individuals name. Also, if one of the other check boxes (AllRead and Discrepancies) is checked it will do the same. I have several dates in my database, some of which will not be required for some people so they...

Gentlemen and Ladies, Here is what I have come up with but it still does not seem to work? Note, for troubleshooting purposes Dim Days does have a date value and Days1 field is empty. Discrepancies and AllRead are set to False. Result is Me.NameLookup + " ^", however it should be Me.NameLookup...

Gentlemen, Here is what I have come up with but it still does not seem to work? Note, for troubleshooting purposes Dim Days does have a date value and Days1 field is empty. Discrepancies and AllRead are set to False. Result is Me.NameLookup + " ^", however it should be Me.NameLookup...

Thanks Gents. Appreciate the help. Have a good evening.

Gentlemen and Ladies, I am having issues with this one... If there is no value in the Dim it will result in: Me.NameLookup + " ^" For instance, if I have not added a date for Me.PhysicalExpires yet when it gets to the If (Days<=14) Then it ends up giving me the 'Then' statement...however, I...

I was afraid that was the case but could not find info to confirm. Thanks and Happy New Year!

Having issues getting the BorderColor to turn red in a datasheet form 'Pilot' field when it is empty AfterUpdate. I confirmed the SpecialEffect property is set to flat: Private Sub Pilot_AfterUpdate() If IsNull(Pilot) = True Then Pilot.BorderColor = RGB(255, 0, 0) End If...

Mihail...many many thanks. Not only for the fix, but more importantly your teachings! It of course worked and I was able to apply this in a few other parts of my database.

Gentlemen, Thanks for he quick reply. Huge help and very much appreciated. Glad to hear I was on the right track and it was something that should have been obvious but I kept looking for the deeper issue. Suppose you can help me on the next issue. I am trying to update a field on a form...

Greetings. I am very new...which will be evident...to Access/VBA. I am building a database which has expiration dates. I want to place a flag ("^") next to a persons name when they are within 14 days of an expiration or if a yes/no box is checked. I want the flag if ONE of the 8 due dates or the...