• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 362
  • Last Modified:

hyperlinks

Is there any way to link to files that have # number sign embedded into the filename
0
centralmike
Asked:
centralmike
  • 3
2 Solutions
 
MINDSUPERBCommented:
You may try to use the Hyperlink Data Type of your field.

And on the GotFocus Event of that field in a form, place this code.

DoCmd.RunCommand acCmdEditHyperlink

Sincerely,
Ed
0
 
TMWSIYCommented:
Are you using c#?  Try escaping the pound sign with a \
0
 
centralmikeAuthor Commented:
I am use VBA IN ACCESS 2007

 Dim straddress As Variant

 straddress = HyperlinkPart(Forms!frmPolicydocuments!lstPDF.Column(1))
 Debug.Print straddress
 Application.FollowHyperlink LTrim(straddress), , True
THE LIST BOX CONTAINS THE FILE NAME. But some of the filenames have the # sign in them and access throws an error message "490" can not open the specified file.
0
 
TMWSIYCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now