Hi All,
I will be having 3 buttons ( 1st to create folder from Ms access, 2nd Rename folder, 3rd open the folder)
1st button =
Private Sub Command58_Click()
filename = Ref_Number.Value
MkDir "c:\SCSWA WORK PROJECTS\AccessDatabase\" & filename
MsgBox ("File has been created successfully")
End Sub
2nd button =
Private Sub Command77_Click()
Dim oldpathname As String
Dim newpathname As String
filename = Ref_Number.Value
scname = SC.Value
oldpathname = "c:\SCSWA WORK PROJECTS\AccessDatabase\" & filename
newpathname = "c:\SCSWA WORK PROJECTS\AccessDatabase\" & scname & "_" & filename
Name oldpathname As newpathname
End Sub
3rd button=
Application.FollowHyperlink "C:\SCSWA WORK PROJECTS\AccessDatabase\" & Me.Ref_Number.Value
How can I find either that the old folder or the renamed folder ?
ASKER