How to check if a Table exist on Microsoft Access using VBA

May 2, 2015 | By | Reply More

In order to check if a Table exist on a Database (MS Access), we can use Function in VBA. Its pretty simple and I think most of you can easily learn and apply this on your own project. The idea of this function on this tutorial is to check if a table exist by typing the table name on a Textbox. See my project example here.

check if table exist

Now, here is the code. This code will be executed when Check Table button is pressed to check if table name on the text box exist in the database.

[codesyntax lang=”vbnet”]

[/codesyntax]

Result

check if table exist vba

Tags: , , , , ,

Category: Microsoft Access, VBA

Leave a Reply