Form For creating Tables

  • Thread starter Thread starter SDIrby
  • Start date Start date
S

SDIrby

Good Morning,

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

Thank you
 
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.
Click to expand...

This seems a bit like building a house with no foundation, just the
frame, walls, roof and windows - and then pouring the foundation.

WHY!?

Actually, given that you have a perfectly good New button on the
Tables tab of the database form, wouldn't this be reinventing the
wheel?
 
Back
Top