Print Preview Errors

K

Kroggie

I'm trying to find out if anyone else has experienced this problem. I'm
supporting a database created by someone who's no longer available to
troubleshoot. It was originally Access 97, converted to Access 2000, being
used on Windows 2000 Professional OS. It's been in use for about six years,
and this is a new issue. There's a Tab Control form with several tabs, and
subforms on each page with multiple types of fields available for data entry.
The users enter data into a field on a subform, then click a button at the
bottom of the form to Preview the report that's generated. On several
occasions, when previewing the report the data that's just been entered
doesn't appear in the Preview, the field looks empty, but when the report is
printed the data is there. Other times on Preview the data is there but when
the report is printed the data is missing from that field. I'm at a loss for
how to deal with this.

Thanks for any help anyone can give me.
 
A

Allen Browne

If you know for sure that this database has worked fine for years on the
same hardware and printer, it may be a corrupted index. Try a compact repair
(Tools | Database Utilities.)

Has there been any change of printer lately, or a change to the printer
driver?

Check that the button's Click event explicitly saves the record before the
OpenReport.

If you are still stuck, try getting Access to rebuild the database for you.
Follow the steps for the first symptom in this article:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
K

Kroggie

Allen,
Thanks for your help. The database has been compacted and repaired (usually
done weekly), and due to a few other irregularly occurring errors ("module
not found") has been rebuilt as well. The database is split into data and
application files linked to the data, and both files are located on a server
and accessed across our LAN. Your article on this subject mentioned each
user receiving a local copy of the application file. Does this mean I should
have a copy of the front end for each PC that's accessing the application?
There is no user log in to this database, just to our LAN.

Because this trouble all seems to have started since we've converted to
Access 2000, someone else mentioned that maybe we need to upgrade to XP due
to issues with 2000. Would that be advisable? I appreciate your assistance
and your timely response.
Thanks,
Kroggie
 
A

Allen Browne

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Kroggie said:
... The database is split into data and
application files linked to the data, and both files are located on a
server
and accessed across our LAN. Your article on this subject mentioned each
user receiving a local copy of the application file. Does this mean I
should
have a copy of the front end for each PC that's accessing the application?
YES!!!

Because this trouble all seems to have started since we've converted to
Access 2000, someone else mentioned that maybe we need to upgrade to XP
due
to issues with 2000. Would that be advisable? I appreciate your
assistance
and your timely response.
Click to expand...

Doubt that would make a difference. What could make a difference is making
sure you have SP3 for Office 2000, and SP8 for JET 4. Both available from:
http://support.microsoft.com/gp/sp
 
K

Kroggie

Allen,
I do have SP-3 installed for Access, will work to install the Jet SP-8, and
to install the separate front ends on the PCs involved. Thanks very much for
your assistance!
Kroggie
 
Top