vba for button, hyperlink error
Competent Performer
Windows 10 
Access 2016
This code works fine on one form but not on others and I can't determine why.
Get Run-time error '2046'
The command or action'EditHyperlink' isn't available now.
Code:btnFolderLink_Click() Me.FolderLink.SetFocus DoCmd.RunCommand acCmdEditHyperlink End Sub
Very Inert Person
Windows 10 Access 2016
Is the field on the non-working form a hyperlink field?
The folderLink field is getting the focus?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Competent Performer
Windows 10 Access 2016
That's it!!!!! The ones that weren't working had "Is Hyperlink" set to no on the format tab. Thanks so much!
Just want to say that I try hard to figure out what is wrong on my own before coming to this forum. Sometimes I'll sleep on a problem and figure it out on my own, other times when I need to make some progress (like today) I come to this repository of knowledge. Such a blessing to have you and others on this site to give me a hand.
Very Inert Person
Windows 10 Access 2016
Glad to have been of some help, and thanks for the appreciation comments. Not everyone appreciates that we 'work' for free.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Using a button on search form to open a hyperlink in a table
Add button to follow hyperlink in table
Command button as a Hyperlink
Posting Permissions
Reply With Quote