Writing VBA Commands

You insert VBA commands by typing them into the appropriate place in the Module window. This, of course, requires some knowledge of VBA. Access provides online Help to assist you in writing VBA code. The Visual Basic Editor also helps you with hints that help you complete a command accurately. If you have entered a command incorrectly, the Editor notifies you of the error and may suggest ways of correcting the problem. One of the most useful VBA objects you'll encounter in writing VBA code is the DoCmd object, which represents Access commands. You can use DoCmd in your commands to perform basic operations, like opening tables, reports , and forms.

Write a VBA Command to Open a Table


Click the Modules window to activate it.


Click a blank line after the Sub ProcedureName command in the Modules window.


Type DoCmd. Make sure you include the period.


Double-click OpenTable in the list box that appears, and then press the Spacebar.


As indicated by the hints supplied by the Editor, type the name of a table from the current database. Make sure you enclose the name in quotation marks.


Type a comma.


Double-click acViewNormal to open the table in Normal view.


Type a comma.


Double-click acReadOnly to open the table in Read-only mode.


Press Enter to add a new blank line below the command.


Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net