Solved

Drop down list not showing data

Posted on 2007-11-29
5
756 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 500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Issue: Unstable cursor in Windows XP and Windows runs extremely slow in that any click will bring up the Hour glass (sometimes for several seconds before giving you what you want) . Troubleshooting Process and the FINAL FIX: This issue see…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
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…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

627 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