Special Edition Using Access 97, Second Edition

Working with Access 97's DoCmd Methods

Some of the DoCmd methods duplicate menu commands, such as Print, Close, and Apply Filter/Sort. Other methods substitute for mouse actions. For example, you can use the SelectObject method to select a database object in the same way that you select an open window by clicking it or select a database object in the Database window by clicking the object's name. Other DoCmd methods provide capabilities that are not available through menu commands, such as Beep, which emits a beep sound, or MsgBox, which displays a custom message.

Table 28.3 lists available DoCmd methods grouped by task. Access 2.0 provided 47 macro actions; Access 95 added two new DoCmd methods: Save and SetMenuItem. Access 97 replaces the ...