Searching for records (1 Viewer)

[DaleFromEngland]

Hi, i know this might sound stupid, but here goes.....
I have designed a database for work, (that was simple enough!)Now i know that you can search for records using the FIND button, but everytime the find box pops up, i have to change search for records to ANY PART OF FIELD. Now, the people that are going to use the database, have this thing about QUICK AND SIMPLE., so they dont want to keep changing the SEARCH OPTION to ANY PART OF FIELD. Is there anything that could be done about this????? PLZ, and THANX's

 

[KDg]

Hi Dale,

hope you're ready for this truly half-a**ed solution. This works on 97, if the DoCmd line fails then just use the wizard to make a new "find" command button and substitute the code in.

    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, , acMenuVer70
    SendKeys "{TAB}"
    SendKeys "{TAB}"
    SendKeys "{UP}"
    SendKeys "{TAB}"
    SendKeys "{TAB}"
    SendKeys "{TAB}"

I also has to use 3 forward tabs as 2 backwards kept giving me an error, good luck

HTH

Drew

 

[DJN]

There are a couple of articles on the Microsoft Knowledge Base that might be of help. Follow the links.

http://support.microsoft.com/support/kb/articles/Q136/0/62.asp?
http://support.microsoft.com/support/kb/articles/Q95/9/31.asp?

 

[KeaganQuilty]

Click on the Tools menu and choose Options.

Click the Edit/Find Tab and where it says "Default Find/Replace Behaviour" change the option to "General Search".

Click Apply or OK and exit your database. The next time you open it and do a search, it will automatically search any part of field.

Please keep in mind that this works in Access 97. I don't know if the option is there for 2000.

Keagan Quilty
Kilbride, Newfoundland