Solved

Drop down list not showing data

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Time Syncronization from Windows 7 Machine to Server 7 82
GPO not applied 4 56
windows seems to be corrupt 10 69
Determine if SQL is installed in Server 2008 R2 4 53
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!    …
INTRODUCTION The purpose of this document is to demonstrate the Installation and configuration of the Data Protection Manager product. Note that this demonstration was prepared on the basis of Windows OS is 2008 R2 and DPM 2010. DATA PROTECTI…
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…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

911 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now