Senin, 11 September 2017

Re: [MS_AccessPros] Creating a table on a fly

 

Any possibility of seeing a example of this?


With Warm Regards,
 
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265  Ext. 130
Fax (605)964-1070

"Valar Dohaeris"






On ‎Friday‎, ‎September‎ ‎8‎, ‎2017‎ ‎08‎:‎56‎:‎33‎ ‎PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:


 

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
 


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: Art Lorenzini <dbalorenzini@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

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