Share via

Access 2016 report printing error message

Anonymous
2019-09-24T23:18:22+00:00

I'm updating an Access XP database to Access 2016. I've created new front and back ends in Access 2016 and imported all the objects from the XP version and linked the front to the back. When I try to directly open ANY of the imported reports I get this error message.

Microsft Access could not find the toolbar 'PrintClose'.

When I try to open a report using VBA - DoCmd.OpenReport "rpt#####", acViewPreview

I get the message

Run-time error '7794'.

Microsft Access could not find the toolbar 'PrintClose'.

The installation of Access 2016 looks to be entirley normal, and the Print PreviewSearching Google gives no clues to the problem, nor have my searches of this resource.

Many thanks for your help.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2019-09-25T11:02:24+00:00

In report design view, delete the entry for the Toolbar property in the Other tab of the report's property sheet.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

5 additional answers

Sort by: Most helpful
  1. Anonymous
    2019-09-26T02:19:03+00:00

    Thanks for your offered answer. Another answer below led directly to the problem and I was able to resolve the issue.

    Was this answer helpful?

    0 comments No comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-09-26T00:53:25+00:00

    Since you don't want to help me help you by providing me with information about what you found I'll release the question and maybe some other adviser will be more to your liking.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-09-25T23:03:28+00:00

    Checking the imported reports under the Other tab the Toolbar setting had been set to "PrintClose". Deleting this for all the affected reports leaving the Toolbar setting blank resolved the issue and the reports now Print Preview as expected in the Access 2016 database. Many thanks!

    Was this answer helpful?

    0 comments No comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2019-09-25T00:21:50+00:00

    Hi AJ, I'm an independent adviser and will try to help.

    It appears a custom menu was created for the reports. This menu is probably being called when the report opens. I would look in the On Open or On Load events of the reports for the reference. Either remove the reference or create a custom report to replace it.

    Was this answer helpful?

    0 comments No comments