DoCmd.SendObjects
- https://docs.microsoft.com/en-us/office/vba/api/access.docmd.sendobject
- DoCmd.SendObject acSendTable, "Employees", acFormatXLS, _
"Nancy Davolio; Andrew Fuller", "Joan Weber", , _
"Current Spreadsheet of Employees", , False
DoCmd.SetWarnings
- Turn off warnings when running queries etc
- https://docs.microsoft.com/en-us/office/vba/api/access.docmd.setwarnings
- DoCmd.SetWarnings False
DoCmd.SetOrderBy (a-z)
- https://docs.microsoft.com/en-us/office/vba/api/Access.DoCmd.SetOrderBy
- DoCmd.SetOrderBy "LastName DESC, FirstName ASC"