MS Access - Macro - Condition Test - If A Table Exists

R

rmhindley

In a Macro, in a row running a DeleteObject action, is there a function, like
DCount, that lets you test to see if a table exists so that the Macro knows
if the step should get run? When the table exists, using the statement
DCount("Field1","Table1") in the condition column will work, however, if the
table does not exist the Macro gave no response message or anything. It
simply stops. I hope to be able to use a function like DCount in the
condition column of the row without having to create a custom module. Any
thoughts or recommendations?


If a module is needed, what is the exact code I would need to call a module
(i.e. TableExists("MyTableName") that lets me pass the table name to it so it
can respond true or false. I am a bit rusty on my visual basic coding. It
has been a few years.

Mike
 

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

Macro - Condition Test to determine if a table exists 1
Setting column width in a table with a macro is not working 0
MS Access - Macro - Condition Test - If A Table Exists 10
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Dcount -Date Criteria - Won´t find it - 0
Making a macro only work on certain files 2
Macro to copy table of contents to a new doc 0
Word VBA - Want to test if Full Name is NOT Present in document 0

Top