Hi Matt.
This is my first ever blog/post ever so please bare with me here. I face a similar issue as described above.
I built a SPoint "dashboard" to collect change requests from individuals. These "requests" are sent to SharePoint and I use a Designer workflow to manage the notifications when something moves from one status to another. It's pretty slick.
I currently have a "submit" button that sends the form via a data connection to two sharepoint sites and gives a happy "thank you message" but now I want to launch an Access Database and close the IP03 form at the same time.
The link to the database is on a drive, ( \\Sfaxx28\16compd\SchedulingDB\Scheduling.mdb). Currently I have it as a page in another view. There does not appear to be an available "action" to open a hyperlink on the button except for code. I was going to do the "OnClick" but I know about as much VBA code as a fly.
Any assistance is greatly appreciated. Thank you in advance.