Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Drop down list not showing data

Posted on 2007-11-29
5
Medium Priority
?
757 Views
Last Modified: 2008-02-01
I've just re-formatted my laptop and re-installed all my access files, on the forms now it does not show the list on the data however if i click on the list it will show the text data in the combo box....

it's doing this on all combo boxes and they have been correct for years....

i'm thinking it's a setting i've missed in XP or Access

Please advise
0
Comment
Question by:Benyaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

by:KaroBacsi
ID: 20390766
Hi!
Run the VB editor, from code or from tools Macro or Alt-F11,
Check tools references, any MISSING uncheck, and similar name check.
In main Access in tools check ActiveX.
May help you, after changes should in VB debug menu and compile your project will save changes on your laptop.
Useful if you have another PC try ran your ACCESS file, if run correctly check differences, in VB and ActiveX.
By
KaroBacsi
0
 

Author Comment

by:Benyaw
ID: 20394862
the only differance between pc's that work with the drop down list is Office 2003 SP2 and my laptop has SP3 on it....
0
 

Author Comment

by:Benyaw
ID: 20394882
also it's linked to my customer table, it does not show the customers on the drop down list and it doesn't show the customer on the booking form! can u recomend a way to test the customer table??
0
 
LVL 1

Accepted Solution

by:
KaroBacsi earned 1500 total points
ID: 20394995
Try create a new form with wizzard, and use in form only customer ID,name from customer table, in dropdown, when finished remove connection to table -no write, only use the data-, create a subform with wizzard with all field, use control from previously created customer name with ID ex: main form - dropdown with 3 field(you will see only one): ID, GivenName&" "&ForeignName, ID not visible, connect to subform with ID, you can see in subform only data of customer, selected with dropdown in main form. CONTROLLNAME_AfterUpdate event is call the simple VB code me.SUBFORMNAME.requery.
Try this with backed up table, or copy of original table.

If working, it seems, Acc2003 like 97 with upgrade not equal.
You need to recreate all forms. :-(
0
 

Author Comment

by:Benyaw
ID: 20403068
The problem was SP3 for Office 2003, when i re-installed Office and installed SP2 it worked perfectly...
looking on EE i've seen other people report this problem with combo boxes, i think it's because i have a the format as >! to change the text to capital letters.

Regards
Benyaw
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    …
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

704 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question