Search results

  1. S

    Multiple Date Fields based on Criteria on the same Report Row

    Bear with me as I try to explain my situation. I have a huge table - don’t ask – I inherited it, and yes, we are making headway). Along with the standard name, and employee ID #, this table contains multiple fields to track license expirations, based on the type of equipment. To keep it simple...
  2. S

    Combo Box Value

    I have a combo box on a report menu and want to use the value's for other activities. The combo is cmbReports, with (2) fields: ID Name 1 Red 2 Blue 3 Yellow 4 Green How would I reference a value of blue, in a "if" statement situation? If Me.!cmbReports = "Blue"...
  3. S

    Calculating a Date Fields based on 2 Different Dates

    I have three date fields. [DateA], [DateB], [DateC]. [DateC] is a calculated field in my query, that adds 2 years to [DateA], and it works fine via this criteria: DateC_2: DateAdd("yyyy",2,[DateA]) However, [DateA] is only used one time, and then all follow up activities are defined in...
  4. S

    Hiding/Un-hiding Form Controls with a Module

    I have code tied to a command button on a subform, however, it is both lengthy and needs to be used in multiple locations (OnOpen, On Current, etc.). I would like to use a module instead, however, the code "hangs up" on each of the control names. I have tried to use the ME! and Me. identifier...
  5. S

    Compile Error Now Present in Access 2016 db

    Previously had Access 2010, now on 2016. I have a database that has several fields that start with "5S3D....", not only in the tables but on 2 forms, several queries, and reports. All of sudden everything came to a screeching halt, all pointing towards these fields. Coding is used to unhide...
  6. S

    Count Specific Values In Combo Boxes

    Have a table, with related query. All are combo boxes with set choices of G (Good) or NG (No Good), and then each subset it used to select a number of NG items. Field 1 - G Field 2 - NG Field 3 - NG Field 4 - G Field 5 - G Field 6 - G NG Score = 2 (manually selected from 1-6, for the total...
  7. S

    Autofill Combo Box based on Field Value

    In short, I am trying to do something I have never tried before, so I do not have any previous examples to use. I have two forms, FORM A & FORM B I have [FIELD1] that I select the value in FORM A. That same value is then 'auto-filled' on FORM B. Also on FORM B is [ComboBox1] that has between...
  8. S

    Hiding/UnHiding Tab Controls based on Combo Box Selection

    I have frmIncident that has a 2-column combo box (cmbIncidentType). Column (0) is IncidentType, Column (1) is YES/NO. This combo box feeds from a Query and currently has about 15 "types" of which 4 have a "Yes" tied to them, then rest "No". There are situated on a TabControl (tabIncident)...
  9. S

    Unhide Form Tab Controls based on Drop Down Selection

    I have tab control form with (5) tabs. For this discussion - Tabs 1 through 5. For a blank (new) form sheet tabs 4 & 5 need to be hidden. Based on what is selected via the drop down box (on tab 1) then tabs 4 & 5 may remain hidden or needed to be un-hidden. Example: [DropDown1] Selection...
  10. S

    Validation Rule for minimum/maximum range

    I have a password field in a table, where I want to establish a validation rule for the minimum (6) and maximum (10) number of characters that it must be. Also, the field should be only alphanumeric. Is this possible?
Top Bottom