How Do I Code "Options"?

[tomco22]

How would I change startup options via code. I don’t want to go to every computer to navigate through “TOOLS > OPTIONS… > Edit/Find to uncheck the three boxes in Confirm:

Record changes;
Document deletions;
Action queries.

I would also like to change the “Default database folder:” to C:\ via code.


Tom
MCSD
I Nab Terrorists

 

[cghoga]

Using DoCmd.SetWarnings False in the code of the app itself should remove most of the headache.

Hope this helps.

 

[GingerR]

Hi there--Look up the SetOption method of the Application object in HELP. It tells you every option from the TOOLS+OPTIONS tabs and how to set them in VBA. Put the code into a module that gets lauched when the db opens.

Hope this helps--g



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tomco22]

cghoga & GingerR

Thanks for the help. One or both of your solutions will quickly solve my problem when I sit down to compute tomorrow morning. Thank you for your help.


Tom
MCSD
I Nab Terrorists