• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 946
  • Last Modified:

Set Value Macro Problem in Form - Setting Hyperlink field

I have a form that combines a [path], [item name] and [picture number].  From this field I want to set the value of a hyperlink field, which will open the picture.  I get an error code 2766, Object doesn't contain the Automation Object.."  I think it might be better to use VBA than the macro.

I would like to do two things with VBA.
1) Set the Value of the LinkText field to the Hyperlilnk field.
2) Change the name of a picture to the LinkText (minus the [path] value.
0
jmar6729
Asked:
jmar6729
1 Solution
 
MINDSUPERBCommented:
I recommend to create a field e.g. Link and set its data type as Hyperlink.

Then on the Current Event of the form, put this code:

Private Sub Form_Current()
Me.Link = "#" & Me.Path & "/" & Me.FileName & "#"
End Sub


Link is the name of your field in your table
Path is the field name of your path
FileName is the field name of file name.

Sincerely,
Ed
0
 
jmar6729Author Commented:
Thanks, Ed.  That works great for the hyperlink.  Any idea how to use VBA to change the file name in the photo directory?  I have found and changed file names years ago but forget how to do that. (rst comes to mind :)

I will enter a [photonumber] into the form record.  Once I do that, the number is concatentated into the [photoname]. Then I need to rename the photo in the photo directory, so the hyperlink will work.

Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now