By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,935 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

access report will not print

P: 3

I've got a report in Access 2000 that pulls data from a temporary table. The report runs just fine but when I try to print the report, the print dialog pops up and sends "something" to the printer, but nothing ever prints. I have tried multiple computers from multiple machines all with the same result. There is nothing holding up the printer queue. When I export the report, I get the values from the table. There are multiple reports running and printing in this same fashion that work just fine. Is there a secret to building reports with recordsets and printing them in a customized format? I'm pretty sure the recordset is being closed after the report is built (in VB code) and the preview is created, but does the recordset need to be opened for the print function to work?

Oct 27 '06 #1
Share this Question
Share on Google+
1 Reply

P: 3
I figured it out... Turns out I was referencing the recordset in the header portion of the report which it doesn't like... Moving it to the report_open sub fixed the problem. Oh well, Hopefully this post will help somebody out there someday...
Oct 27 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.