Searching Documents

[mbarton]

I written search routine that will allow the user to search the contents of files for specific keywords. (using FileSearch) The form currently has a text field that holds the directory for the search. I'd like to add a 'Browse' button that will allow the user to graphically browse the directory structures, and then return the chosen path into my text field. (just like most file open/save operations) Does that code exist in Access? If not does someone have a snipet of code that will do this??

thanks,
-Mike Barton

 

[Travis]

What you want to use is the CommonDialog box. You can get more info on this from the Help File.

 

[mbarton]

There was no information in the help file about a commondialog box. I should also mention I am using Access 97.

 

[miramax]

CommonDialogBox does not exists in Acess. You can use it only in Word or Excel.

 

[DES]

Hmmm. Where to begin. First off mbarton I have sent you a sample of creating a browse window without the common dialogue.

Second although Miramax is technically correct in that the common dialogue does not come with MS Access you may still have access to it through more controls and it should not be dismissed out of hand.

However even if you have the common dialogue the end user may not or they may have a different version which will cause referencing errors later.

Personally I think you will be better off with the code.

DES