I have the following line in a VBA program:
rs.Open "Select * from " & QryTable1
QryTable1 is a string variable that should equal the name of a Query of Table in my Database.
Obviously, I get an error whenever QryTable1 does not match a Query or Table in my Database.
My question is can I precede the above line with a line or two that tests whether or not "QryTable1" actually exists in my Database? I would like to set the variable QryTableTEST = 1 whenever "QryTable1" does not exist.
Thank you for any help.
Jim
rs.Open "Select * from " & QryTable1
QryTable1 is a string variable that should equal the name of a Query of Table in my Database.
Obviously, I get an error whenever QryTable1 does not match a Query or Table in my Database.
My question is can I precede the above line with a line or two that tests whether or not "QryTable1" actually exists in my Database? I would like to set the variable QryTableTEST = 1 whenever "QryTable1" does not exist.
Thank you for any help.
Jim