Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

Cannot View Drop-down Selections

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
domadmin - 05 Mar 2008 23:40 GMT
I am not familiar with Access, so please bear with me as I try to explain the
problem. I have Access 2003 SP3 running on a Windows 2000 Terminal Server,
and the user has an Access form pulling data from an Access database.

When the user open this form, there are a number of fields where she can
type in data, and then there are two drop-down fields where data pulled from
another Access database appears. For example, the database is video library
rentals, and one drop-down field contains the ID of the video and the other
the location.

The following problem started just a few months ago. When the user clicks
the arrow next to the ID field, the drop-down selections display but cannot
be read (everything is displayed as solid white). There is data, because if
the user mouses over the list, selections will highlight black as each one is
rolled over, and if a selection is clicked, then the list closes and the new
selection is displayed in the field and is readable. Also, the location field
within the same form displays its information correctly when the drop-down
list is used.

If I log onto a Windows 2000 TS running Access 2003 SP2, or log onto a
Windows Server 2003 TS running Access 2003 SP3, everything works just at it
should and the drop-down lists show all video IDs and are readable. I also
used Access 2007 on my desktop, and again, everything is working fine.

Do any of you have any suggestions as to what may be the problem? I have no
idea what is going on unless there was some update installed that altered
Access in some way, but then I do not understand why one drop-down list would
fail and the other within the same form would work fine.

Your assistance is appreciated!
norm - 06 Mar 2008 00:05 GMT
my exact same problem and it was fixed in an earler message:

<<There is a hotfix available for incorrect values in Access 2003 after you
install Office 2003 Service
Pack 3."  And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674

Jeanette Cunningham

>I have created a form that has one combo box on it, ftom the the user
>clicks on the list of available "account codes" then hits a command button
[quoted text clipped - 7 lines]
>
> Thank you
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.