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
Click to expand...

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?
Click to expand...

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