Inserting a table

[Guest]

Aloha,

I have created a form in Access, but want to insert a table to contain
information particular to each record that is created by using this form.

Can anyone help me?

 

[Joseph Meehan]

Aloha,

I have created a form in Access, but want to insert a table to contain
information particular to each record that is created by using this
form.

Can anyone help me?

It sounds like you want to add a sub-form. That form will need to be
based on a table that you already have created. Access has a few wizards to
help you through the process. Sorry I can't offer any more specific help,
but you have not provided a lot of detail for us to go on.

 

[Larry Daugherty]

Hi HC,

I'll bet you're some fat old guy with a white beard like mine.

While everything is intended to be helpful, first the pedantic lecture
and then the direct help.

If you already have your form designed and are now looking to design
the table to hold the data you're a newbie to Access because that's
back to front in this relational database world. It seems so natural
when you're starting and you're pretty sure you know what you want to
do.

As you are developing a database application you should identify the
entities in play in it. Entities are people, places, things,
ideas --- essentially noun elements. Those become your tables. Once
you have your entities defined you determine the attributes you want
to track for each entity. Once all that is done, you're ready to
design your forms. You've gone the other way around. Not a big
problem, just makes some things more tedious than they otherwise might
be. Also, it's quite proper to show things on a single form that may
come from more than one table.

With your form maximized, hit the Print Screen button on the keyboard
to put the screen shot in the clipboard. Open a new document in Word
and paste your form's image into it. Print it.

Make a copy of your form in the database just in case something goes
awry.

Go to the Tables tab of the Database window and design a new table.
Rather than fuss with a natural key, make the first field in your
table TableNameID and give it a data type of Autonumber. Substitute
your table's name for TableName above. For each Control on your form
that will be bound to a field in this table, create a field with the
correct data type. When done, save the table with the name of the
entity it tracks: tblTableName. Accept the wizard's suggestion of the
Autonumber field as the Primary Key.

Open your form in Design mode and turn on the Properties window by
clicking the properties icon ( a hand in front of a datasheet ).
Click the Data Tab. For each control on your form that tracks a field
in this table, click just to the right of the Control Source property
to expose the drop-down arrow. Click that arrow to show the list of
fields in your table. Click the field for this control. You have
just bound this control to that field.

HTH

 

[Guest]

Larry,

I am an actual Hawaiian Chick (100% - both parents).

I thank you for the information you have detailed to me. I will work with
it and see if it helps.

Thanks again,
The "Original" Hawaiian Chick

Hi HC,

I'll bet you're some fat old guy with a white beard like mine.

While everything is intended to be helpful, first the pedantic lecture
and then the direct help.

If you already have your form designed and are now looking to design
the table to hold the data you're a newbie to Access because that's
back to front in this relational database world. It seems so natural
when you're starting and you're pretty sure you know what you want to
do.

As you are developing a database application you should identify the
entities in play in it. Entities are people, places, things,
ideas --- essentially noun elements. Those become your tables. Once
you have your entities defined you determine the attributes you want
to track for each entity. Once all that is done, you're ready to
design your forms. You've gone the other way around. Not a big
problem, just makes some things more tedious than they otherwise might
be. Also, it's quite proper to show things on a single form that may
come from more than one table.

With your form maximized, hit the Print Screen button on the keyboard
to put the screen shot in the clipboard. Open a new document in Word
and paste your form's image into it. Print it.

Make a copy of your form in the database just in case something goes
awry.

Go to the Tables tab of the Database window and design a new table.
Rather than fuss with a natural key, make the first field in your
table TableNameID and give it a data type of Autonumber. Substitute
your table's name for TableName above. For each Control on your form
that will be bound to a field in this table, create a field with the
correct data type. When done, save the table with the name of the
entity it tracks: tblTableName. Accept the wizard's suggestion of the
Autonumber field as the Primary Key.

Open your form in Design mode and turn on the Properties window by
clicking the properties icon ( a hand in front of a datasheet ).
Click the Data Tab. For each control on your form that tracks a field
in this table, click just to the right of the Control Source property
to expose the drop-down arrow. Click that arrow to show the list of
fields in your table. Click the field for this control. You have
just bound this control to that field.

HTH