Searching the data

[elli]

Hi there, newbie here!
I have tried to solve my problem now for hours and haven't gotten any
closer.
I have made a form to show data in a table one by one. The table has more
than 2000 rows... So is there any way (simple please) to search and show
the specific row in my form??? Or even decide from two columns where to
search and find?

Sorry my messy explanation

-e-

 

[Rick Brandt]

Hi there, newbie here!
I have tried to solve my problem now for hours and haven't gotten any
closer.
I have made a form to show data in a table one by one. The table has
more than 2000 rows... So is there any way (simple please) to
search and show the specific row in my form??? Or even decide from
two columns where to search and find?

Sorry my messy explanation

The "simplest" way is to use the built-in find button on the toolbar. It will
have a binoculars icon.

 

[elli]

Hi Rick!
Y
That much I know, but I was kind of looking to make that kind of search into
my form...
Any help in there?
Sorry being non-specific.

-e-

 

[Rick Brandt]

Hi Rick!
Y
That much I know, but I was kind of looking to make that kind of
search into my form...
Any help in there?
Sorry being non-specific.

Well there is the Filter-by-form feature. Have you looked at that? If you drop
a new ComboBox on your form with the toolbox wizard enabled one of the choices
offered by the wizard will let you navigate (find) based on a selection made in
the ComboBox. The code that the wizard generates for that can easily be used as
a template to make your own variations on that theme.

Personally I prefer filtering to "finding" as it is more efficient.

 

[elli]

Hi Rick and thank U for your help.

I tied fiktering, but the column I'm planning to do the search has more than
3000 rows almost all data starting with AMNK...
So I was hoping there would be a solution like one text box where you could
write the specific item you want and the result (all of the info from that
item) would show up...

Impossible??

Thanks again

-elli-

 

[elli]

Hi there!

I found a solution and put it here in case somebody someday....
http://www.databasedev.co.uk/

Sorry about my misstyping... I was typing it with a kitten in my lap.

-e-