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


try

Shell "explorer.exe C:\ScannedFiles\" & [forms]![frmSomeForm]![SomeField], vbNormalFocus

<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>


Really, you have folders named with the value of SSNs?  

Hope you are prepared for the lawsuits that will accompany that when someone who shouldn't have access to the server gets access.

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


EXCELLENT!  Thanks capricorn1 for the speedy response!  It's just what I was looking for!

<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.