Solved

Drop down list not showing data

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Company splitting up.  Need advice on splitting AD domain. 2 61
I need to activate a virtual server 2003 5 22
Windows print sharing 1 92
disable Win7 network security 2 185
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine. Here is how to get rid of this: Click Start Clic…
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…

752 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