Modifying Options In VB

[adenwalker]

In the options dialogue in access 2000 there is a option to disable action queries and the status bar. Is there a way of doing this via VB so it can be applied each time the database is opened.

Also is there a code that can be used to disable cetain menu and toolbars (such as Menu Bar, Form Design, etc).
Thanks

 

[adenwalker]

Sorry, I didn't mean that.
What I meant was is there a code that de-selects the checkbox when a form (e.g. the main menu) is opened as access always defaults to show action queries as we are on a network.

 

[adenwalker]

Here goes:

Attached is an image of Access 2000 options dialogue on the Edit/Find tab.

Each time the database is open Access checks the box to "Confirm Action Queries". Is there a way via VB that when the main form opens it automatically deselects the check box for action queries?

For example on the View tab there is a check box to show the Status Bar or not. I know there is some code which can be put into the form's On Load event which unchecks this box and hides the status bar.

Hope i have explained it now!!!