I'm trying to create a macro in Access 2013 that runs a series of database inserts (appends). Normally I would do this using vba:
Sub MasterDataSets()
DoCmd.SetWarnings (False)
DoCmd.OpenQuery ("9a_create_CallPlanTrackerNational")
DoCmd.OpenQuery ("9b_append_Central_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9c_append_West_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9d_append_NorthEast_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9e_create_NewDeliverableActivity")
DoCmd.SetWarnings (True)
End Sub
I would like to run this as an autoexec macro, but I can't find an option to suppress the warning messages in the macro commands.
Any thoughts?
Sub MasterDataSets()
DoCmd.SetWarnings (False)
DoCmd.OpenQuery ("9a_create_CallPlanTrackerNational")
DoCmd.OpenQuery ("9b_append_Central_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9c_append_West_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9d_append_NorthEast_to_CallPlanTrackerNational")
DoCmd.OpenQuery ("9e_create_NewDeliverableActivity")
DoCmd.SetWarnings (True)
End Sub
I would like to run this as an autoexec macro, but I can't find an option to suppress the warning messages in the macro commands.
Any thoughts?