Error with VBE Password (XP)

Topic

New Reply

Hi, I have an application that allows users toclone and edit reports, in this case delegate badges. If I set a VBE password to protect my code, I get an error when this line runs – DoCmd.CopyObject , stNewDocName, acReport, stDocName – any ideas how I can get around this? Thanks

Reply | Quote

Replies

One option is to make sure that the reports have no code module. You’d have to move event procedures to a standard module, change them to public functions instead of private subs, and refer to the report as CodeContextObject instead of Me. You can then use expressions such as =MyFunction() instead of [Event Procedure] in the Event tab of the Properties window. Finally, set the Has Module property of the report to No.

Reply | Quote

That’s nailed it, thanks Hans you are a star.

Reply | Quote