Art (and others),
I just uploaded a file with code that creates a temporary Access file and with table structures pulled from a data definition table. I haven't tested it with all types of fields but it works for what I need.
Let me know if you have any questions.
Regards,
Duane Hookom
MN
Sent: Monday, September 11, 2017 1:16 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Creating a table on a fly
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 (7) |
Tidak ada komentar:
Posting Komentar