Format for hyperlink with pound sign

[Guest]

Hello,

While setting up a hyperlink to a pdf, we would also like to include the
variables within the URL that would instruct which page of the pdf to open as
well as the zoom value. The hyperlink would look like this:
http://www.mywebsite.com/test.pdf#page=2&zoom=100,0,150. Access is confused
by the pound symbol and converts it to a forward slash.

Is there some other format/char code we can use in place of the pound symbol?

Cheers,

simo

 

[Guest]

Hi Simo,

I don't know if this will work, but it's worth a shot. Try storing your URLs
in a text field, if the lenght does not exceed 255 characters. Then use

Application.FollowHyperlink
"http://www.mywebsite.com/test.pdf#page=2&zoom=100,0,150"



Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Tom,

Thanks for the suggestion. Just gave it a try, and the pound symbol still
converted to a forward slash.

In the meantime I also created an additional text field for the portion of
the hyperlink that follows the pound symbol and tried this as the
HyperlinkSubAddress property. The pound symbol remained the pound symbol,
however the browser treats what follows as an anchor tag so basically it
didn't understand what to do so opened an empty browser window.

Any other suggestions?

Simo

 

[Guest]

Hi Tom,

Just wanted to let you know that I created an additional text field to hold
the portion of the hyperlink from the # symbol to the end
(#page=2&zoom=100,0,150) and used this Application.FollowHyperlink
Me.Listbox.Column(0), Me.Listbox.Column(1) as an onclick event for the
command button. Success!

Thank you for your help - I appreciate it!

Simo

 

[Guest]

Glad to read of your success! Thanks for reporting back.
(Per your last post, I didn't have any more suggestions, so I'm happy to
read that you found a work-around).


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[John Nurick]

Hi Simo,

A value in a hyperlink field can have up to 4 parts separated by hash
signs:
DisplayText#Address#SubAddress#ScreenTip

Your
http://www.mywebsite.com/test.pdf#page=2&zoom=100,0,150
contains an address and subaddress in the DisplayText and Address
positions. Try prefixing a hash sign:
#http://www.mywebsite.com/test.pdf#page=2&zoom=100,0,150


See the Access (not VBA) help topic "About Hyperlinks" for more.