MS Access: Open specific directory from field criteria
Posted on 2011-10-03
I am familier with the code for opening an explorer directory from MS access, but I need to take it one step further. I would like to be able to use the data from a field as criteria in the string for opening the directory.
I have a form with a feild for SSNs. I also have a directory with folders named specific SSNs. I would like to have the code below use the current recordset and open the folder that matches the data in the field.
Is it similar to using a field for a parameter query [forms]![frmSomeForm]![SomeField]......?
Private Sub openDirectory_Click()
Shell "explorer.exe C:\ScannedFiles\........", vbNormalFocus
Any help is greatly appreciated!