search table form

everwhat

Board Regular
Joined
Jul 23, 2002
Messages
189
Is there a way to seach the entire table instead of selected columns from a form?
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Please provide more details.
Can you explain the structure of your table, and maybe five an example of what you would be looking for?
It sounds like it is possible that you have some table design issues if you are trying to do something like this.
 
Upvote 0
I trying to create a form where user can search the entire table and not by a column.
For example:

search all columns/or table where there is "br214" or "br214*"
 
Upvote 0
What exactly is "br214"? Is it some kind of code for soemthing?

Usually, a code like this should only be located in one field (column) in a table. If not, you may have some serious flaws with your table design.

Database design should follow the rules of Data Normalization. When these rules are not followed, seemingly simple tasks (like this) become much more difficult than they should be.
 
Upvote 0
Table is created from data imported from outlook.
The Fields are "to", "from", "subject line", "date","message", 'received", "attachment" and "ID".
I would like to do a search in the table where, for example, search wherever the text of "BR234" or maybe "James" appears in the table. These items could be found in any columns/fields in the table. I would like to create a form where the search command and be executed.
 
Upvote 0
I see...

Do you know how to create a search form to search a single column?
If so, what method are you using?

If you are using the method that you are using the form to build SQL or criteria on the fly, you just to need to add to it to search every possible column, i.e. instead of having criteria like:
[Field1]="br214"
you would have something like:
[Field1]="br214" or [Field2]="br214" or [Field3]="br214" or ...
 
Upvote 0
I am not sure which method they are using (I don't have time to watch the 10 minute video right now), but the way I do is to use VBA to build the necessary SQL code "on-the-fly". Here is an example of one I have done in the past: http://www.mrexcel.com/forum/showpost.php?p=1619906

If you search the Access forum for threads with "Search Form" in the title, you will find many more threads on this topic.
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top