HELP! Drop Down missing information

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a customer using an application that has a few drop down combo boxes.
The main one is a drop down which is a search and displays 12 pieces of
information :File Nbr, Customer, Date, Product, Masterbill, House Bill, Nbr
Pieces . . .

Suddenly this morning, the user clicks on the drop down, NONE of the
customer information appears anymore! NOTHING has been changed with the
application. When the user goes to Customer Maintenance, the drop down for
it doesn't display either, although there are numerous records in the drop
down, none of the info displays.

However, just because the data isn't visible, if you click on a record, info
pops up.

I have no idea where to begin - other than reboot the server (where the data
is sitting on) as well as the user's pc. I have compacted/repaired the data
(all using ms 2003). There are 5 other users who do not have this problem.

Ideas? SOLUTIONS? :)

Thanks in advance for ANY information!

Janis
 
Choose About... on the Help menu.

Does it now say:
Access 2003 SP3

If so, the solution might be to uninstall Office 2003, turn off automatic
updates, and only install the updates to SP2. There are problems with combos
in SP3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Allen Browne said:
Choose About... on the Help menu.

Does it now say:
Access 2003 SP3

If so, the solution might be to uninstall Office 2003, turn off automatic
updates, and only install the updates to SP2. There are problems with combos
in SP3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
Click to expand...
 
Hi, we had another problem with SP3 and Access 2003. We have a name field
(FullName) that is not displaying in a combo box. It is created in a query
from text fields in a single table that are not formatted in the table.
FullName: [AttyLastName] & ", " & [AttyFirstName] & " " & ([AttyMiddleName])
 
Is there anything in the Format property of the field in query design?

How many rows are in the combo's RowSource query?

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

pparks said:
Hi, we had another problem with SP3 and Access 2003. We have a name field
(FullName) that is not displaying in a combo box. It is created in a query
from text fields in a single table that are not formatted in the table.
FullName: [AttyLastName] & ", " & [AttyFirstName] & " " &
([AttyMiddleName])

Allen Browne said:
Choose About... on the Help menu.

Does it now say:
Access 2003 SP3

If so, the solution might be to uninstall Office 2003, turn off automatic
updates, and only install the updates to SP2. There are problems with
combos
in SP3.
Click to expand...
Click to expand...
 
Thanks Allen. I was hoping for a less time-consuming fix but anything is
welcome after several days of stumbling.

Sys Admin friend has advised me often in the past to "update only when the
app won't work anymore;" I guess I'll have to be a better listener.

See also: Subject:"Combobox record source query results not visible in
 
Back
Top