Need VB script to search multiple folders based on access 2007 textbox
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!