Lesson 4 Manipulating Objects

Lesson 4. Manipulating Database Objects
4.1 Open Form
DoCmd.OpenForm “Products”, acPreview, “By Name’, ,acFormReadOnly, acWindowNormal
4.2 Open Report
DoCmd.OpenReport “Product Report”, acViewPreview,”By Name”,,acWindowNormal
4.3 Open Table
DoCmd.OpenTable “Products”, acViewNormal, acReadOnly
4.4 Open Query
DoCmd.OpenQuery “Products Query”, acViewPreview, acReadOnly
4.5 Quit
DoCmd.Quit acQuitSaveAll
4.6 Beep
DoCmd.Beep
DoCmd.Hourglass True
DoCmd.Hourglass False
4.7 Print
DoCmd.PrintOut acPrintAll, ,, acHigh, 1, True
4.8 Warning
DoCmd.SetWarnings False
4.9 Close Objects
DoCmd.Close acReport, “Products Report”, acSaveNo
DoCmd.CloseDatabase