Topics Search

Printing Reports in AC 2003 Hangs

Printing Reports in AC 2003 Hangs
Views: 3
I was wondering if someone could help me with this.

I have some reports that won't print. If you send it to a printer or PDF it will just hang.

The reports come up just fine, they look great just won't print
Sponsored Links:

Similar posts...


a2k set printer before printing reports

a2k set printer before printing reports Icon
I am printing several reports at one time from a command button. I would like to set the printer (same for all reports) for these reports before I open them. I cannot find a way to do this in access 2000.
Currently, I use this code, but it opens the print dialog for each report:

All of the code samples I find are 2003 or later. There are references online to printer utility code for A2000 from Albert Kallal, but all of the links are broken.

Access 2007 hangs

Access 2007 hangs Icon
I've been using Access 2007 and I've noticed quite a bit of lag when moving around in various parts of the program.

I might be adding a field to a table and when I tab over to select a field type Access hangs, creating a form hangs, switching views in reports or queries hangs, pretty much any changes made the software hangs. Usually the computer is fine but sometimes it makes the whole system lag.

My CPU usage doesn't go above 25% but it does bounce around from 15-25 when I'm working with it and when it hangs, so I'm not really sure.

Printing Multiple Reports with one command

Printing Multiple Reports with one command Icon
I have multiple reports that need to be printed at the same time. Aside from printing each one separately (there are roughly 20 different reports) is there a way to create a macros that allows the user to press one print button that prints all the reports

Printing fine but unable output reports

Printing fine but unable output reports Icon
I use Access 2003. I have several reports that are printed with a Macro. The account data is provided from a query. This works fine for printing but now I want to save these reports to a directory and use them as attachments for an email.When I use output in the macro I get garbage. It should be in Rich Text. something is not working right, I'm out of ideas

Heres what I have so far
Object Type =Report
Object Name =Anything
Object Format =Rich Text Format
Object File =C:\Edocs\
Auto Start =No

Margin Error when Printing Reports in Access 2007

Margin Error when Printing Reports in Access 2007 Icon
I am receiving the following error when printing different reports to several different printers in Access 2007:

"The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank. For example, the report width may be wider than the page width."

According to my co-workers this issue began immediately following the upgrade to version 2007 from 2003.

Printing multiple reports excluding empty reports

Printing multiple reports excluding empty reports Icon
Previous threads in this forum have extensively discussed many ways of printing subreports whilst ignoring empty subreports. Interestingly, I came across another thread few years ago describing multiple reports printing using standard module. The VBA script can be, for example:
Public Function OpenMyReports()
DoCmd.OpenReport "Reportname1"
DoCmd.OpenReport "Reportname2"
End Function.
So we can call on this function using codes from a switchboard item.
However, if the report has no values, only labels within that report with no values are printed.
But is there a way of not printing empty reports while using this code?
Could it be that additional codes may be necessary somewhere else


Reports Icon
Reports will organize and group the information in a table or query and provide a way to print the data in a database. Learn how to create reports using the wizard, create reports in Design View and Printing reports.

print reports, two-sided printing

print reports, two-sided printing Icon
When I"m printing out reports two-sided, the other side of the page shows nothing but the page background theme, so page 2 actually starts on page 3.

If I print it one-sided, everything works out perfectly with 2nd page blank in white.

I would like to solve this problem of two-sided printing

Printing issue

Printing issue Icon
Access 2003 data base with many end users. This is a training and incident tracking system and the end users need to print reports for each record. Is there a way to print just one record at a time as opposed to printing all records or having the users have to indicate what pages they need to print

password before printing reports

password before printing reports Icon
is there way to print the report in access 2003 after entering password.