G
Gavuk
Hiya all,
Can anyone help me please i have a xls that is to be sent
out to various users. On the sheet i have limited some
columns using Validation. the problem that i have is that
i am going to be reading the xls sheeet straight into an
(already) established access database - simple - yes. But
i need to know the id numbers of the selcted validation
fields not the actual value in the fields. i.e. Aberdeen =
number 1, ayreshire = 2 etc. I assume that this can be
done using hidden fields and some vba can anyone help
please??
Can anyone help me please i have a xls that is to be sent
out to various users. On the sheet i have limited some
columns using Validation. the problem that i have is that
i am going to be reading the xls sheeet straight into an
(already) established access database - simple - yes. But
i need to know the id numbers of the selcted validation
fields not the actual value in the fields. i.e. Aberdeen =
number 1, ayreshire = 2 etc. I assume that this can be
done using hidden fields and some vba can anyone help
please??