Turn off warnings but still print them to text file

[Ben8765]

Hi,

Is there a way to turn off the warnings, but still print them to a text
file(log)?

-Ben

 

[Dirk Goldgar]

Hi,

Is there a way to turn off the warnings, but still print them to a text
file(log)?

You mean the warnings about "You are about to append/delete n records"? You
can't log that information without programming for it specially. If it's
information from executing action queries via RunSQL, you can use the DAO
execute method to run the query and immediately check the database object's
RecordsAffected property, and use your own code to write that information to
a log file. For example,

With CurrentDb

.Execute "DELETE FROM Table1 WHERE DateField<Date()", _
dbFailOnError

WriteLog "Deleted " & .RecordsAffected " records from Table1"

End With

If you want to log such activities when carried out via form operations, you
need to use special code to do that, too.

 

[Ben8765]

Thanks, a lot, i'll try this tomorrow.

-Ben

You mean the warnings about "You are about to append/delete n records"? You
can't log that information without programming for it specially. If it's
information from executing action queries via RunSQL, you can use the DAO
execute method to run the query and immediately check the database object's
RecordsAffected property, and use your own code to write that information to
a log file. For example,

With CurrentDb

.Execute "DELETE FROM Table1 WHERE DateField<Date()", _
dbFailOnError

WriteLog "Deleted " & .RecordsAffected " records from Table1"

End With

If you want to log such activities when carried out via form operations, you
need to use special code to do that, too.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)