Sunday, April 27, 2014

Mysterious MS Access Printing Failure on Report Display

While working on an assignment for an advanced-use-of-Office-applications class, I ran into a very weird bug/mislabeling in Microsoft Access. If you use the OpenReport method on DoCmd without specifying the second paramater (which is technically optional), it will produce a message saying something like "Microsoft Access couldn't print your object." That's really weird, considering that displaying reports has nothing to do with printing anything.

The solution? Supply the second parameter, the view type. I used acViewReport and everything worked great.

No comments:

Post a Comment