Create new table from Form

Hello. I'm new to this group and I have a question:
I created a form to build a quiz by entering the question,
distractors, correct answer and graphic name if one is used, and some
other information needed for the quiz. Once the user finishes making
the quiz, I would like to have the user press a button on my form so
that information in the form is put into a new table with the same
field names as the ones used in the form. I don't want the current
db
that is linked to the form to be used as the final product; once the
new table is created and saved with a user-defined name, the form's
db
is then cleared, or refreshed, so the form can be used to make
another
quiz. I would greatly appreciate an help. Thanks in advance!

To create a new table for each individual record in a form is not going to
be workable or maintainable in MS access.

What happens then when you want a printout ten people's results? You'll be
coming back to this newsgroup and asking how can you have a report print
data from different tables? Unfortunately none of the reporting tools in MS
access allows you to do this. MS access simply does not work this way, and
cannot be used in a production environment in which you create a new table
for every single record.

Furthermore in a multiuser environment, and in fact and for most
environments creating tables on the fly is akin to try changing the engne on
an airplane while it is in flight. Try to keep in mind here you're designing
software, and software is simply a machine that solves your problem. When
you build this machine you must freeze the designs before you give it to the
users, and creating a new table for each individual user is not going to
work at all.

You'll have very little flexibility and ability to report on any of this
data with any of the built in reporting tools, since they don't work on
multiple tables with just one record each.

The very simple solution here is to simply add one additional column who to
your table, and put the user's name in that collum. That way you can
distinguish between each record, and you won't have a zillion tables being
created.

Furthermore can you imagine if down the road you decide to add one field to
your design, and you have 200 tables now? You'll be using up so much of your
developer time trying to chase and modify each of the tables as to you will
NEVER get any usefull work done.

So instead of adding a table for each individual user, simply add one little
extra column into your table design, and simply put the user's name into
that collum. This means you will not create a new table for each user. This
desing will also allow all kinds of reporting, statistics, and printouts of
all the information data in a single unified table.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

On Wed, 27 Feb 2008 14:28:55 -0800 (PST), Carlos1815
wrote:

Hello. I'm new to this group and I have a question:
I created a form to build a quiz by entering the question,
distractors, correct answer and graphic name if one is used, and some
other information needed for the quiz. Once the user finishes making
the quiz, I would like to have the user press a button on my form so
that information in the form is put into a new table with the same
field names as the ones used in the form. I don't want the current
db
that is linked to the form to be used as the final product; once the
new table is created and saved with a user-defined name, the form's
db
is then cleared, or refreshed, so the form can be used to make
another
quiz. I would greatly appreciate an help. Thanks in advance!

You're GOING AT THIS COMPLETELY BACKWARDS.

Forms are just windows, tools to edit data in tables. The tables are
*fundamental*. You don't create tables from forms; you create forms to work
with preexisting tables.

If you want to save multiple quizzes, you need a table of quizzes into which
your form *adds new records* - probably at least two tables, one with a single
record for each newly created quiz, related one to many to a table of quiz
questions.

--
John W. Vinson [MVP]