why: when i convert macro to VBA open report not working?!

[siamandm]

Hello All
I have a button to open a report, with click event created with macro working fine and opens the required report, but when I write a code to open the same report or I click convert macro to VBA code ... the click button is to open the report any more
any suggestions, please


Regards

[HansV]

What is the code you wrote?
What does the code converted from the macro look like?

[siamandm]

it is something like this :

Code: Select all

DoCmd.OpenReport "rptCalc", acViewPreview, "", "", acNormal

[siamandm]

Dear Hans
I have figured out the issue, which caused by checking something in the trust centre as shown below:

trustCenter.jpg

so after checking back show the message bar in all.....
now the VBA codes do what they suppose to do.


thank you very much for your continuous support

Regards

[HansV]

Congratulations on finding it yourself - it would have been difficult to guess that.

[siamandm]

Thank you very much :)