Recent content by NavyBlueBolt

I plugged it in and it works. Thank you so much for your help. May the deities of the programming bless your codes. .

That's about what I'm looking for! I got the combo box for ID's set. I can apply this to a text box. The "is null" is to include null values in the search, right? Wouldn't this line just show everything regardless of what's in the box?

I do want the column. I want the criteria to read as: iif( [calibrated_by_txtbx] <> null, like "*" & [calibrated_by_txtbx] & "*", like "*" & [calibrated_by_txtbx] & "*" or is null) I tried putting something like that in, but to no avail.

I need all records to show, nulls included when the matching unbound textbox is null. Knowing that, how do you omit null values in a specific field when the correlating text field is not null?

Oh, where to begin. I'm learning vba and access through the University of Youtube so be prepared if much of what I do doesn't make sense or seems redundant. I'm doing my best just to make this function. I haven't even begin to touch SQL. When the user opens the search form, there is a subform...

I'm working with a query set to be a search engine of sorts. The search form has multiple unbound text fields (for partial searches) that send to the query in question and back onto a subform on the main form., I need to show blanks when all the fields are null and omit blanks when one of the...

Thank you for all of your help. I had to solve this issue within an unexpected time limit. Nevertheless, I thank you for your aid. This is what I went with in the end. The form itself was bound to a query that could alter data, but not add data. As theDBguy had asked, I was making an audit...

In a sense, yeah. We don't have logins as of yet. Only three people log in (myself, my boss who always opens backend anyway, and a coworker). My boss is big on keeping data, erroneous or otherwise. I do have entry dates and times set up so we can determine when data was entered. I'm just having...

Hi All! I'm new to the forum so please forgive me if I'm not doing this right. I have made a database to put in calibrations for gages w/out typing any SQL. There's a form to make a new gage, to add a new calibration for gages, and to search for gage histories. Within a form that connects to a...