Results 1 to 6 of 6
  1. #1
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89

    Link to file

    Hello, I am trying to set up a linke to a file folder on the computer fore each individual, it is not going to the individual people, it is just going to the one person where I put the link to file, is there a solution to this issue? thanks for all your help
    -novice

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    ??Don't understand. Please try to describe your situation in very plain English. Perhaps you could
    a) tell us what you are trying to do, and
    b) give an example of the input and expected output.

  3. #3
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    Quote Originally Posted by orange View Post
    ??Don't understand. Please try to describe your situation in very plain English. Perhaps you could
    a) tell us what you are trying to do, and
    b) give an example of the input and expected output.

    ok, I have a database of about 1500 people with 1500 individual folders on the drive, what I am tring to do ia a link to file for each person. (I select the text and right click, then build hyperlink, then find the individuals folder.) the problem I am running into is that If i change 1 person it changes them all, is there a way to avoid this happening?

    -novice

  4. #4
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    Quote Originally Posted by sdc1234 View Post
    ok, I have a database of about 1500 people with 1500 individual folders on the drive, what I am tring to do ia a link to file for each person. (I select the text and right click, then build hyperlink, then find the individuals folder.) the problem I am running into is that If i change 1 person it changes them all, is there a way to avoid this happening?

    -novice
    My outcome I am trying to accomplish is if I click on a folder on jon doe - it opens the folder for jon doe... I then go to Jane doe - I want it to oprn up the folder for jane doe ... - What is happening now is that when I click on the button for jane doe it opens up the folder for jon doe... hope this is clear...

    -novice

  5. #5
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,725
    If you are requesting the file for Jane Doe and retrieving the file for John Doe, then something is not working as you have it set up.
    Place some message or Debug.print statements in your code to show the value of the request string. Verify that what you are asking is exactly what you are telling Access.

    Please show us the code involved.

  6. #6
    sdc1234 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2013
    Posts
    89
    Quote Originally Posted by orange View Post
    If you are requesting the file for Jane Doe and retrieving the file for John Doe, then something is not working as you have it set up.
    Place some message or Debug.print statements in your code to show the value of the request string. Verify that what you are asking is exactly what you are telling Access.

    Please show us the code involved.
    there is no code involved: on the form I created I type in a textbox- "file", then highlight the text and right click, select build hyperlink and then select my folder for that individual, should I be using code for individuals?

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

Similar Threads

  1. Trying to link to a file
    By wrbuchanan2 in forum Queries
    Replies: 3
    Last Post: 04-20-2013, 10:27 PM
  2. Replies: 2
    Last Post: 12-27-2012, 09:37 AM
  3. Link to txt file, but specify formatting
    By dumbledown in forum Import/Export Data
    Replies: 3
    Last Post: 03-20-2012, 05:52 AM
  4. Replies: 1
    Last Post: 07-26-2011, 05:18 PM
  5. Text File Link
    By pkell658 in forum Import/Export Data
    Replies: 1
    Last Post: 03-23-2010, 04:46 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