Opening hyperlinks / folder locations that contains #(Hashtags)

[Hogunyi]

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.

[Sailor-Learning]

Have you tried using shell command took open folder?

[Hogunyi]

Can you please point me in the right direction? I am not familiar with that option.

[Sailor-Learning]

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

[Sailor-Learning]

Sry, June7 not 07. Also im using access 2016

[Hogunyi]

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?

[June7]

I tested this and 1.5 seconds seems fast to me.

[Hogunyi]

When using hyperlinks, the folder seems to come up instantly, so I thought this would be the same. Oh well.