Search results

I've tried the following since my array is comma separated, and it didn't work. Where InStr("," & [Forms]![Contacts]![txtValues] & ",","," & "ID" & ",")>0

No, the article mentions how the textbox values will be interpreted as a string and not as numbers (because as I said, when I manually enter the numbers instead of referencing the textbox, it works fine), so I need to figure out how to have the query read the array values as numbers and not as a...

From the article I could deduct the following being my issue and expecting the user to simply enter 1,3,5 when prompted. Unfortunately, this seemingly straightforward approach will not work because Access will interpret the entire input as a String or Text. So, entering 1,3,5 does not mean 1 or...

I don't wanna go into that much honestly. I am using a function that will export a query to excel, and I just need to filter the result as per the active form. No further use for it. The query record source is different from the form's, that's why I don't want to straight export the form's result.

saved

Hello everyone, I need to run a query that is filtered by an array, but is not returning the desired result. I have a textbox "txtValues" on a form, that has the array values let's say 1,4,5,6 I need to fire up the query where the ID is within those value, so ran the SQl statement adding "where...

Are filters not recommended even for a temporary search? As for the naming convention, I am aware of that, but I started this DB by using the access contacts template, and it was supposed to be a very simple small thing, but the person who requested it, kept asking for new stuff to be added, and...

YES YES YES! Thank a million mate! Forms![Contact List].Filter = "ID In (" & SelectedID & ")" That was the line I needed.

My form "Contact List" opens up on db launch and has all contacts in continuous form. I will add a button that will open the search form (we worked on), and after doing the search, take the result from the listbox, and use it as filter for "contact list" to display the same records as per the...

This is working perfectly as long as items are selected. but... is it possible to have the filter based on the current list result regardless of selected values? That listbox is not intended to be clicked, just display the search result, and I want to use that same result as a filter for the...

I made the list to allow multiple selection, and when selecting more than one record, it is returning only one. (The last one to be specific)

Still not filtering. Am guessing because no selection is being made.

I posted the db in another reply above

I have attached the db with some sample data. Contact list will autoload, just manually open frmSearch, and give it a try to see.

Still not working, should I change the list box to multiple select?

Yeah no worries, but tested it, and it's not filtering for all the results if no selection made. If I select one of them in the listbox, filtering works fine.

Single, I am using it just for a preview of the search results. Users will eventually use the contact list form to access and edit the results.

Don't know if i could bother you with one last related thing. The search form is opened from another one "Contact List" which is continuous form displaying all people. I want to add a button to close the search form and filter my contact list form (using ID) from the search result. Could you...

With Me If Not IsNull(.cboPosition) Then where$ = where$ & IIf(Len(where$), " AND ", vbNullString) & "Position = " & .cboPosition End If If Not IsNull(.cboSecPos) Then where$ = where$ & IIf(Len(where$), " AND ", vbNullString) & "SecPosition like '" & .cboSecPos & "'"...

Unfortunately yes, as the job history and interview tables both have a one to many relationship for positions, so I am getting repeated names in the result.