E.25. Other Helpful Information

We've provided you with a lot of information about the Access object model in this appendix. In addition to the basic objects you'll manipulate on a daily basis, you'll need to know some of the myriad of arguments you can use with some of these objects. The following tables detail some of the arguments for a few selected objects and methods.

E.25.1. Application.SetOption Method

The SetOption method of the Application object allows you to control all of the options you can see by selecting Tools | Options from the main Access window. The following tables detail the string arguments for the options available on each tab. For example, to control the visibility of the Status Bar within your Access application, you'd use the following code.

Application.SetOption "Show Status Bar", True

The arguments you'll need to manipulate the SetOption method are broken down by the tab of the Options dialog box on which they appear.

E.25.1.1. View Tab

E.25.1.2. General Tab

E.25.1.3. Edit/Find Tab

E.25.1.4. Datasheet Tab

E.25.1.5. Keyboard Tab

E.25.1.6. Tables/Queries Tab

E.25.1.7. Forms/Reports Tab

E.25.1.8. Advanced Tab

E.25.1.9. Pages Tab

E.25.1.10. Spelling Tab

E.25.1.11. International Tab

E.25.1.12. Error Checking Tab

E.25.1.13. RunCommand Method Arguments

One of the easiest ways to perform a variety of functions in Microsoft Access is through use of the RunCommand method. You can use this anywhere within your code. The RunCommand method takes a single argument, the acCommand constant. All of the available acCommand constants are listed in the following table. For convenience, they are listed in two columns. Each of these arguments represents some command in Access that is accessible from a menu or toolbar.