var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to supress messages
Am trying to drop tables in access.Problem is: whenever there is no such table as mentioned, I get an error message saying table doess not exist, and my automated program stops.
I have done an automation through batch file and hence would require, that
even if there be an error message, it be supressed completely.
I have uncheck the confirm options in access, yet when dropping tables , message is popping up...
Please help me...
Re: How to supress messages
If you are using visual basic, you can implement an error trap subrutine. For example:
Static Sub YourProcedureName()
On Error Goto Err_YourProcedureName
If Err = Theerrornumberyouwanttotrap Then
Hope this answer your question
Ing. Jesús Rodríguez L.
Spanish Pawn Software Specialists
You could check the AllTables collection to see if it exists before trying to drop it as well.
Are you using SQL to drop the table? Can you use DoCmd.DeleteObject?
Whenever I need to delete a table I have always used DeleteObject and if you surround it with error trapping code then it should work, example:
On Error Resume Next
DoCmd.DeleteObject acTable, "tblYourTable"
On Error Goto 0 (or your error handling label)
I assume the only error will be that the table doesn't exist. If the table could not be deleted for some other reason it will be igrnored. I personally have never had a problem with this code.