Display multiple rows based on search box dialog

[Hughie]

Dear experts,
I need to insert search box dialog that will do full text search in my table and based on results (if some of the cells contains typed character string) selected records (multiple) will be displayed at the same time.

Is there any way how to do this simply please? I know I can use filtering but this is not what I am looking for - need to do this as simple as possible so even noob can use the database.

Thnx a lot for any ideas!

[orange]

Hughie, Welcome to the forum.
Please tell us more about your table and database.

[Hughie]

Thnx for warm welcome!

Well I got quite a big table (so far the only one table in my database) with around 40 columns and 5000 rows... Some of the fields have names like Name1, Name2, Name3 and these are the fields I need to search in. If the searched string will be included in some of the columns (not exact match, just included in) I would like to display these records all together in one form and also edit these records in that form.

So basically I would like to have search box in split form - upper part will include this search box together with some form design, in lower part there will be displayed all records which includes searched string.

Hopefuly I explained this enough..

I dont have much experience with Access. Just got some basic training and doing another by self study

[orange]

With fields such as name1, name2, name3... -- this is a red flag that your data is NOT Normalized. In order to use Access and any dbms efficiently, you really need your tables designed properly.

Here is a tutorial you should work through to help with database design and normalization. You have to work through it to understand what's involved.
Good luck.

[Hughie]

Well of course the names are different in reality, this was just as an example.
In fact they are a little bit complicated that's why I used just the example...

[orange]

Perhaps you could show us your table design via screen capture/jpg.

[Hughie]

Attached is design view of my table. I marked VinNumber and PartNumber fields - based on this two fields I would like to search and display the appropriate records (which will contain searched entry).

[Missinglinq]

Most experienced developers will tell you that a Table with more than 20-25 Fields is almost assuredly non-normalized, and that is definitely the case, here! At a minimum, it appears that you need a second Table for the storing of all of the 'parts' data. You'd need to have the ID Field, from your current Table, as a Foreign Key, in the parts Table.

You'd then use a Main Form/Subform configuration to add, edit and display Records.

Linq ;0)>