Results 1 to 2 of 2

Hyperlink visualization

  1. #1
    emeteco is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Sep 2019

    Hyperlink visualization


    I have two HyperlinkPart in two query columns like:

    ParteDeHipervínculo("";1) & Car(35) & ParteDeHipervínculo("/name?run=" & [TABL1]![COL1];1)

    Note: being & Car(35) & the # symbol (" & [TABL1]![COL1];1

    ParteDeHipervínculo("http://1XX.XX.XX.XX/service/FICHERO.php?NAME=" & [TBLA1]![COL2];1)

    When I run the query the result is correct, but it`s show the entire concatenation. How can I show only the [TABL1]![COL1] or [TBLA1]![COL2] with the Hyperlink propierties.


  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    you started a new thread for the same problem you marked as solved?
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    (humor about talking to yourself apparently was too much for some)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Database Visualization Question - Report or Form? Both?
    By Ramtrap in forum Database Design
    Replies: 1
    Last Post: 10-23-2017, 07:25 AM
  2. VBA hyperlink
    By Homegrownandy in forum Programming
    Replies: 3
    Last Post: 11-02-2016, 09:44 AM
  3. Replies: 4
    Last Post: 01-05-2013, 11:07 AM
  4. help with hyperlink
    By bmd in forum Access
    Replies: 1
    Last Post: 08-24-2011, 12:41 PM
  5. Replies: 4
    Last Post: 01-31-2011, 03:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Tech Forums: Microsoft Office Forums