Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • 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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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