Re: Can't see combobox values in table lookup
- From: mpdsal <m.doherty@xxxxxxxx>
- Date: Fri, 18 Jul 2008 06:35:55 -0700 (PDT)
On Jul 16, 1:00 pm, fredg <fgutk...@xxxxxxxxxxxxxxx> wrote:
On Wed, 16 Jul 2008 07:57:59 -0700 (PDT), mpdsal wrote:
On Jul 16, 10:25 am, fredg <fgutk...@xxxxxxxxxxxxxxx> wrote:
On Wed, 16 Jul 2008 00:24:00 -0400, Mark wrote:
Fred,
I am running Access 2003 SP3 with Win XP Pro SP2.
Also the SQL noted below is getting its data from an Excel spreadsheet that
I have linked. Could that be causing an issue as well?
Thanks
Mark
"fredg" <fgutk...@xxxxxxxxxxxxxxx> wrote in message
news:1wzopjyoziwcs$.tf4n1h324hac.dlg@xxxxxxxxxxxxx
On Tue, 15 Jul 2008 13:58:50 -0400, Mark wrote:
I have a table with a field that uses a combobox to populate values.. The
Lookup tab within table design mode is the following:
Display Control Combo Box
Row Source Type Table/Query
Row Source SELECT [Employee Linked]..LastName, [Employee
Linked].FirstName, [Employee Linked].EmployeeNumber FROM [Employee
Linked];
Bound Column 3
Column Count 3
Column Heads Yes
Column Widths 1";1";1"
List Rows 8
List Width 3"
Limit To List Yes
When I run that query on its own I get results. But when I open the table
and click on the EmployeeID field I can see the drop down combobox and
the
column headings but no data being populated. What could be causing this?
Thanks
Mark
Always include your Access and Windows Version numbers. It may make a
difference.
Are you using Access 2003 with Service Pack 3 installed?
There is a bug.
see...
http://support.microsoft.com/kb/945674
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Did you not read the knowledgebase article?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -
- Show quoted text -
Fred,
I read the article. This is not a new install and combo boxes have
worked fine with this version except in this one instance. Should I
apply the hotfix anyway? The only thing different about this combobox
is that it is part of a Lookup within the table properties. I've never
done this before.
Mark
I would not use any combo box in a table.
Use it on the form you use for data entry/viewing and bind the combo
to the field in the table.
The table should just store the value of the selection you made on the
form.
However, I just linked to a spreadsheet, and added a lookup field to
the table as a test. it worked. I do not use Access 2003. I would
suggest you apply the hotfix. That should fix this immediate problem.
Then change the table field Lookup from Combo Box to Text Box and add
a combo box to the form for data entry and viewing. Make sure you get
the datatype correct.
By the way, looking at your current combo row source, how do you
intend to handle those instances where there might be more than one
employee with the same last and first names? It does happen often
enough to be of concern. How will you know which 'John Jones' is the
correct one to select from the combo?
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail- Hide quoted text -
- Show quoted text -
The Hotfix worked. Thanks for the input. I will consider your
recommendations concerning the combobox.
Thanks
Mark
.
- Follow-Ups:
- Re: Can't see combobox values in table lookup
- From: navvyman
- Re: Can't see combobox values in table lookup
- References:
- Can't see combobox values in table lookup
- From: Mark
- Re: Can't see combobox values in table lookup
- From: fredg
- Re: Can't see combobox values in table lookup
- From: Mark
- Re: Can't see combobox values in table lookup
- From: fredg
- Re: Can't see combobox values in table lookup
- From: mpdsal
- Re: Can't see combobox values in table lookup
- From: fredg
- Can't see combobox values in table lookup
- Prev by Date: Re: Actualizing the table
- Next by Date: Re: Another OT question
- Previous by thread: Re: Can't see combobox values in table lookup
- Next by thread: Re: Can't see combobox values in table lookup
- Index(es):
Relevant Pages
|
