Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2007

    Unanswered: Using Hyperlink with a variable

    Hi there,

    Tried searching through the forum to see if I can get anything that could help me but wasn't able to...

    I have PO numbers that were taken from a webpage.

    After I input the PO number into the textbox and its respective information, I then automatically create a report with all the POs for the day.

    Is it possible for me to put in the report a hyperlink that will link it to the original web finding?

    The URL looks like this:

    If the PO is PO12345 the URL is

    So basically I need to take the 12345 and paste it onto the end of the "61-" in order for the hyperlink to work.

    Any suggestions or directions would be helpful.


    - wayne

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    Could it be as simple as:
    Function GetURL(PONumber as long) as String
        Const c_URL as string = ""
        GetURL = c_URL & Cstr(PONumber)
    End Function
    Or do I miss something?
    Have a nice day!

Posting Permissions

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