Access 2002 Options settings thru Code/Macros
Posted on 2005-04-29
I need to set certain Options in Access 2002 without having to drop down the menu and choose them.
For instance, if dont want Access to CONFIRM record changes during a query, I would usually open the mdb file, drop down the OPTIONS menu under TOOLS, open the EDIT/FIND tab and uncheck ACTION QUERIES.
Now the question is, how do I achieve the above without having to go through the above steps? In other words, is there any code/macro I can use to achieve my goal?