Override system error with own message

[Sandy]

I have code that will delete a temporary table if it
already exists and display my own message in On Error GoTo
routine. The system message still displays. How can I
override this with my own message?

Sandy

 

[Allen Browne]

SetWarnings

Alternatively, Execute an action query statement to DROP the table.

If you are creating and destroying the same table, you may find it easier to
delete all the records, and append them.

 

[Sandy]

Thank you very much!

Sandy

-----Original Message-----
SetWarnings

Alternatively, Execute an action query statement to DROP the table.

If you are creating and destroying the same table, you may find it easier to
delete all the records, and append them.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")




.