I have an Access 2007 (2016 file format) data system. My report will not go into print view so I can PDF it.

Question

I have an Access 2007 (2016 file format) data system. My report will not go into print view so I can PDF it. Database is very simple, set up with two tables and one report. I recently tried to add a (page & # of pages) text box on report. But it would not stay in report after I closed the application. Now I am getting error messages and the form will not go into the print view so I can convert to a PDF document for sending out to field.

I am attaching two screenshots showing the error messages. Any suggestions for solving this problem? Is the age of the program a problem?

Answer 1

Hi Beccy,

Try following these methods to fix your issue-

1. Open the database, click on the "File" tab, then choose "Options." Select "Current Database" and select "Compact and Repair Database" in the Access Options dialogue box. This method helps in the correction of any possible database file corruption or problems.
2. Go to "Tools" and choose "References" in the VBA editor to check for any missing or broken references. Ensure that all appropriate references are chosen and that none of the "MISSING" prefixed references are missing or damaged. Try to update or fix any outdated references that you find.
3. Go to "Debug" in the VBA editor and choose "Compile [Your Database Name]." This will examine your VBA code for any syntactic or compilation issues. Correct any errors you find.
4. As a last resort, you can try backing up your database and importing all the objects—tables, queries, forms, reports, etc.—into a fresh, empty database. Any underlying problems with the database file itself might get resolved.

Best Regards.