<div>
The code to simply open a folder using explorer is:<br />
<br />
Application.FollowHyperlin<wbr />k &quot;U:\CDG\CDG\Members Folders\&quot;<br />
<br />
The rest can be achieved by cycling through or looking at a recordset to gather and concatenate the first/last name and IDs to create the entire folder location (assuming this is available in a table or query).<br />
<br />
Hope that helps,<br />
Sean
</div>


The code to simply open a folder using explorer is:

Application.FollowHyperlink "U:\CDG\CDG\Members Folders\"

The rest can be achieved by cycling through or looking at a recordset to gather and concatenate the first/last name and IDs to create the entire folder location (assuming this is available in a table or query).

Hope that helps,
Sean

<div>
Here is the generic Shell:<br />
<br />
Shell &quot;explorer.exe &nbsp;U:\CDG\CDG\Members Folders\&quot;, vbNormalFocus<br />
<br />
mx
</div>


Here is the generic Shell:

Shell "explorer.exe  U:\CDG\CDG\Members Folders\", vbNormalFocus

mx

<div>
<div class="content wysiwyg-content">
Hi Experts <br />
<br />
I am running access 2003 and have a form which I want to add a command button to that opens up a folder (using explorer). &nbsp;<br />
<br />
The file path for the folder will change from record to record. &nbsp;But as part of the set up process for each record, a folder is created in the following filepath U:\CDG\CDG\Members Folders\&nbsp;&amp; then has a sub folder derived using the following naming protocol [First Name]-[Last Name]-[ID] (i.e. Dave-Smith-123)<br />
<br />
So the link piece to the code would be U:\CDG\CDG\Members Folders\[First Name] &amp;&nbsp;&quot;-&quot; &amp;[Last Name]&amp; &quot;-&quot; &amp;&nbsp;[ID] <br />
<br />
Has anyone got a piece of code to do this or can anyone help?<br />

</div>
</div>


Hi Experts 

I am running access 2003 and have a form which I want to add a command button to that opens up a folder (using explorer).  

The file path for the folder will change from record to record.  But as part of the set up process for each record, a folder is created in the following filepath U:\CDG\CDG\Members Folders\ & then has a sub folder derived using the following naming protocol [First Name]-[Last Name]-[ID] (i.e. Dave-Smith-123)

So the link piece to the code would be U:\CDG\CDG\Members Folders\[First Name] & "-" &[Last Name]& "-" & [ID] 

Has anyone got a piece of code to do this or can anyone help?


Open Folder using explorer

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.