Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Folder Links (2007)

    Its been a couple of years since i've really done anything with Access and now i'm using 2007 @ work so i'm feeling like a newbie again. Anyway, I'm doing project management and i've used microsoft's project management database template. i'd like to modify it a little bit - although i must admit, it is quite good as it stands. One of the things i'd like to add is a folder link on the project details form -> project details tab that when clicked will open up a folder on the client computer where information pertaining to that project is stored. instead of using their project attachment list thing which is cool, but only so useful when you have a lot of files, i'd like to just click on the project's corresponding folder & have that pop up so i could get the info i needed quickly.

    now i'm playing around with it and i'm thinking i use the hyperlink address field/control source field to get this to work. but how do i get it to open so that someone can choose the folder in the first place and/or use a drap drop type of function to drag the folder onto it? also, it seems as though there is no option to use clip art for the image, i must find the image first and then insert it when i create it, is this the case or am i missing something? i'm looking at how they did the attachments list on the same form but i'm not making any connections between the two.

    Thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Folder Links (2007)

    I don't have Access 2007 yet, but in earlier versions, you can use Insert | Hyperlink to create or edit a hyperlink. Also, dragging a folder from Windows Explorer and dropping it onto a hyperlink field in an Access table, query or form creates a hyperlink to that folder

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Folder Links (2007)

    yeah, i got that part down, and now i can open the folder from a text box w/ the hyperlink. i suppose thats all i need and i'll just keep the icon an icon... one day i'll make it a button.

    Thanks!
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  4. #4
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Folder Links (2007)

    Update: I can't drag & drop onto the form w/ the textbox & hyperlink, would that require some code attached to the control to do that?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Folder Links (2007)

    Somebody with Access 2007 will have to help here, it works 'out of the box' for me in Access 2002, without any code.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Folder Links (2007)

    In Access 2002, I can drag & drop onto a hyperlink field in a table, and also onto a text box bound to a hyperlink field on a form.

  7. #7
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Folder Links (2007)

    you can drag & drop onto the form's hyperlink text box control? or do you mean just the table hyperlink field? or both...? i can only do the table hyperlink field myself in 2007 - unless i'm missing something here.


    edit: i got it. i had to make the text box hyperlink property set to "yes" and then i could drag & drop it. sorry about that.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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