I get this error when there is no data to display in two different
areas:
1) Where the sum and grand totals would be
2)The report requires the user to enter begin and end date... The

the more I look around for this answer, the more confused I get.
Here's what I want to do:
1.) Create a command button on my main form
2.) When this command buttom is pressed, run a query and export the output of

If a report is based on a Stored Procedure it seems that you cannot change the
Input Parameter at Report Open - you need to (statically) point it at a
control on a form. ( See Microsoft Access Developer's Guide to SQL Server
p416)

Am using  Access 2003
I have a report that gives me the count of the status of individuals .  This
works fine as long is there is only one record in the query (in my query
there is one record per month).  When I query 12 months  (individuals may

I have a report that is driven by a query. The query has ORDER BY statements
so that it sorts correctly, and it works fine. However, the report does not
seem to be sorting at to my eye, certainly not by the same as criteria as the
query. The report's "order by" property is blank, ...

I have a table with sales figures dated from 2005 to current.  I'd like a
report to show the following:
Sales for each year 2005, 06, 07
Total of sales to date

I have developed a large database system on Access 2003.  It works fine on
computers with the XP operating system.  At first it worked on a computer
with Vista, but now the reports won't open.  Help!!!

I'm having the exact same issue as described in the below post.  Has anyone
found a solution?
Subject: Slow Reponse when designing forms   10/12/2005 8:22 PM PST
By:    Luke Bailey  In:    microsoft.public.access.forms

I have a box database setup and I have to create a report based off of that
database to attach to the outside of the box that indexes everything that is
inside.  I am using a subdata form to control the data and everytime that I
print out the report, I get a report for each file ...

How do I set up mailing labels in Access 2007 so that my spouse/partner
fields:  FirstName, LastName, FirstName2, and LastName2 will print out as:  
John Smith, John and Mary Smith, or John Smith and Mary Jones.  (same
street/PO Box address)?  The wizard doesn't seem to consider ...

I have two controls, among others, on a particular form. One control
‘ContractNumber’ represents the specific customer (their phone number) and
the ‘ContractType’ which represents the specific report. I have 5 reports,
none of the reports are the same. Based on the ...

I am working with a report that I use to keep track of items outstanding for
purchase. It would be easier if the record with a value of $0 would just
print in color to distinguish it from items purchased. Is there a way to
accomplish this in Access reports?

My project is in MS Access.
In that I have one Form(DataEntry) which I am using for entering data
into the Table(PRODUCTION).
Now after entering data in Textboxes when I click on Button(Submit)

My project is in MS Access.
In which I have one Form(DatEntry) which I am using for data entry in
table(PRODUCTION).
In this Form I have some Textboxes and Comboboxes.

I've got two tables that are joined which contain the data for the report I
am generating.  The report page header is fine, it's the data header that's
not functioning as I need for it to.  Example below...
Name