Recent content by dmace1

It wouldn't let me post my zip file or my accdb file because a security image was missing. I'm posting this here. Maybe this will help. This is my code for searching on the whole search form. Option Compare Database Option Explicit Private Sub Command72_Click() Dim strWhere As String Dim...

I have that in there.

Sorry, I tried to upload it but I get an error message that says security token is missing. I don't know how to fix this.

It ran but it did not give me the correct results. It gave me all records, not just the correct records for the Committee Contact selected.

Committee Contact is a name. (First Name Last Name)

It got rid of the error but it still did not give me the correct results. It gave me everything, not just the results for the selected Committee Contact.

Same Message.

Thanks, but unfortunately, that still did not work.

I have a fairly large search form. The search button is working except for one field which is a combo box. I'm just not sure how to code it. It was suggested by someone on this forum that I also code it the same way that I did for my text boxes. That did not work. I also tried the following...

Hi, First, I'm fairly new to Access and even newer to VBA but trying. I created a search form and the coding. My search form has 11 searchable fields. All of them are working except one - CommitteeContact which is based on a combo box. When I try to search on CommitteeContact, I get the error...

Sure, this is what I put in the where condition. "CaseTitle Like ' "*" & [Forms]![InputCaseData]![SearchForBox] & "*" " When I clicked the run macro button, it did nothing.

Thanks but that did not work either.

Hi, I have a form in which I've put a search button to bring up a specific record. I want the user to only have to enter one word from a string of words (not necessarily the first word in the string). This is what I have in the macro: Object Type: Form Object Name: InputCaseData Record...

Thank you so much for your assistance! This worked!:)

First, let me say I'm pretty inexperience in Access and very inexperienced in VBA but I'm trying to build an Access database and have built a search form. I have some VBA code to go along with that. Both the text boxes and the combo boxes work when I am searching in one field only. However, when...