N
navvyman
Issue
I am using Access 2003, SP3, with Hotfix 945674 applied after reading
these postings and MS Knowledgebase etc.
I am still experiencing inconsistant problems with adding look-up values
to Forms and Tables, e.g.
Using a Look-up Table in a Combo Box, I wish to display a textual value
label in a Form, and store its associated numerical value in the
associated Table.
After days of errors, I have now tested the issue extensively with a
simple 3-value 2-column look-up table. I am unable to get Access to
*consistently* apply the look-up values as required.
The nearest that I have come to a solution is:
Using this Look-up List in a Form:
Value Value Label
-9 Absent
1 Front
2 Back
When the Bound Column for the Look-up Table attached to the Form is set
to 0:
The textual Value Label correctly displays in the Form: Absent, Front,
Back
The numerical value correctly displays in the Table: -9, 1, 2
When achieving the above results, the Data Table Look-up (if it matters)
is set to Look-up List Bound Column 0, Column Count 2.
Data can be entered into the Data Table from the Table-bound Look-up
list without problem, and is also reflected back correctly into the
Form.
This all worked fine and dandy for a few operations, after which, with
nmo obvious changes made, the Form now displays numerical values, rather
than text labels.
It seems that no matter what I do, there is some inconsistancy in Access
operation which is driving me to distraction...
I have tried BoundColumn values 0, 1 and 2 !! in
desperation and can't get it to work properly with any setting.
I used Bound Column 0 following the advice at
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP030898651033,
which says that the Bound Column number is an offset, with the first
column having a value of 0. That column contain the numerical values
that I wish to store in the Data Table.
The results when I try bound columns 1 and 2 (all other settings
remaining the same) were:
When the Bound Column for the Look-up Table attached to the Form is set
to 1:
The textual Value Label displays in the Form: Absent, Front, Back, but
with the Error Message – “The value you entered isn’t valid for this
fieldâ€
Numerical value cannot be stored in the Table
When the Bound Column for the Look-up Table attached to the Form is set
to 2:
The textual Value Label displays in the Form: Absent, Front, Back
The numerical value displays in the Table: [No value], 1, 2
Any advice and assistance, especially in rleation to any known bugs - which
this increasingly looks like to me - would be very much appreciated
Paul
I am using Access 2003, SP3, with Hotfix 945674 applied after reading
these postings and MS Knowledgebase etc.
I am still experiencing inconsistant problems with adding look-up values
to Forms and Tables, e.g.
Using a Look-up Table in a Combo Box, I wish to display a textual value
label in a Form, and store its associated numerical value in the
associated Table.
After days of errors, I have now tested the issue extensively with a
simple 3-value 2-column look-up table. I am unable to get Access to
*consistently* apply the look-up values as required.
The nearest that I have come to a solution is:
Using this Look-up List in a Form:
Value Value Label
-9 Absent
1 Front
2 Back
When the Bound Column for the Look-up Table attached to the Form is set
to 0:
The textual Value Label correctly displays in the Form: Absent, Front,
Back
The numerical value correctly displays in the Table: -9, 1, 2
When achieving the above results, the Data Table Look-up (if it matters)
is set to Look-up List Bound Column 0, Column Count 2.
Data can be entered into the Data Table from the Table-bound Look-up
list without problem, and is also reflected back correctly into the
Form.
This all worked fine and dandy for a few operations, after which, with
nmo obvious changes made, the Form now displays numerical values, rather
than text labels.
It seems that no matter what I do, there is some inconsistancy in Access
operation which is driving me to distraction...
I have tried BoundColumn values 0, 1 and 2 !! in
desperation and can't get it to work properly with any setting.
I used Bound Column 0 following the advice at
http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP030898651033,
which says that the Bound Column number is an offset, with the first
column having a value of 0. That column contain the numerical values
that I wish to store in the Data Table.
The results when I try bound columns 1 and 2 (all other settings
remaining the same) were:
When the Bound Column for the Look-up Table attached to the Form is set
to 1:
The textual Value Label displays in the Form: Absent, Front, Back, but
with the Error Message – “The value you entered isn’t valid for this
fieldâ€
Numerical value cannot be stored in the Table
When the Bound Column for the Look-up Table attached to the Form is set
to 2:
The textual Value Label displays in the Form: Absent, Front, Back
The numerical value displays in the Table: [No value], 1, 2
Any advice and assistance, especially in rleation to any known bugs - which
this increasingly looks like to me - would be very much appreciated
Paul