Table creation

T

The Iconoclast

Greetings.
Can anyone please help me?
Is it possible to create a table with several fields by means of code? Also
is it possible to delete a table by means of code (VBA).

Thanks.
 
D

Douglas J. Steele

Yes to both. Recognize, of course, that VBA and Macros are not the same
thing in Access.

I use DAO for things like this. You'll need to use the CreateTableDef and
CreateField methods for the first. You'd use the Delete method of the
TableDef collection for the second.
 

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 to select and delete levels of a document 2
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Help creating a search form in Access XP 0
Adding data to MS Access from csv file 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Compile error in table level validation expression in ms access office 2019 0
Is this possible? 0
Consolidation Table from Different Excel Tabs with Different Format 1

Top