Search results

First of all, thank you for your continued help on this. I feel like it's some stupid little simple thing I'm missing, as is generally the case. I would love to use @MajP's FAYT class, but something is awry when I plugged it into a backup database. I've followed the instructions in the module...

And of course I've create the entire database around pop-up forms. It seems to be the easiest way for the user to navigate between the various forms needed to find information. Of course, one can just hit ctrl+F and search, and I've done that myself with some of my entries, but the find dialog...

Thank you for your perseverence, @LarryE! However, I have already tried this code. It simply changes the focus to the first record on the subform. Like this: Clearly the name "Mollard" is not being highlighted there. I also tried your suggestion of changing the combobox name to "FamilyName"...

The join allows the combobox cboNameSelect to display identifying information of the person in question. The FamilyName, GivenName, Position, and CityofResidence fields are not in the PersonItem table, only in the Person table. If there's a way to include those fields in the combobox without...

@LarryE Both the search box and the control containing the field I need to search are on the same subform. The search box is on the subform header, the control that needs to be searched is on the continuous subform. I've tried both a combo box and text box for the search box. The search combo...

I made a backup and changed all instances of "cboNameSelect" and the control name to FamilyName. After refresh still only goes to the first record in the subform.

@ Thanks for the suggestion, but this doesn't seem to work. The form loads with no records visible in the subform. Searching for a name in the txtRecordSearch text box only sets the focus to an empty record on the subform. After plugging in the WHERE clause and saving the record, the SQL comes...

Honestly I don't know. That was a code template suggested by another user who had a similar issue they were trying to work out.

@LarryE it seems your suggestion is on the right track, but one snafu: my control is not called "FamilyName", it's called "cboNameSelect". FamilyName is one of the fields that cboNameSelect pulls from. If I put the code in as you wrote it, I get "Run-time error '2109': There is no field named...

Thanks @pbaldy. I'm working on @MajP 's module in a backup file and just tried your suggestion in the original. Here's the code as I have it now: Private Sub cboRecordSearch_AfterUpdate() Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[FamilyName] = '" &...

Hello! I'm working on an archives database and I'm trying to make the user interface a little easier. I have a form that looks like this: Some of the items in the database have over a hundred associated persons, and I want to make it a little easier for the archivists to find associated persons...

@pbaldy you did it! The weird thing is, in one of my earlier attempts, I tried to set focus to a control on the new form, but the view kept going back to the display form. This time I just added Forms!frmViewItem.SetFocus to the Click() event and it worked like a charm. I can't believe it was...

Hello! I apologize that I may not be using the right terminology here, but this is my situation. For some controls, DoCmd.OpenForm will open the requested form and immediately switch the view to the tab containing the form. On other controls, the view will remain on the display form. I can't...

Thanks, I've been twiddling around with conditional formatting already, my issue is that I don't know what terms I should use in an expression to identify items that have already been selected in the subform. I imagine it will be something along the lines of...

Hello! I have a subform to edit items from table [Items] in which multiple items from table [Persons] can be selected in a combobox called cboNameSelect. The subform also includes a command button that opens a form to enter a new item into the [Persons] table if that person is not yet in the...

Like this? SELECT PersonItem.PersonIDFK, PersonItem.ItemIDFK, Persons.FamilyName, Persons.GivenName, Persons.CityOfResidence, [FamilyName] & ", " & [GivenName] & " | " & [CityOfResidence] & " | " & [Institution] AS Name, PersonItem.PageNumbers FROM (Institutions LEFT JOIN Persons ON...

Development: There are a few persons on the persons table that do not have associated institutions. I just searched through the combobox on the subform and it will not display any persons who do not have an associated institution. I'm not sure what could be causing this. Here's the SQL for the...

Thanks, I put the referential integrity back into place and tried changing the default value to null for both foreign keys, but the error message remains. What I really don't get is why it's looking for ", as the matching field. Where does a quotation mark and a comma come into play? Edit: I...

Thanks, I eliminated RI in both the items/institutions and the persons/institutions relationship but the error message still comes up! If it's any help, this issue started after I added the institution to the Name: expression in the subform combobox. Beforehand it worked fine. Oddly, if I...

Hello all! In the database I'm working on, I have an form to edit entries on table "items" that includes a subform to add associated persons from table "persons". I have a combo box that allows the user to select the associated person, and it displays a few data points on each entry from the...