This is still in the very early stages, but it is looking like there is a new bug that has recently surfaced impacting Hyperlink SubAddress.
Threads such as the following have started popping up:
Microsoft Access (Version 2205) breaks Hyperlink.SubAddress following on forms
Microsoft Access (Version 2205) 32-bit breaks the following of the Hyperlink SubAddress property for controls on forms. To replicate the issue, on a form in Design View, add a Label control with some text like "Click Me". In the Hyperlink SubAddress property for that control, click "..." and then select another database object like another form. In Form view, click the label control "Click me", and the database should open the form that the property points to. This behavior works correctly in all Access versions prior to 2204, but in version 2205 the click is ignored.
Hyperlink SubAddress
The hyperlink subaddress in all my databases has stopped working! Help!!
Macros no longer working on hyperlink subaddress event | Experts Exchange
Macros being run from the hyperlink subaddress event of a button are no longer
so be forewarned that it is suspected to be a bug with 2205 so try and rollback your installation to 2204 or earlier.
As always, I’ll update this post should I learn anything new on the subject.
People have also reported issues with the FollowHyperlink method.
Application.FollowHyperlink sudden problem
I have used the code below for many years without issue Application.FollowHyperlink “C:\ProgramData\folder\temp.” & filetype The files it opens are either jpg, pdf or docx. Previously they would just open in windows explorer as if you have clicked on them. As of today for jpg the code just...
Workarounds?
I believe that rolling back your build to version 2204 is probably your best bet.
That said, you may also like to review
Avoiding The FollowHyperlink Security Warning
This is a brief post about using Application.FollowHyperlink in your databases. The Problem With FollowHyperlink I used to use Application.FollowHyperlink because it was so very simple to use to start e-mails, open files, launch a URL, … Private Sub cmd_StartEmail_Click() If IsNull(Me.EmailAddress) = False Then Application.FollowHyperlink Me.EmailAddress End Sub until I started getting the dreaded…
Continue reading →
VBA - Opening Files and URLs
So what does a developer do when he can’t sleep? He explores what options can be used to open files and/or URLs, of course! In this article I will attempt to explore multiple appraoches that can be used to open files and URLs using VBA, the choice of which one to use is left to…
Continue reading →
perhaps one of those articles can offer a different approach, workaround, to get around this latest update blunder.
Microsoft In All This?
Please note that I already alerted Microsoft earlier in the day (2022-05-28), but haven’t heard back yet.
Update: 2022-05-29 11:25
I have had an acknowledgement that a fix is in the works.
Update: 2022-05-29 19:00 - Fixed
Microsoft has informed us that they have disabled the ‘feature’ causing this issue. There is nothing for you to install, rollback, … Just close Access, then restart it and the issue should resolve itself.
Please Share
If you’ve:
- Experienced any issues relating to this
- Can confirm rolling back your build does resolve the issue
- Found a fix
please leave a comment below. This will help ascertain the scope of the issue and help fellow Microsoft Access users.
