Consulting

Results 1 to 2 of 2

Thread: Modify a hyperlink of an Access form in VBA

  1. #1
    VBAX Newbie
    Joined
    Jan 2021
    Posts
    1
    Location

    Modify a hyperlink of an Access form in VBA

    Hello,in an access form, there is a hypertext field called "Hyperlink"Text displayed = "CCP B 001"Link to file = "T: \ CERTIFICATION \ AQ \ DAQ \ DAQ_L \ CCP 001.xlsx"Tooltip = "CPP number 1: cooking temperature"I want to modify this field with VBA so that it becomes:Text displayed = "CCP001"Link to file = C: \ TEMP \ CCP 001.xlsx "Tooltip = "Temporary CPP number 1: cooking temperature"How to do this in VBA please?Thank you so much !Alain

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,261
    Location
    The syntax of your new data does not match the syntax of the original data.
    There are no exclamation marks around the file name.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •