Search results

I found the problem in case anyone ever runs into this. The autonumber seed on my tables got reset. I use autonumber as my primary key on several tables and Access thought the seed number was less than what it should have been. Here is the fix: http://allenbrowne.com/ser-40.html. I ran this...

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

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

Nope, the default value does not work. When I use it, it does not create the PK so that the other linked forms function. The PK is only created, at this point, when the user physically types the value into the field. When I place the default value, the form appears to place the value into the...

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

That works beautifully. Thank you!

Thank you Galaxiom for your reply. Since I'm a beginner in VBA, I'm not sure how to implement your suggestions. I've tried another approach based on some code I've found elsewhere on the site. I've set the visible property to false on the appropriate controls when the form opens. When...

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

Hi, Here's how I've changed the syntax. After trying 10 or so iterations, I finally got the query to function. [Forms]![IncidentDetails]![CtrlLogDetail].[Form]![ctrlType].[Form].[cboType] IncidentDetails = main form ctrlLogDetail = 2nd subform control ctrlType= 3rd level subform...

Thank you for replying. I've tried expression builder--it does not work. I can get to the control on my second subform for the 3rd subform but not any levels below that. Access just won't show any controls located in subforms beyond the second level. So I need to have the syntax written out...

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

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

Thank you so much for your replies. I'll try both of these solutions and see which one works the best within my database. Thanks for the sample DB. it is extremely helpful. I was actually looking for the Code, but I didn't think about approaching the problem in either of these ways; which is...

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