Make Table and Append Table Warnings

  • Thread starter Thread starter Marv Trott
  • Start date Start date
M

Marv Trott

Hi,

I combined both of these procedures in one subroutine that calls a report.

How can I make this sub run the report without displaying the warning
messages that need approval to continue?

Thanks,

Marv
 
Hi,

I combined both of these procedures in one subroutine that calls a report.

How can I make this sub run the report without displaying the warning
messages that need approval to continue?

Thanks,

Marv
Click to expand...

DoCmd.SetWarnings False
' Do what you want here
DoCmd.SetWarnings True
 
Fred,

It did the job. Thanks

I had been looking for this info in both MS Office Access 2003 Bible (Wiley)
and Using Access 2003 (Que). With your suggestion I found a reference in
Using Access 2003 on page 1211 under DoCmd Task Category - Miscellaneous -
Information - Set Warnings.

Marv
 
Back
Top