supress messaging

[stickandrock]

What option do I need to supress the messaging used by access to should
tables rows being affective.

when I add a row through a form , I want to give my own message (which I can
do), but I don't want to show the normal append message given by normal
access processing

 

[Allen Browne]

That would depend on how you are appending records.

If you add new records through a bound form (recommended) you do not need to
worry about the message.

If you add new records with RunSQL, setting SetWarnings to False would
suppress the message, but then you would not know if the append succeeded or
failed.

If you append new records with an Execute and use the dbFailOnError switch,
you do get a trappable error if it fails, but there is no message if it
succeeds. Example:
strSql = "INSERT INTO ...
dbEngine(0)(0).Execute strSql, dbFailOnError