Results 1 to 8 of 8
  1. #1
    Hogunyi is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    5

    Opening hyperlinks / folder locations that contains #(Hashtags)


    Hello all,

    I had a quick question about how Access handles #(Hashtags) in hyperlinks and / or folder addresses.

    I have a field that contains a hyperlink to a folder but it will not work as the folder contains a Hashtag in its name.

    Is there any work around for this? Or do I just have to rename all of my folders?

    Thank you in advance.

  2. #2
    Join Date
    Jan 2020
    Posts
    5
    Have you tried using shell command took open folder?

  3. #3
    Hogunyi is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    5
    Can you please point me in the right direction? I am not familiar with that option.

  4. #4
    Join Date
    Jan 2020
    Posts
    5
    Here is a sub I finished today with then help of a member on here June07

    Private sub btndocs_click()
    Dim fldrname as string
    Dim member
    Member = me.last_name & ", " & me.first_name &" "& me.org
    Fldrnamr = "s:\yourpathe\parentfolder" & member

    Shell "c:\windows\exeplorer.exe """ & fldrname & "", vbnormalfocus
    End sub
    So

    You can get rid of the member parts. I have a folder for every record in my database and needed it to open a different folder for each so just
    Fldrnamr = "s:\yourpathe\parentfolder" which is folder path and your good to go, mines set for button click

  5. #5
    Join Date
    Jan 2020
    Posts
    5
    Sry, June7 not 07. Also im using access 2016

  6. #6
    Hogunyi is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    5
    Hello Sailor-Learning,

    Thank you very much for the suggestion. It actually works on my database.

    I didn't put it on a button though, since I wanted it to be a bit more dynamic. Here is how I used it:

    I put the field as regular text, and put in the value as 'd:\test\test#1'

    Then I put on a 'on click' event to the field:

    Private Sub Bank_statements_Click()
    Dim statementLink As String
    statementLink = [Bank_statements]

    Shell "c:\windows\explorer.exe """ & statementLink & "", vbNormalFocus
    End Sub



    I've noticed that there is a 1.5 second delay however. Any way it can be sped up? or will it just be like that when you call the shell function?

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,676
    I tested this and 1.5 seconds seems fast to me.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Hogunyi is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    5
    When using hyperlinks, the folder seems to come up instantly, so I thought this would be the same. Oh well.

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

Similar Threads

  1. Opening a Network Folder Path
    By newbie_204 in forum Programming
    Replies: 3
    Last Post: 10-17-2017, 11:41 AM
  2. Replies: 4
    Last Post: 08-03-2015, 11:16 AM
  3. Opening HyperLinks from a Combobox.
    By Torinjr in forum Forms
    Replies: 3
    Last Post: 05-06-2015, 03:27 PM
  4. Need Severe Help-Folder opening/making
    By Madmax in forum Access
    Replies: 2
    Last Post: 07-30-2011, 08:10 AM
  5. Replies: 0
    Last Post: 01-26-2011, 05:51 PM

Tags for this Thread

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