Turn on Code and turn off Macros

Turn on Code and turn off Macros

Post by VEtN » Sat, 08 Nov 2008 08:18:00


I recided Access 2007 on my Test laptop. For some reason I can only run
wizard macros and not Code. I tried writing basic code "docmds" and others
and none of the code runs. Even if I conver the macros to code. Code does not
run. Is there a setting for this?
 
 
 

Turn on Code and turn off Macros

Post by Douglas J. » Sat, 08 Nov 2008 09:05:07

Have you added the folder where the database resides as a Trusted Location?

Jeff Conrad has instructions at http://www.yqcomputer.com/

--
Doug Steele, Microsoft Access MVP
http://www.yqcomputer.com/
(no private e-mails, please)

 
 
 

Turn on Code and turn off Macros

Post by VEtN » Sun, 09 Nov 2008 02:05:01

Thank you. Why cant they leave well enough alone. This new version is not a
well tought out product by any means. Terrible!
 
 
 

Turn on Code and turn off Macros

Post by Arvin Meye » Sun, 09 Nov 2008 11:38:58


Actually, having Trusted Locations solves a huge problem with security
warnings that they had with the previous version. It's an easy to implement
solution to a difficult problem.
--
Arvin Meyer, MCP, MVP
http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/