How to set VBA Options via Code
Is it possible to set the VBA Options Compile On Demand and Background Compile via VBA code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi RgGray3,
<why would you need/want to toggle this via code?>
I would like to be able to initialize these options to my preferred values whenever I open a database (in case I had chanegd them temporarily, or in case I copy my database to another PC).
<why would you need/want to toggle this via code?>
I would like to be able to initialize these options to my preferred values whenever I open a database (in case I had chanegd them temporarily, or in case I copy my database to another PC).
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the help gents, I'll spilt the points.
I have code to toggle other Access options... havent seen that one exposed.... though you have me curious. So I am searching....
But, to what end? why would you need/want to toggle this via code?
just curious....