M
Michael Conroy
The basic problem is I want to check for the existance of a table before I
delete it. The setwarnings = false still allows the error message to display
and stop the program if I just have a line to delete the file with no error
trapping, which I don't really know how to do. I have borrowed code from here
that traps the error and moves to the next line, but when I type "Dim tdf as
tabledef", the tabledef is not an option in the dropdown list and the code
stops there. I would like to check for the existance of a table both in my
current database and a backup one to where I will be placing a copy of the
file. I fear I have multiple things going wrong here, but any help would be
appreciated.
delete it. The setwarnings = false still allows the error message to display
and stop the program if I just have a line to delete the file with no error
trapping, which I don't really know how to do. I have borrowed code from here
that traps the error and moves to the next line, but when I type "Dim tdf as
tabledef", the tabledef is not an option in the dropdown list and the code
stops there. I would like to check for the existance of a table both in my
current database and a backup one to where I will be placing a copy of the
file. I fear I have multiple things going wrong here, but any help would be
appreciated.