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

Beccy Strohm 25 Reputation points
2023-06-27T14:54:15.8066667+00:00

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?

Access question Screenshot 2023-06-27 093232

Access question 2 Screenshot 2023-06-27 093357

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
{count} votes

Accepted answer
  1. Tanay Prasad 2,250 Reputation points
    2023-06-29T07:29:25.2933333+00:00

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.