Parry IT Support

Notes

• https://docs.microsoft.com/en-us/office/vba/api/access.docmd

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"