Search results

  1. L

    While Not Loop

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

    Driving input from one form to update another

    [SOLVED] Driving input from one form to update another Good morning. I am having an issue with this code that I cannot figure out. I am attempting to update one form based on inputs to another. 1. AircraftDatasheetForm (Form not open, being updated) 2. Flight (Form open and being changed...
  3. L

    Conditional Formatting?

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

    Still having Null issues

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

    Null Values

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

    BorderColor

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

    New to Access/VBA: Expiration Dates

    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...
Back
Top Bottom