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

    create On Click to go to specific server folder

    Please bare with me, I am a relative noob at vb and programming in general.

    I have created a large database and I would like to create a job that when I click a specific entry or record, goes to that entries specific folder on the server. The server would never change, its always X:\X\X\folder name. And what i need it to do is go its specific folder name dependent upon what is clicked.

    I know you can do this with hyperlink but I don't have the time to go to each record and create the hyperlink every time.

    If it isnt possible to create the first job would it be possible to create one that would autofill the hyperlink box with the X:\X\X\ and then insert the name clicked on?

    Any help at all is greatly appreciated and if anyone knows of any places with the commands and what they do listed please let me know.

    Thank you very much,



    Phil

  2. #2
    grant.smalley is offline Novice
    Windows Vista Access 2000
    Join Date
    Jan 2010
    Posts
    8
    Hi,

    I recently added a command button that takes me to a specific folder depending on an entry in a certain field (Name of field). E.g C:\Folder\"Name of text box". Try adding a command button and adding this code to the on click event.

    I'm not an expert but this works for me so hope it is ofsome use.

    Name of the command button.HyperlinkAddress = "folder address" & Name of Text box.Value

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

Similar Threads

  1. Replies: 0
    Last Post: 12-16-2009, 09:28 AM
  2. Form on click
    By rexb in forum Forms
    Replies: 0
    Last Post: 11-16-2009, 08:49 AM
  3. On Click Event Procedure
    By MrDean in forum Forms
    Replies: 3
    Last Post: 10-07-2009, 07:16 AM
  4. Displaying images from another folder
    By w3leon in forum Access
    Replies: 0
    Last Post: 01-30-2009, 06:18 PM
  5. Replies: 0
    Last Post: 09-18-2006, 08:37 AM

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