Recent content by connellg

I am using a command button from a form (Access 2000) to produce a report. The form and the report each have a subform (subreport). Here is the expression that produces a total for one field on the report. =nz([Tech Assist Subreport]![Total Service Hours])+nz([CaseLaw Updates...

Thanks for your response. The reason I wanted to use the Execute method instead of DoCmd was to avoid the interactive messages that result from running action macros.

This is the VBA code executed from OnClick on a form's command button, to run 4 macros: Private Sub Command160_Click() DBEngine(0)(0).Execute "Append to Delivery List Table", dbFailOnError DBEngine(0)(0).Execute "Print Work Order", dbFailOnError DBEngine(0)(0).Execute "Print Final...