Hello all,
Here is my code:
when I click on the button, I first get the "Microsoft Access Security Notice" that this folder might be unsafe (it is not). Then I click yes to continue, I get Error 490 - Cannot open the specified file, but the line to debug actually shows that it is reading the file path so what is the problem?
Thank you for your help
Here is my code:
Code:
Private Sub cmdFolderPath_Click()
Dim strMainPath As String
Dim strFolderPath As String
Dim strfolderName As String
strfolderName = Me.cboFolders.Column(1)
strMainPath = "..\Documents\RMF Photos\"
strFolderPath = strMainPath & strfolderName
If FolderExists(strFolderPath) = True Then
Application.FollowHyperlink strFolderPath
Else
MsgBox "No folder was found!" & vbNewLine & "Either check the spelling or create a folder." & vbNewLine & "Thank you!", vbCritical
End If
End Sub
Thank you for your help