Adding a new field to table

  • Thread starter Thread starter Gator
  • Start date Start date
G

Gator

Are there any tutorials out there that will help me learn how to code a
table and fields from scratch when I need one.
MIchael
 
Michael

Your question implies that:

1) you are not using the User Interface, which makes adding a table and
fields quite easy, and
2) you are creating a table "on the fly", which seems contrary to the
notion of a well-normalized table structure.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I think what I'm after is how to add a field to a table through an interface,
I guess after the current record is updated / or when another record is
selected.
 
I think what I'm after is how to add a field to a table through an interface,
I guess after the current record is updated / or when another record is
selected.









- Show quoted text -
Click to expand...

Maybe I misread Jeff's question, but why do you need to add another
field to your table on the fly? Usually this is an indication of
improper normalization. If you absolutely have to do it, Allen Browne
has code on his website to do it.
www.allenbrowne.com
 
Hi Gator

The URL for Allen's site was included in Piet's message, quoted below:

BUT...... As Jeff and Piet have said, adding tables and fields on the fly
is something that generally sets off loud alarm bells for us database
professionals. 9 times out of 10 it means you are doing something wrong.

So, before you proceed down this path, we invite you to explain what you are
trying to achieve, and perhaps someone can suggest a better way.
--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

Gator said:
where in his site?

:
[snip]
Maybe I misread Jeff's question, but why do you need to add another
field to your table on the fly? Usually this is an indication of
improper normalization. If you absolutely have to do it, Allen Browne
has code on his website to do it.
www.allenbrowne.com
Click to expand...
Click to expand...
 
Back
Top