Results 1 to 2 of 2
  1. #1
    airhud86 is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    4

    have hyperlink use own name/text


    I am trying to create a movie list database and i want to have the list be hyperlinks to the folder where the individual movie is. If there any way to have the hyperlink take/use its own name/text with out having to type it in or go through the folders everytime? Im going mad do this for hundreds of individual movies

    I know Ctrl K is a shortcut but you still have to browse through or cut and paste and so on. When I hit Ctrl K i just want it to open up the dialog box it the text its written with.


    Thanks for all your help ahead of time.

    Thanks again,

    Phil

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    been a while since I've had a project w/ hyperlink... the traditional method is to have your cursor in the field, right click, select 'Edit Hyperlink' and then find the file. When in that window you can manipulate the text that is visible vs the actual path text...

    to do hundreds is grunt work - - - to automate the entry of hyperlinks you need to begin with a look up the hyperlink method in Access or VB Help...and it will show you the syntax - - as there is more there than meets the eye....

    then one could get creative and write a VB loop that puts in the values automatically assuming there is some logical sequence of the naming convention that is used....but with movie titles I tend to doubt it...so am not sure of any short cut...

    caution: you want to be absolutely positively rock solid certain that the folders/locations of the DB and the movies will never change - - as any change will render all those links invalid.....

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

Similar Threads

  1. How to vertically align text inside a text box ?
    By alexcalgary in forum Forms
    Replies: 2
    Last Post: 10-06-2010, 08:44 AM
  2. Replies: 1
    Last Post: 06-08-2010, 12:08 PM
  3. How To View Hyperlink For Attachment File
    By treyprice in forum Access
    Replies: 0
    Last Post: 07-28-2009, 12:51 PM
  4. Hyperlink problem
    By peterl in forum Programming
    Replies: 0
    Last Post: 01-13-2009, 07:21 AM
  5. help with dynamic hyperlink to pdf
    By iresolver in forum Access
    Replies: 0
    Last Post: 12-24-2008, 01:21 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
  •  
Other Forums: Microsoft Office Forums - Senior Forums