Add a Command Button That Prints a Report

Command Button tool

Control Wizards tool

If you often print a report after updating your database, you can save time by using the Command Button Wizard to create a button that automates this task. In the database window, on the Forms tab, select Products and then click Design to open the Products form in form design view. If the toolbox isn’t visible, click Control Toolbox (View menu) to display it. Click the Command Button tool, and then click the Control Wizards tool if it isn’t already selected. In the Products form, click where you want to put the command button, and then follow the instructions in the wizard. When the wizard finishes, Microsoft Access displays the command button in form design view.

Program in Visual Basic

When the Command Button Wizard creates a button, it writes a Visual Basic event procedure to carry out the action you want. Suppose you want to see the event procedure for the Print Inventory Report button. Select the button and then click the Properties button to open its property sheet. In the property sheet, select the OnClick property, and then click the Build button. Using the Visual Basic programming language, you can edit or add to the event procedure that the Command Button Wizard creates. Or, write your own event procedures to customize Microsoft Access even further.

Next Steps