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

"Gator" <(E-Mail Removed)> wrote in message
news:B397F24F-E4F7-4FBC-A28E-(E-Mail Removed)...
> 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

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.

"Jeff Boyce" wrote:

> 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
>
> "Gator" <(E-Mail Removed)> wrote in message
> news:B397F24F-E4F7-4FBC-A28E-(E-Mail Removed)...
> > 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
>
>
>

On Jul 21, 12:01*pm, Gator <Ga...@discussions.microsoft.com> wrote:
> 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.
>
>
>
> "Jeff Boyce" wrote:
> > Michael
>
> > Your question implies that:
>
> > * 1) you are not using the User Interface, which makes adding a tableand
> > 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
>
> > "Gator" <Ga...@discussions.microsoft.com> wrote in message
> >news:B397F24F-E4F7-4FBC-A28E-(E-Mail Removed)...
> > > 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- Hide quoted text -
>
> - Show quoted text -

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

where in his site?

"(E-Mail Removed)" wrote:

> On Jul 21, 12:01 pm, Gator <Ga...@discussions.microsoft.com> wrote:
> > 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.
> >
> >
> >
> > "Jeff Boyce" wrote:
> > > 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
> >
> > > "Gator" <Ga...@discussions.microsoft.com> wrote in message
> > >news:B397F24F-E4F7-4FBC-A28E-(E-Mail Removed)...
> > > > 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- Hide quoted text -
> >
> > - Show quoted text -
>
> 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" <(E-Mail Removed)> wrote in message
news:228CC23B-2457-4EB4-82D0-(E-Mail Removed)...
> where in his site?
>
> "(E-Mail Removed)" wrote:
>
[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