Search results

  1. J

    adding a new record has strange behavior and filters records instead of adding

    Hi, I have a form that opens from a button on a main menu. When pressing the button the form opens to a new record; the primary key shows (new). That works. The issue I just started having this morning was when I enter data into any of the fields in the form, it doesn't create a new...
  2. J

    Help getting a subform to open to a new record when a button is clicked

    Hi, I have a subform [ctrlLogDetail] on a parent form [incidentdetails] that is opened by the user when they click on a button on a navigation form. These forms are used for a variety of purposes. The problem I'm having is that the user needs to be able to select an incident number and go...
  3. J

    using VBA to populate date/time fields on a subform

    Hi, I have a form that contains a subform. On the main form, there are 3 fields: [IncidentNumber], [OpenDate] and [OpenTime]. The subform, [CtrlLogDetail] , contains the log entry details for each incident number. Every incident number can have many log entries. Two of the fields on the...
  4. J

    hide controls when a form is opened conditionally

    Hi, I've searched for an answer here and can only find information setting the visible property when selections are made on an open form--I want to set the visible property when the form is opened depending on which avenue the user chooses from the navigation form. I have a navigation...
  5. J

    correct syntax to refer to a control on a nested subform in Access 2013

    Hi, I have searched to find the correct syntax to refer to a combo box control on a nested subform. All the examples I've found Access 2013 will not recognize or find the appropriate control. I have a parent form called IncidentDetails. On that form I have a control called ctrlLogDetail...
  6. J

    Junction Table issue

    Hi, I've been searching the forums (and the internet) and can't find an answer to an issue I seem to have. I'm creating an incident management database. Each log entry created has a type (and occasionally a subtype). Some of the types have 3+ subtypes. I have the following tables...
  7. J

    cascading combo boxes and if else statements

    Hi, I've been all over the internet trying to find an answer to this question and am hoping someone here has one. I have 2 combo boxes, cboCatID and cboSubCatID The values are based off of queries, qryCategory and qrySubCategory which are pulling values from underlying tables tblCategory...
Back
Top Bottom