Specify Find options

Hi All!

I set up a form so that my boss could easily see names and addresses
off our office web site.

I added a command button to the form to bring up the 'find' window.

All went well, except that today my boss was complaining that he had
run a search for people in a certain town. He was in a bad mood and
complained that the database was not up to date because he could only
find one or two people when there were at least three people who are
members in the area. I was flummoxed because I knew I had those
people on the database. I opened the same form and command button on
my computer and entered a general search for the town in any field.
The missing people turned up straight away.

I pointed out to my boss that when the find box was open he needed to
set the options to search for any instance in any part of the field in
any field in the record. Then he would find the missing people. He
pointed out it wasn't his job to know anything about searching. It was
mine to sort it out.

So, I spent a fruitless hou after that trying to find some way of
setting up the Find command button so that it opens automatically with
the options set to search any part of any field for whatever is input.
I tried macros, I tried the command button wizard and I tried setting
up a routine. All to no effect.

If anyone can please tell me how you set up the find options in a
Command button it would be very much appreciated!

Cheers
David

You don't mention what version you are using, but open Access on his
machine, and open any database.

Go to Tools, Options, Edit/Find tab.

Click on the '?' in the upper right and then click on the 'General Search'
option. You'll see an explanation of these settings - it will apply to all
sessions of Access.

You likely want to choose General Search, however be aware that his searches
will be much slower.

--
Joan Wild
Microsoft Access MVP

Dave The Brain wrote:
Hi All!

I set up a form so that my boss could easily see names and addresses
off our office web site.

I added a command button to the form to bring up the 'find' window.

All went well, except that today my boss was complaining that he had
run a search for people in a certain town. He was in a bad mood and
complained that the database was not up to date because he could only
find one or two people when there were at least three people who are
members in the area. I was flummoxed because I knew I had those
people on the database. I opened the same form and command button on
my computer and entered a general search for the town in any field.
The missing people turned up straight away.

I pointed out to my boss that when the find box was open he needed to
set the options to search for any instance in any part of the field in
any field in the record. Then he would find the missing people. He
pointed out it wasn't his job to know anything about searching. It was
mine to sort it out.

So, I spent a fruitless hou after that trying to find some way of
setting up the Find command button so that it opens automatically with
the options set to search any part of any field for whatever is input.
I tried macros, I tried the command button wizard and I tried setting
up a routine. All to no effect.

If anyone can please tell me how you set up the find options in a
Command button it would be very much appreciated!

Cheers
David

Thanks for that.

We have a central database and I stick a copy of it onto a CD and pass
it over to my boss. IHe then copies the database to his laptop and
goes home.

Will this work if the options are set then the file is transferred to
a disk? Will the same options be set on his system or would I
physically have to alter the Access programme on his laptop to make
the settings work?

I will probably set these options on the office computers as default
and change them on mine as needed.

By the way, I'm using Access 2003 in 2000 mode.

Many thanks for your help.
David

On Tue, 27 Jul 2004 18:55:06 -0400, "Joan Wild"
wrote:

You don't mention what version you are using, but open Access on his
machine, and open any database.

Go to Tools, Options, Edit/Find tab.

Click on the '?' in the upper right and then click on the 'General Search'
option. You'll see an explanation of these settings - it will apply to all
sessions of Access.

You likely want to choose General Search, however be aware that his searches
will be much slower.

You would need to do this in Access on his laptop - the setting applies to
Access, not to a specific mdb.

Dave The Brain wrote:
Thanks for that.

We have a central database and I stick a copy of it onto a CD and pass
it over to my boss. IHe then copies the database to his laptop and
goes home.

Will this work if the options are set then the file is transferred to
a disk? Will the same options be set on his system or would I
physically have to alter the Access programme on his laptop to make
the settings work?

I will probably set these options on the office computers as default
and change them on mine as needed.

By the way, I'm using Access 2003 in 2000 mode.

Many thanks for your help.
David

On Tue, 27 Jul 2004 18:55:06 -0400, "Joan Wild"
wrote:

You don't mention what version you are using, but open Access on his
machine, and open any database.

Go to Tools, Options, Edit/Find tab.

Click on the '?' in the upper right and then click on the 'General
Search' option. You'll see an explanation of these settings - it
will apply to all sessions of Access.

You likely want to choose General Search, however be aware that his
searches will be much slower.

--
Joan Wild
Microsoft Access MVP