Create a table from Form input data

[Malcolm]

Hi all

Me again: I am trying to design an interface, using forms
in Access 2000 for unit trainers, with limited computer
knowledge (I am a relatively novice user of Access 2000 at
this level myself).

The first task is to allow them to define a new process in
an existing table, with minimal information of:

Code, Area Name, Title and Description.

I would like to know if it is then possible to
automatically create a new table, with the above "Code" as
its name, by copying an existing table (template with
structure only) to this name, and further if a 'user input
form' can be created for this table, again based on an
existing form.

The data input to the created table is to be used by third
party software, using ODBC.

I hope this is understandable, and thanks in advance for
any help you can provide.

 

[John Vinson]

Hi all

Me again: I am trying to design an interface, using forms
in Access 2000 for unit trainers, with limited computer
knowledge (I am a relatively novice user of Access 2000 at
this level myself).

The first task is to allow them to define a new process in
an existing table, with minimal information of:

Code, Area Name, Title and Description.

Easily done... just have a Form which allows creation of new records,
and include controls for the added data.

I would like to know if it is then possible to
automatically create a new table, with the above "Code" as
its name, by copying an existing table (template with
structure only) to this name, and further if a 'user input
form' can be created for this table, again based on an
existing form.

But this is a VERY BAD IDEA. Storing data in tablenames is NEVER
necessary, and creating redundant identical tables isn't either.

The data input to the created table is to be used by third
party software, using ODBC.

ODBC can and should link to a Query selecting by the Code field; it is
*not* necessary to create a Table in order to do so.