Open Folder from Access

[Vitality]

I have and on this table based Form.
I have Folders With names 1, 2, 3....

I need command for open Folder with name, that equal to table ID.

Thanx in advance.

 

[ghudson]

This might help get you started... Browse [Find a directory or file]

 

[edith_tang]

Open Folder in MS Access


Assume you know the table ID,

Dim xPath, xFolder, xCmd As String

xPath = "\\server\data1\"

xFolder = xPath & xTableID
' (MkDir xFolder ' create folder )
xCmd = "explorer.exe " & xFolder & "\" ' open folder
Shell (xCmd) ' run external command

I have and on this table based Form.
I have Folders With names 1, 2, 3....

I need command for open Folder with name, that equal to table ID.

Thanx in advance.