Solved

Drop down list not showing data

Posted on 2007-11-29
5
754 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
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

If your system is showing symptoms of browser hijacks or 'google search redirects' check out my other article (http://rdsrc.us/u3GP7A) first and run the tool TDSSKiller (http://rdsrc.us/GDBBs4) to get rid of the infection. Once done, and if the …
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…
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…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

679 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