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 / February 2008

Tip: Looking for answers? Try searching our database.

Help!  Glitch in my form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
shannaj - 11 Feb 2008 21:02 GMT
I was hoping someone could help me.  Today I opened one of my forms that my
department uses on a  daily basis and there seems to be some glitch with it.
I have a lookup from one of my tables in my form.  Today when I try to type
in it, the primary key column is gone.  It is a combo box so you can see the
2 columns that I have it looking up, but you can only see the items in the
2nd column, the 1st column items are gone is gone.  No one could have messed
with the tables or the form itself because they do not have access to it.  I
have looked over my tables and do not see what could have caused this.  I
have also tried making a couple of new tables and using one to look up the
other and nothing will show also.  This is weird.  Any one know what could
have happened?
Linq Adams - 11 Feb 2008 21:30 GMT
Ha anything changed recently? Your problem sounds suspiciously like a bug the
Access 2003 service pack, SP3 causes. IF you're running 2003, have you or has
your IT techies installed SP3? If this is pertinent, have a look at Allen
Browne's write up on this, which includes a link to a hotfix for the problem.

http://allenbrowne.com/bug-Access2003SP3.html

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

shannaj - 11 Feb 2008 21:51 GMT
That worked!  Thank you so much!

>Ha anything changed recently? Your problem sounds suspiciously like a bug the
>Access 2003 service pack, SP3 causes. IF you're running 2003, have you or has
>your IT techies installed SP3? If this is pertinent, have a look at Allen
>Browne's write up on this, which includes a link to a hotfix for the problem.
>
>http://allenbrowne.com/bug-Access2003SP3.html
 
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.