I have a report that has several subreports. I need to know how to make the
text on the subreports display on the main report even if there is no data in
the subreports. Thanks.

I created a database in Access 2000, however after a recent upgrade to MS
Office 2003 and Access 2003 the reports no longer work. I get a message
"Open Report Action Canelled" when I click on the button to open a report,
also I cannot run reports using the menu in the database ...

My boss created an Access Database to track Cabinets Painted per Day, what
the Daily Goal is and the difference between the two.  He has asked me to go
in and give him a total number of cabinets painted to date and the average
amount of cabinets painted in a day.  When I go in ...

I am trying to use some code from Allen Browne that adds column headers to
your snaking column in a report. I am not sure where to put the line below
surrounded by astrist. I tried to put it in the general area of the form code
but that would not work. Can someone give me some ...

I am getting this error message when opening a report.  Can someone tell me
what I need to do so it will let me open it.
"You don't have the license required to use this ActiveX Control
You tried to open a form containing an OLE object or an ActiveX control."

I have created a report that contains the results of data entered through a
form/subform sucessfully. However within the Report Footer i would like to
create a summary report of certain aspects contained in the main body of the
report.

I must appreciate your efforts and work for Access Developers' Community.
I have a question related to ReportToPDF.
Is that possible to set the path of the PDF file being created thru your
program, to be other than My Documents.

Can someone tell me if there is something like the following for
'strikethrough'?
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.txtStatus.FontBold = True

I'm using the following to show a day of the week alongside the date in a
report. I am wondering if this should be done in the report or done in the
query... maybe even a function to return the answer to the query? Any
opinions on the best way to do it?

I am running Access 2003 and I need to total up a field on a report. It is a
sales and inventory database. I have two fields amongst many. One field is
called "Quantity" and the other is called "Price". I have both fields in the
"Detail" section of the report and in the "Item ...

Are there any benefits to using the sql code for a report as the recordsource
as opposed to the recordsource being a query?
I have inherited a multi-tentacled database that has no documentation. In
trying to troubleshoot reports, i have run across reports that use the code

I've reviewed the questions for rounding up but I'm not finding what I need
to help me to round in a calculation.  My calculation is this
=Sum(Abs([RoomType]="Double"))/2
I always want the result to round up with no decimal place.  Any help you

I need to count the total number of rooms at the end of the report.  I have
each room type counted already at the end of the report.  I only want to
count the values of "Singles", "Doubles" and "Triples", I want to exclude the
room type "Exclude" for the total room count.  Below ...

How do I print labels for alumni that is 21 and older from my alumni
database?  So, I need graduating years from 1987 and previous.  How do I tell
it to pick just those span of years (meaning, I do NOT want graduates from
the class of 1988, 1989, 1990, etc)?

In Access 2007, there is a local template called "Sales Pipeline." When you
open it and click on the "Customer List" Form, you will see a Report combo
box toeards the right. CLicking on the drop-arrow will reveal the list of ALL
reports available and these reports are autmtically ...