I have a messagebox in the NoData event of reports as follows:
Private Sub Report_NoData(Cancel As Integer)
   DoCmd.SetWarnings False
   MsgBox "No data returned.  Try changing dates."

I've created a database for tracking change requests at my work.  Each
change request is given a sequential number.  I attempted to create a report
which would allow easy viewing of the most important pieces of info regarding
each request.  Now, my supervisor wants a summary at ...

I have a "date serviced" field and i want to auto populate a "next
service date" field by adding 6 months or 12 months from the
original "date serviced".
I used a calculated "unbound" text control containing

I have a report that we use as our price quote for submitting to potential
customers.  There is a control on the report where the client's name is.  
Most project are quoted to just one company, however occasionally, we send
the quote to multiple potential clients.  For these ...

Hello~
I have a timesheet database that I use (created by a contractor my company
no longer uses) and there is one report that I can't open.  It's odd, because
I can open every other report.  I am running XP with Access 2002.  Access

I have a form with an option box that is generating the sort order for
a report. The code is below.
=Choose(Forms!TaskTracker2!sortby,
[bug_id],[project_name],[priority_name],[status_name],[emp_name])

I created a yes/no box in my table(It will work in the table) and then I put
it into my form and when I go to check it it does not work. Am I doing
something wrong?

I've created a database for tracking change requests at my work.  Each
change request is given a sequential number.  I attempted to create a report
which would allow easy viewing of the most important pieces of info regarding
each request.  Now, my supervisor wants a summary at ...

I have been having a lot of trouble trying to create a grand total on a
report.  My Report looks like this..........
date     Quantity     ProductName     ProductPrice    
=([Quantity]*[ProductPrice])

Does anyone know how to make a text box visible only when a report is
displayed and not visible (or filled with jibberish like all "X"'s) when
printed?  I tried using the format and print event on the report detail;
however, that made the field and the corresponding label ...

Trying to create reports in Access using report creation wizard. I am getting
an unable to create report error.
It is a permission problem. Logged on as administrator no problem Log on as
anything else, get the error.

i am a relative newbie to this so you'll have to excuse this if the answer is
totally obviouso, but how do you programatically restrict the output to just
those records meeting your 'where' specifications. i am not seeing a place
when i write the output command below to insert my ...

Say I have a table with  two fields named "Market" and "Amount", and there
are a number of entries in the table, is there a way to create a report that
will dynamically list the individual Market's and Amounts horizontally?
For instance...table looks like

Need help with formatting the DSUM date criteria. The following code is in
the Report Footer.  
Set rs = CurrentDb.OpenRecordset("Select * From [TestCreditDebits]",
dbOpenDynaset)

Hi again,
I would like to know if it is possible to set the proper pape size
programmatically, meaning I have a report that sometime will need to be
print on 8.5 x 11 (hiden section) and some other time on 8.5 x 14 ( full