I'm using a print command button on a form:
Private Sub cmdPrintCG_Click()
On Error GoTo Err_cmdPrintCG_Click
DoCmd.OpenReport "rptPKCorrugated", acViewNormal, ,

What wrong with this:
Private Sub Report_Open(Cancel As Integer)
Dim ctl As Control
For Each ctl In Me.Controls

Our report includes a group section which includes both a label and a text
control used to subtotal a field in the Detail section of the report.  In
addition, the Group section includes a Line control above the text control
(so it's obvious to the user that this is a total).

I have a query that outputs to MS access, this query has all the last dates
for students on different courses, I'm wanting to pull out a list of students
with their last dates they attended.
i.e. Mark jones | psychology | 23-nov-2004

I am getting an #Error in my Footer total for three sub reports in this
section when data is null in one or more of my three fields. I have it set
up as:
=ZZZ1.Report!T1TotalP+ZZZ2.Report!T2TotalP+ZZZ3.Report!T3TotalP

Could anyone tell me how to insert a record-bound chart into an access
report.  I have tried to follow the instructions from the help menu,
but I am unable to get any data to show.  I am trying to have a chart
showing each employee's percentage of total benefits, health benefits

I have a grouped report by City and a list of employees in each city. I've
got a subtotal in the City footer which counts the number of employees.
The report is currently sorted in ascending order by the City. I would like
it to be sorted by the subtotals in descending order ...

How do I keep zeros from showing in reports?

I need to make a report but the data i need for the reports are from two very
diferent tables. Is there any way i can make this happen?

I would like to build a kalender into a database to control the holidays of
my personel? How can I create an overview?

In a report, which is based on a query, I  have a field called
[TypeofComplaint]. I have other fields called [EnrollNoSchools],
[PlacementNoSchools], [APENoSchools] , and [VacancyNoSchools], which are
numbers. In the report, I want to have the total number of each of the fields

I want to be able to let the user select the number of records they want to
print on a report.  The report list the number of point a person has with the
lowest point being first place.  I want the user to be able to select how
many places they want to show.  Example: Prompt "How ...

Database: tracks hours for 8 people (all tasks have numeric code)
Report: in date footer, totals time
Question: can I break out annual and sick hours on the same line in the date
footer? Would I use a subreport and maybe another query? This is probably

I have reports, them I functioned, but now he is showing this erro
I am using access 2002, but the archive mdb is access 2000.  What i
can be this error?  How I can decides it

I am making a report that can have anywhere from 1-15 lines in the group
detail section.  Is there any way to cut the detail section off if there is
only 1 or 2 lines, so there isn't a lot of white space before the next group?
Thank you