Search results

I have a form with a datasheet subform that I allow filters on. There are many columns on the table so it's hard to see them all. I'd like to be able to click a button to switch to Form view so I can display the currently selected row and naviagte through (having the form view only show...

So if I have 20 fields and I want to search all fields for a matching word I have to: WHERE QrySearchALL.Topic1 like "*test*" AND QrySearchALL.Topic2 like "*test*" AND QrySearchALL.Topic3 like "*test*" AND QrySearchALL.Topic4 like "*test*" AND etc...? Is there no way to just say search all...

I'm doing an sql query on a Access Query. I have no problem searching each record individually. SELECT * from QrySearchall where QrySearchAll.Topic1 like "*hello*" How can I make a full search where instead of Topic1 it searches for a match from every field?

I have a form used for searching where I create an sql query. It talks to my query (QrySearchall) ex: sCriteria = sCriteria & " AND qrySearchall.customer complaint like ""*" & txtSearchInput & "*""" The problem is (as seen above), some of my columns are 2 words (customer complaint). One word...

That will maximize the form but it does nothing for the subform. The datasheet view subform stays the same size it was when I set it up in deisgn view. It seems to just add a large footer section to fill in the rest of the screen of the form.

I have a form that contains a subform in datasheet view. I'd like to have the form maximize when open (fit any screen resolution). It's contents are just a few text boxes that would stay the same size, and the subform would expand to fill the rest. Any ideas?

I want to setup a form that basically shows the main datatable with some filter options. So basically the datatable will be in a subform and have text boxes above each colum that the user can enter a value into (instead of the default *) to filter the list. * *...

I have looked at that subject but it doesn't really give me what I need. My problem is grabbing the data to fill the second combo box from one of many tables depending on the first combo. All the cascading examples have everything in one table with a number of extra columns for telling what...

Here's what I'm trying to do: Main table with columns - line, area, description Line is a lookup table that looks up a separate table (which is just a list of lines). I'd like to make another table for each line which contains all its areas. So in the form, you choose a line from the lookup...

I want to have a table which basically stores a location, an area, and a description. I have a second table with a list of locations. Areas are specific for each location. Basically in my main table I want to choose a location from a lookup, which them populates the second lookup with...