Search results

That worked. Thank you and thanks @MajP for elucidating the acDialog action. Have a great day!

I wonder if you can help me do the same thing on a different form in the same database. I'm using the same code as the Institution form on a form in which the user can add new persons. As far as I can tell, the code syntax all looks fine, but when I try to add a new person I get an error...

Got it! Thank you, @moke123. The issue was the combobox name. Renamed the combobox to InstitutionID and now it works like a charm. Thank you for your patience with me. Up until now I've managed to achieve everything my databases need using macros, but clearly it's time I get proficient in VBA...

Added Set frmNewInst = nothing to the code. Still the same error message. Complete code below: Option Compare Database Option Explicit Dim WithEvents frmNewInst As Access.Form 'a form variable with the withevents keyword '------------------------------------------------------------ '...

Thanks for catching that. Added it but still get the same error message. Here's the code now: Option Compare Database Option Explicit Dim WithEvents frmNewInst As Access.Form 'a form variable with the withevents keyword '------------------------------------------------------------ '...

Thank you moke123, this seems like an elegant solution, and it works perfectly on your example. However, I tried it on my database and I get this error message: Here's the code for my EnterNewPerson form. I converted the macros to VBA. Option Compare Database...

Hello Access Wizards! I have a fairly simple thing I would like to do with a couple of forms. I have an entry form linked to one table that has a button that opens a pop-up form if the user needs to add a field to a related table. When the pop-up form is closed, the earlier entry form reloads...

MajP, thanks, I think I'm going to work around your suggestions here. I think I've got a fairly user-friendly structure starting to shape up. Thanks!

Is there a standard way of executing this? If it's a command that has to be repeated on every row in the continuous subform, that seems pretty complicated! Wouldn't a combo box automatically do this?

You're correct in that I've a normalized table structure and erroneously used the multi-value field term here. I can understand where the confusion comes from, that's my fault. It is a normalized structure, I need to associate many persons with items during item entry. This leads to two...

Hello all! I've started work on what should be a rather simple database for a school archive, but right away I've come across a quandary I can't solve. In order to make this simple, I've downsized the database to only the relevant tables and fields to show the relationships in question...

That works! It's tedious with all the control boxes I've got on this database, but it's a solution. Thanks again.

DBGuy, you're my hero. I just created this macro and it works like a charm: If only I realized it was this simple. Additonal question, is there a way I can set the focus back to the SchoolNameSearchBar on the same macro after I've reset the value? As it is the focus moves to the next text box...

Hi everybody! I have a form with three unbound text boxes that are to be used as three different search functions. I have control buttons next to each text box that open a report based on parameters collected from the text boxes. I'd like the user to be able to just hit the enter key after...

I was using an embedded macro but converted it to VBA to try this out. Did exactly as you suggested, clicked the button and all it does is bring up the VBA again exactly as I left it, no values, no report. I am confident that the problem is as another user stated: "cannot type into a textbox on...

This has to be the problem. You are correct that the text in the search box disappears as soon as I click the button. If I want this to work I'll have to convert every report to a form. It's what I should have done to begin with as they aren't intended to be printed but I'm new to Access so I...

On the query design screen I used the autoprompts, so I'm sure there's no typo in the control name.

Unless you would like to walk me through how to do that, I'm afraid that's entirely outside of my skillset. I'm doing this design as part of a graduate student co-op placement and this is the first time I've designed a database from scratch. Learning as I go here.

When I type in the box, the data holds, but if I press enter it disappears. I realize that I may have made a mistake in using reports instead of read-only forms, but I've managed to add a number of other controls on my reports that work just fine. And yes, two identical reports because I...

I'm using Like because the field has a lot of names with recurring prefixes. It's for an archives, and many box archival numbers all start with the same string of letters and numbers. So instead of having to search for box ABCXYZ0143, I would like them to be able to just search 143. There must...