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
From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, September 8, 2017 2:15 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Creating a table on a fly
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 (4) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
.
__,_._,___
Tidak ada komentar:
Posting Komentar