A
Adam Milligan
This is in response to the conversation below. I decided to start a new
thread as I don't know how long you folks follow the old ones and this is a
new problem anyway. I hope that isn't bad newsgroup form (and now I am
worried that this will get posted twice!)
Allen et al-
Thanks for the tip. I hadn't thought of the output to pdf option. However,
when I tried it strange things happened. The report is being outputted twice
to the same pdf, once with only part of the data and the second time with all
of the data. For example, page 1 of my 12 page report has radio buttons on
it, but none of them are checked, page 13 of my 12 page report has the same
radio buttons with all of the correct checks. I thought it might have
something to do with the m of n page numbers at the bottom so I took those
out, but that didn't help. Any hotfixes up your sleeve for this?
Adam Milligan
P.S. to explain a little further, the reason I am trying to do this at all
is that the report I am trying to print is a report with 13 subreports on it.
It print previews just fine but when you try to print it from the print
preview I get a "too many databases" error and only get data from the first
few subforms. If I print it without the print preview, it works fine but I
don't want to tell my users that they have to change their default printer
through the control panel if they want to print to a different printer. I
had given up hope on fixing the original problem of too many connections, but
if anyone has input on that I would be appreciative as well.
Original Message from Allen Browne
Adam, this is a bug in Access 2007.
Microsoft has released a hotfix:
http://support.microsoft.com/kb/950488
You may be aware that MS has created a download that allows A2007 to create
PDF files
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en
You can then create a PDF with code like this:
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True
thread as I don't know how long you folks follow the old ones and this is a
new problem anyway. I hope that isn't bad newsgroup form (and now I am
worried that this will get posted twice!)
Allen et al-
Thanks for the tip. I hadn't thought of the output to pdf option. However,
when I tried it strange things happened. The report is being outputted twice
to the same pdf, once with only part of the data and the second time with all
of the data. For example, page 1 of my 12 page report has radio buttons on
it, but none of them are checked, page 13 of my 12 page report has the same
radio buttons with all of the correct checks. I thought it might have
something to do with the m of n page numbers at the bottom so I took those
out, but that didn't help. Any hotfixes up your sleeve for this?
Adam Milligan
P.S. to explain a little further, the reason I am trying to do this at all
is that the report I am trying to print is a report with 13 subreports on it.
It print previews just fine but when you try to print it from the print
preview I get a "too many databases" error and only get data from the first
few subforms. If I print it without the print preview, it works fine but I
don't want to tell my users that they have to change their default printer
through the control panel if they want to print to a different printer. I
had given up hope on fixing the original problem of too many connections, but
if anyone has input on that I would be appreciative as well.
Original Message from Allen Browne
Adam, this is a bug in Access 2007.
Microsoft has released a hotfix:
http://support.microsoft.com/kb/950488
You may be aware that MS has created a download that allows A2007 to create
PDF files
http://www.microsoft.com/downloads/...11-3E7E-4AE6-B059-A2E79ED87041&displaylang=en
You can then create a PDF with code like this:
DoCmd.OutputTo acOutputReport, strDoc, acFormatPDF, strFile, True