Test for missing object

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

How can I test for amissing object? i.e. table, form, etc?

Thanks in advance--again!
 
Assuming you know the name of the object you want to find, and what type it
is (form, table, ...), you could query the MSysObjects table.

Example: Is there a local table named "MyTable"
Not IsNull(DLookup("Name", "MSysObjects", "([Name] = ""MyTable"") AND
([Type] = 1)"))

Type Ojbect
=-=- =-=-=-
1 Table
4 ODBC linked table
5 Query
6 linked table
-32768 Form
-32764 Report
-32761 Module
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why is this code not working ? 3
Multi-Select List Box Code Problem 5
object variable or with block variable not set 12
formula for expired tests 11
Copying part of a header from active word document and pasting in excel using VBA 0
Button & Labels text Anti-aliasing Problem using Windows Forms C# 0
Changing Form Object Properties 3
Loop through all controls on a form for validation. 2

Back
Top