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...

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...

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. * *...

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...