Find options

[alukard]

I gotta question, im new to writing visual basic for access and was wondering if theres any list of commands to change the options for the "Find/Replace" dialog box.

I was also wondering how you do a multi word search too. In other windows search engines if you want to find things with the words "nut" and "5/16" you would just type "nut, 5/16" in the search box and you would get anything in your computer with either one or both in the name. Access though will only find the exact text "nut, 5/16" even if i set the match catagory to "any part of field", instead of either or both entries.

I got a table with a list of part numbers and descriptions and id like to be able from the form click the find button and in the find box type a general description like "bolt, 1/4" or "tubing, 3/8" and have it pop up the part number and desription, especially since most of the descriptions are not so simply described, most actually would be "bolt, hex head 1/4-20 40%nylon/60%glass fill" or "tubing, 3/16"o.d. x 0.025" wall (green)".
thank you in advance kurt

 

[jrbarnett]

Hi Kurt

Options for Find/Replace dialog are on Tools -> Options -> Edit/Find tab. They govern how the find works and aren't too flexible though, only exact match, start of field and anywhere.
For multi word searches within fields, you could use wildcards, for example nut*5/16 will give anything starting with "nut" and ending in "5/16".
Using nut* will give anything starting with nut.
Using *nut will give anything ending with nut.

As for multi word searches across fields, it isn't possible using the standard features, but a vba routine to search both based on a comma separated value could be written if you were so inclined.

John

 

[alukard]

Thanks for the info jrbarnett, i would like to be able to write a vba routine, but i dont know how to use it that well yet. the most i can do is add small commands, and how to make some other already made commands work in mine. Im slowly learning vba, but it will be some time till i get to the point of writting my own. thanks kurt