CuriousGeorge
Registered User.
- Local time
- Today, 15:45
- Joined
- Feb 18, 2011
- Messages
- 131
Hello,
Just want the user to be able to add file paths to records. Using following code:
Error msg: " method or data member not found "
Im new to databases and the VBA language.
As ive understood "Me." is referring to the current form. The files in the directory have different names with endings like *.D00 *.D01 etc. If the filenames are different, how do I define "FileName"? I assume i have to change that in the code? =)
Also, does the type for each record has to be of type "hyperlink" or can it be "text"?
Thanks
Just want the user to be able to add file paths to records. Using following code:
Code:
Option Compare Database
Option Explicit
Private Sub LinkFile_Click()
Dim File As String
File = Me.FileName
Application.FollowHyperlink "C:\Users\SSS787\ReadLog_new" & File
End Sub
Error msg: " method or data member not found "
Im new to databases and the VBA language.
As ive understood "Me." is referring to the current form. The files in the directory have different names with endings like *.D00 *.D01 etc. If the filenames are different, how do I define "FileName"? I assume i have to change that in the code? =)
Also, does the type for each record has to be of type "hyperlink" or can it be "text"?
Thanks