Accessing a new field

S

Shell

In Access 2000, I have added, via code, a new field into a table. The field
name is
"Date_" & Date

Every time I run the program, no more than once a day, I add this new field
(column) to the table. How do I access this field, in code, so I can enter
data via
rst.Edit and rst.Update and rst.MoveNext? The data I am entering has
already been gathered previously in code.

Thanks
 
P

PieterLinden via AccessMonster.com

Shell said:
In Access 2000, I have added, via code, a new field into a table. The field
name is
"Date_" & Date

Every time I run the program, no more than once a day, I add this new field
(column) to the table. How do I access this field, in code, so I can enter
data via
rst.Edit and rst.Update and rst.MoveNext? The data I am entering has
already been gathered previously in code.

Thanks
Click to expand...

Wait. You're adding columns to your table on a daily basis? Why? Is there
a reason that a crosstab query will not give you the results that you need?
I'm really leery of your solution, given that you're basically creating a non-
normalized structure. It's fine now, but wait until you try to query a
structure like that. Trust me, it's very likely not worth the hassle.

What business problem are you trying to solve? Reading between the lines, it
sounds like you are making work for yourself. What kind of data are you
adding to your table? Is it summary data? If so, is there a reason you
cannot generate it with a summary query?
 
Top