refer to an index field and not to its name

[thread]

Hi all,
I'm trying to build SQL sentence that will refer to field's name by its
index and not by its label name
is there an option to this?

 

[John Vinson]

Hi all,
I'm trying to build SQL sentence that will refer to field's name by its
index and not by its label name
is there an option to this?

No.

Indexes, in Access (unlike some other programs), work automatically in
the background. They aren't independent objects which you can
manipulate.

What are you trying to ACCOMPLISH?

John W. Vinson[MVP]

 

[thread]

Hi Jerry,
i think it is something for upgrading ACCESS for now i found a solution
for SQL satetments but not as ADO object
you can accualy do something like this:"[" & rcd(1) & "]"
there it will place the object that sits in place 1 without carrying
what is the name
i believe the same solution can be found when trying to refer to a
field ADO object but maybe its little bit diffrent
we are refering to the field like this
rcd![field]
maybe this is the same way somehow....

Jerry Whittle ëúá: