Hi Art,
I had to dig a bit but found an Access file that does this. It mixes several function calls and is a bit complex so I will try to upload a demo file the the group site.
Regards,
Duane Hookom
MN
Sent: Monday, September 11, 2017 9:51 AM
To: Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]
Subject: Re: [MS_AccessPros] Creating a table on a fly
With Warm Regards,
Other have pointed to some code. What I have often done is create a table of tables and a table of fields that I can store a structure in. The table can store information about field type and indexes etc. Your code can open a recordset based on the table and fields and then loop through to create all of your tables.
Duane Hookom
MN
Sent: Friday, September 8, 2017 2:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Creating a table on a fly
Is there a way to create a table or tables on the fly with vba? I would like to open up my database and click a command button and have it create the tables...
Probably asking a lot but thank you....
Thank You,'
Art Lorenzini
SD
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (6) |
Tidak ada komentar:
Posting Komentar