Is there a way that I could trigger an access macro from a VB app?
Printable View
Is there a way that I could trigger an access macro from a VB app?
Come on I thought you guys would know this.
Search there have been plenty of things like this come up. You'd have to open an instance of Access from inside VB.
VB Code:
'something like this 'after setting a reference to the Access object dim appAccess as Application.Access Set appAccess=New Application.Access appAccess.DoCmd.RunMacro "MacroName"