<div>
try<br />
<br />
Shell &quot;explorer.exe C:\ScannedFiles\&quot; &amp;&nbsp;[forms]![frmSomeForm]![Som<wbr />eField], vbNormalFocus
</div>


<div>
Really, you have folders named with the value of SSNs? &nbsp;<br />
<br />
Hope you are prepared for the lawsuits that will accompany that when someone who shouldn't have access to the server gets access.
</div>


<div>
EXCELLENT! &nbsp;Thanks capricorn1 for the speedy response! &nbsp;It's just what I was looking for!
</div>


<div>
<div class="content wysiwyg-content">
I am familier with the code for opening an explorer directory from MS access, but I need to take it one step further. &nbsp;I would like to be able to use the data from a field as criteria in the string for opening the directory.<br />
<br />
For example:<br />
I have a form with a feild for SSNs. &nbsp;I also have a directory with folders named specific SSNs. &nbsp;I would like to have the code below use the current recordset and open the folder that matches the data in the field. &nbsp;<br />
<br />
Is it similar to using a field for a parameter query [forms]![frmSomeForm]![Som<wbr />eField]...<wbr />...?<br />
<br />
Private Sub openDirectory_Click()<br />
<br />
&nbsp; &nbsp; Shell &quot;explorer.exe C:\ScannedFiles\........&quot;,<wbr /> vbNormalFocus<br />
<br />
End Sub<br />
<br />
Any help is greatly appreciated!
</div>
</div>


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.

For example:
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

End Sub

Any help is greatly appreciated!

MS Access: Open specific directory from field criteria

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.