Appendix . Quick Reference for DoCmd Methods

Method

Description

DoCmd.SendObject
[objecttype]
[, objectname]
[, outputformat]
[, to][, cc]
[, bcc][, subject]
[, messagetext]
[, editmessage]
[, templatefile]

Sends the object indicated via e-mail.

[object.]
RunCommand
command

Runs a menu or toolbar command.

DoCmd.AddMenu
menuname,
menumacroname,
statusbartext

Adds a menu to Access.

DoCmd.ApplyFilter
[filtername]
[, wherecondition]
[, filtertype]

Applies a WHERE clause filter to a table, form, or report.

DoCmd.Beep

Uses the computer speaker to make a beep noise.

DoCmd.CancelEvent

Cancels an event that initiated a macro.

DoCmd.Close
[objecttype,
objectname],
[save]

Closes the object referred to by objectname.

DoCmd.CopyObject [destination database] [, newname] [, ...

Get Sams Teach Yourself Microsoft now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.