Need VB script to search multiple folders based on access 2007 textbox

[David92595]

Hello,

 

The company I work for is in the process of going paperless, because of this I need to create a script that will find a folder that has been previously created, but could be located in multiple places. So I need to be able to search multiple folders/have the ability to set a list of folders to search. Once found I need it to open the folder automatically.

I need to have a one click button that will search the multiple folders based on a text box in an access 2007 Form.

 

For example I need the script to search folders: \\SERVER\Max\BAC, \\SERVER\Max\LPS, \\SERVER\Max\FCI

Based on [Forms]![Main Details]![LN] (the text box, which will be a number).

 

Any help on this would be appreciated!

Thank you,

David92595