Form For creating a Table

[Sdirby]

Good Morning,

This is a project i'm working on in my spare time, just to see if i can do it. What i'm looking for is, I want a database that's Blank. No tables, noting but 1 form. That form will be used to create tables. I want all the relevant info to be input in to the corresponding text box etc. But i'm wondering about how to do the Field names, should i use a listbox and create an array, or should i use multiple text boxes and just have 1 text box for how many fields i want, and on the ON ENTER command could it generate that many text boxes to use as fields for the field names. I've heard that an array would be best, but i'm not exactly sure how to go about doing it just yet. I would very much appreciate your input, and if you know of a place with tutorials and such about arrays i would very much like to read them. After all of the info is input into it's place, i'm going to use a button that runs a SQL query to create the table from all of the data on the form, This seems difficult, but i think i can get it to work. Feel free to criticise, and this is not a necessity, just a challenge for me.

Thank you,

 

[gol4]

My advice would be to replicate the form that pops up when you click on new under the access tables tab
it has a section for you to set most of the relevant properties.
Also as I remember there is a sample VB project that basically walks you thru this sort of thing. It's called visdata or something like that