jumbledore
Active Member
- Joined
- Jan 17, 2014
- Messages
- 262
I had created an access database to store path names of files on my local drive using the below vba code:
Dim rst As dao.Recordset
Set rst = MyDB.OpenRecordset("MyTable", dbOpenDynaset, dbAppendOnly)
With rst
. AddNew
! [File_path] ="Link" & "#c:\myfiles#"
.Update
rst.Close
I have only mentioned the code relevant to my question and have left out the other details. The code works fine and I have updated more than 2000 records using it but now I want to change the path of the hyperlink from "#c:\myfiles#" to "#c:\thosefiles#"
How do I do so?
Thanks
Dim rst As dao.Recordset
Set rst = MyDB.OpenRecordset("MyTable", dbOpenDynaset, dbAppendOnly)
With rst
. AddNew
! [File_path] ="Link" & "#c:\myfiles#"
.Update
rst.Close
I have only mentioned the code relevant to my question and have left out the other details. The code works fine and I have updated more than 2000 records using it but now I want to change the path of the hyperlink from "#c:\myfiles#" to "#c:\thosefiles#"
How do I do so?
Thanks