CODEWITHSUNDEEP
ms-accessvba
BobSki
BobSki

Reputation: 1552

Macro stopped working after upgrading Microsoft Office

I am running some legacy VB6 applications with Access as our main tool for reports.

We are making the switch to Office 2016.

When I try to run a macro from my vb6 application I get an error stating that:

"2001 - You canceled the previous operation"

The error comes up on this code...

Acc.DoCmd.RunMacro "MarcoName"

I launched Access and clicked EnableContent. Then I went to Trust Center and marked it so that it "Doesn't show messages for blocked content". It doesn't do the trick. Although, if I use the code below, everything seems to run fine. So I think there is only an issue with RunMacro command which works on Office 2007.

Acc.DoCmd.OpenQuery "qryName", acViewNormal

Upvotes: 0

Views: 292

Answers (1)

BobSki
BobSki

Reputation: 1552

In Access Options -> Trust Center -> Trust Center Settings -> Macro Settings ->**Enabled All Macros**

Upvotes: 1

Related Questions