Bland Combo Boxes

L

Lou C

All of a sudden, the combo boxs in all my Access 2003 forms stop displaying
data. They open, but no selections are displayed. They worked until a few
days ago then stopped. They still display properly in my 2000 version. Any
ideas as to why?
Thanks
 
A

Arvin Meyer [MVP]

Lou C said:
All of a sudden, the combo boxs in all my Access 2003 forms stop
displaying
data. They open, but no selections are displayed. They worked until a few
days ago then stopped. They still display properly in my 2000 version. Any
ideas as to why?
Thanks

There's a good chance that you have a corrupted database. First, always work
on a copy of the database. Working on the original may make it impossible
for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com
 
L

Lou C

Arvin:
Don't think they are corrupted since I have been able to run them OK on a
different PC using Access 2003. The Access 2003 PC's that they stopped
working on were loaded from a different Access 2003 standalone software disk
purchased over the internet. Is is possible that that software had some sort
of problem that allowed it to work for a ceratin period of time? I have tried
using backup databases from as far back as March with the same results.
Additionally, I have the same problem on all four of my DB's, not just one.
 
T

Tony Toews [MVP]

Lou C said:
All of a sudden, the combo boxs in all my Access 2003 forms stop displaying
data. They open, but no selections are displayed. They worked until a few
days ago then stopped. They still display properly in my 2000 version. Any
ideas as to why?

Did you just install Office 2003 SP3? If so see
http://support.microsoft.com/kb/945674

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top