Help With Find

[JamesJ]

On my ac 2007 form I placed a command button. The On Click I have the
following:
DoCmd.RunCommand acCmdFind
Problem is the 'Look in:' combo box is disabled unless I actually click on a
particular field.
And even then it remains "grayed". If I click on the look in combo box the
selection changes
to whatever field I have clicked on.
The Look in combo box isn't "grayed" out when I use Find button I placed in
the quick access tool bar.
I would prefer to have the button on the form and not in the quick access
tool bar.
Also the default in the Look in combo box has the name of the form. Any way
to have only the
field names show in the combo box and without having to click on the field?

Thanks,
James

 

[Jeff Boyce]

You've described "how" you are trying to accomplish something (buttons and
comboboxes and "Find" and ...).

If you'll described instead what it is you are trying to Find, and how your
data is structured, and what business need will be satsified by Finding
something, folks here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JamesJ]

I'm not trying to search particular data. The data is in a table with 400+
records.
Just trying to find data in the table using a single record form with aFind
button on it.
Not sure how else I might explain this.

James

 

[Jeff Boyce]

James

Is what you are trying to find likely located in Field7 (whatever your name
for that field is), or could it be in Field 3 and/or Field 4 and/or Field5
and/or ...?

Most folks don't try to Find something and then not use it. What will you
(?your users) be able to do as a result of having Found what you/they are
looking for?

Are we talking about elephants or electronic circuits or attendees at
trainings -- having some idea of the domain you're working in might help
folks offer more appropriate suggestions.

Hopefully you don't find this too intrusive ... it's just that being told
"just tell me what button to push" usually causes me to ask "why are you
even pushing buttons?"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[JamesJ]

In most cases but not all.
2 fields that I wish to search in:
DvdMovieTitle and DvdSynopsis.

Not trying to perform any operation other than seeing if the search returns
anything.

It's a dvd library.

When I post I try to make it short so if more info is needed that's fine.

James

 

[Jeff Boyce]

James

Perhaps one of the other newsgroup readers has approached Finding in this
way -- I don't have any experience to offer.

Jeff B>

 

[Gina Whipp]

James,

Sounds like you are trying to do a KeyWord Search so you can see if a movie
or words in the synopsis. Is that what you are trying to do? If yes, I
Googled... but watch out for word wrap.

http://www.google.com/search?hl=en&...esult&cd=1&q=keyword+search+ms+access&spell=1

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[JamesJ]

Thanks for the effort,

James

James

Perhaps one of the other newsgroup readers has approached Finding in this
way -- I don't have any experience to offer.

Jeff B>

 

[JamesJ]

I wasn't sure what to refer to it as but I believe you got it.
I'll look into Key Word searches and if any questions I'll get back
to the ng.

Thanks for pointing me in the right direction,
James

 

[Gina Whipp]

James,

A few examples...

http://www.databasedev.co.uk/text_search.html

http://www.databasedev.co.uk/multiple-openargs.html

http://allenbrowne.com/ser-62.html

By the way, don't use your real eMail here... the Spammers will harvest!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I wasn't sure what to refer to it as but I believe you got it.
I'll look into Key Word searches and if any questions I'll get back
to the ng.

Thanks for pointing me in the right direction,
James

<SNIPPED>

 

[Krzysztof Naworyta]

The "Find" window depands of a control that has focus.
You do not want searching on Command Button, I'm sure

Screen.PreviousControl.SetFocus
DoCmd.RunCommand acCmdFind

The easiest way you can do it.
But there are many other ways to do it much more profesional, without
calling the "Find" window.


--
KN


Juzer JamesJ <jjy@darwin_roadrunner.com> napisa³
| On my ac 2007 form I placed a command button. The On Click I have the
| following:
| DoCmd.RunCommand acCmdFind
| Problem is the 'Look in:' combo box is disabled unless I actually click
| on a particular field.
| And even then it remains "grayed". If I click on the look in combo box
| the selection changes
| to whatever field I have clicked on.
| The Look in combo box isn't "grayed" out when I use Find button I
| placed in the quick access tool bar.
| I would prefer to have the button on the form and not in the quick
| access tool bar.
| Also the default in the Look in combo box has the name of the form. Any
| way to have only the
| field names show in the combo box and without having to click on the
| field?