In need of a 100 lb. MS Access brain…the problem I having is with the Hyperlink field I have in a form with Access 2010.
Table Name = tblOrg
Form Name = frmOrg
Control Name = ctlOrgTabs
Tab Name = CONTACT INFO:
Hyperlink Field = OrgWebSite
Is Hyperlink = Yes
Display as hyperlink = If Hyperlink
Edit Hyperlink:
Link to: = Existing File or Web Page
Look In: = Current Folder
Text to display = Adobe Systems, Inc.
Address: = http://www.adobe.com/
Text displayed in Hyperlink field when clicked = Adobe Systems, Inc.#http://www.adobe.com/#
It is designed to open frequently accessed web pages from certain organizations
Up until a few days ago it was working fine and now it has started displaying the "Address" URL bracketed by # signs along with the "Text To Display" I entered in.
The hyperlink is displayed correctly when the form is first opened.
When I click on the field the URL appears and it will not follow the link. I have to click outside the field then click in the field again before it opens the web page…all the while displaying both the "Text to display:" bracketed by pound signs #, and the URL "Address:".
It works as long as I stay in that record.
I have all the settings correct (listed above) for the hyperlink field in the table.
I even tried the "On Click" event.
Private Sub OrgWebSite_Click()
FollowHyperlink Me.OrgWebSite
End Sub
Then it gives me the MS Access Security Notice…This location may be unsafe. If I hit the "Yes" button I get the run-time error '490' Cannot open specified file
No recent upgrades to MS anything…to my knowledge.
Not sure what is going on.!?
Thanks!
Table Name = tblOrg
Form Name = frmOrg
Control Name = ctlOrgTabs
Tab Name = CONTACT INFO:
Hyperlink Field = OrgWebSite
Is Hyperlink = Yes
Display as hyperlink = If Hyperlink
Edit Hyperlink:
Link to: = Existing File or Web Page
Look In: = Current Folder
Text to display = Adobe Systems, Inc.
Address: = http://www.adobe.com/
Text displayed in Hyperlink field when clicked = Adobe Systems, Inc.#http://www.adobe.com/#
It is designed to open frequently accessed web pages from certain organizations
Up until a few days ago it was working fine and now it has started displaying the "Address" URL bracketed by # signs along with the "Text To Display" I entered in.
The hyperlink is displayed correctly when the form is first opened.
When I click on the field the URL appears and it will not follow the link. I have to click outside the field then click in the field again before it opens the web page…all the while displaying both the "Text to display:" bracketed by pound signs #, and the URL "Address:".
It works as long as I stay in that record.
I have all the settings correct (listed above) for the hyperlink field in the table.
I even tried the "On Click" event.
Private Sub OrgWebSite_Click()
FollowHyperlink Me.OrgWebSite
End Sub
Then it gives me the MS Access Security Notice…This location may be unsafe. If I hit the "Yes" button I get the run-time error '490' Cannot open specified file
No recent upgrades to MS anything…to my knowledge.
Not sure what is going on.!?
Thanks!
