Senin, 11 September 2017

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




From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
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
 


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: Duane Hookom <duanehookom@hotmail.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (6)

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