Field index syntax

[Rick Brown]

I have a table with fields named Part1, Part2, Part3 etc.

I get the following error message when I try to load the table via code.

Error = "Item not found in this collection"

I figure the error is in how I'm trying to index thru the fields using !Part(X)

What is the proper syntax?
For X = 1 To 8
.AddNew
!Part(X) = varRecords_Old_Data(1, X)
.Update
Next X

TIA, Rick

[MacDermott]

Try
.Fields("Part" & X)

But I suspect you'll be happier if you normalize your data structure.

HTH
- Turtle

"Rick Brown" <rb*******@compuserve.com> wrote in message
news:82**************************@posting.google.c om...

I have a table with fields named Part1, Part2, Part3 etc.

I get the following error message when I try to load the table via code.

Error = "Item not found in this collection"

I figure the error is in how I'm trying to index thru the fields using !Part(X)
What is the proper syntax?
For X = 1 To 8
.AddNew
!Part(X) = varRecords_Old_Data(1, X)
.Update
Next X

TIA, Rick

[Rick Brown]

That was the answer I was looking for, Mr. T.

If you saw the way I use data then you'd understand why its not normalized.
And then I'm still not totally sure what normalize means.

I do know I appreciate having Guru Turtles ready and waiting.

Thanks, Rick

"MacDermott" <ma********@nospam.com> wrote in message news:<F9******************@newsread2.news.atl.eart hlink.net>...

Try
.Fields("Part" & X)

But I suspect you'll be happier if you normalize your data structure.

HTH
- Turtle

"Rick Brown" <rb*******@compuserve.com> wrote in message
news:82**************************@posting.google.c om...

I have a table with fields named Part1, Part2, Part3 etc.

I get the following error message when I try to load the table via code.

Error = "Item not found in this collection"

I figure the error is in how I'm trying to index thru the fields using

!Part(X)

What is the proper syntax?
For X = 1 To 8
.AddNew
!Part(X) = varRecords_Old_Data(1, X)
.Update
Next X

TIA, Rick

[TC]

"Rick Brown" <rb*******@compuserve.com> wrote in message
news:82**************************@posting.google.c om...

(snip)

If you saw the way I use data then you'd understand why its not normalized. And then I'm still not totally sure what normalize means.

There's a reasonable article at:
http://support.microsoft.com/support...es/Q100139.ASP

HTH,
TC