G
Guest
I am trying to access the fields in an access table, through an ado
recordset, (which works), but I am trying to loop through the filenames in
the table progamatically. The fieldnames are as follows...
Mon_type1
Mon_type2
Mon_type3
Tues_type1
Tues_type2
Tues_type3
Wed_type1
Wed_type2
Wed_type3
I have tried doing it by filling a couple of array's as...
Text(2)
text1
text2
text3
....for the textbox name...
Day(2)
Mon_
Tues_
Wed_
and
Field(2)
type1
type2
type3
concatenating the day & field from the array's together
fieldname = Day(x) & Field(x)
and then looping through and painting the form with something like...
forms!frmInfo!!(text) = (fieldname)
and looping through something like that, but access is having problems with
(fieldname) even though it is enclosed with paren's. I have looped through
the textboxes on a form like this successfully and thought that looping
thfieldnames would be just as easy, but it doesn't seem to be working out.
Does anyone know how to refer to this ? Is it even possible ??
Ideas ?
TIA !!!
Michael
recordset, (which works), but I am trying to loop through the filenames in
the table progamatically. The fieldnames are as follows...
Mon_type1
Mon_type2
Mon_type3
Tues_type1
Tues_type2
Tues_type3
Wed_type1
Wed_type2
Wed_type3
I have tried doing it by filling a couple of array's as...
Text(2)
text1
text2
text3
....for the textbox name...
Day(2)
Mon_
Tues_
Wed_
and
Field(2)
type1
type2
type3
concatenating the day & field from the array's together
fieldname = Day(x) & Field(x)
and then looping through and painting the form with something like...
forms!frmInfo!!(text) = (fieldname)
and looping through something like that, but access is having problems with
(fieldname) even though it is enclosed with paren's. I have looped through
the textboxes on a form like this successfully and thought that looping
thfieldnames would be just as easy, but it doesn't seem to be working out.
Does anyone know how to refer to this ? Is it even possible ??
Ideas ?
TIA !!!
Michael