Does Object Exist?

[Kib]

What is the code to check if an object (table, query, form, etc) exists in the database?

 

[chirpyform]

Something i would quite like to know aswell.
I think you can do something like
For Each frm In dbs.Forms
if frm.Name = "Name that you're looking for then"
MyForm = frm
end if
Next frm

Hope it helps but if there is a better way i would like to know
Chirpy

 

[danvlas]

You could use MSysObjects table. It contains all info you need...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html