I have a beautiful report in Access preview, and even in Snapshot... but the
header is missing when I send it to Word. What's going on?

Why is the following statement working properly with Access 2003 11.6355.6360
sp1 and below, and Access 2002 SP1 BUT NOT in 2003 11.6355.6408 SP1 and 2002
SP2-3?
=Trim([fieldname])

I have a report that shows two year's data, and I want to calculate the
change in the group footer. The group is by product, then there are two
detail records for each product, one for last year and one for this year, and
I want the group footer to show the change.  I'm not sure ...

I am trying to deploy the snapshot viewer to about 500 of
our employees so that they can view reports generated out
of Access. My trouble is that some of them are being
prompted to get their Office CD and most of them don't

I get an OnReport runtime error...unable to trap it because none of the
events in the report are called (open, init, error...) nor the error
handling in the procedure...when this runtime error is thrown.  We actually
take a report, copy it so that it can be renamed, then docmd ...

The report that I am designing hangs when I change the Group Header property on Repeat Section to Yes from No. When I hit Print Preview icon the bottom left corner displays the message "Formatting page, press Ctrl+Break to stop".  I end up doing this hard break because it just ...

Access 2000
I know there is a bug in Access 2000 where report page
setup changes back to the default settings, but I can't
remember how to stop it from happening.

Hi - I have a form that is set to pop-up, so it shows on top.
On this pop-up form you can click on a button and show a report
that is not set to pop-up. So the report shows up behind this form.
I have it set this way for a variety of reasons that will take a while

I have designed a contribution report for our newsletter that will sort on
type of contribution fund, type of contribution (such as in memory of) and
who the contribution was made to (such as Joe Smith's marriage).  This is
where the problem begins if only 1 person makes a ...

I have a field in a report that gives an average of an employees adherence
for the month.  I'm trying to create another field that gives the percentage
of the employees that meet goal based off that field.  Every time I run the
report I get a pop-up screen asking me to enter the ...

Is there a way (programaticlly or otherwise) to center text vertically
in a textbox on a report?
I need the text box to be quite large for companies who have long names,
but would like to have everything centered to the very center of the

Is it possible to color code fields in a report

I have a report that shows a list of workers in one column, and hrs worked
in the second column.
At the bottom of the report (in the report footer) is a sum of all the hrs
worked.

How do I get access to print a horizontal line after each record on a page
(kind of like a notebook with text on it).
Like this:
---------------------------------------------------------

I have a report that needs to run montly.  The user would like to save each
month's report under a different file name (ie. run report in January, save
"ReportJan"; re-run report in February, save "ReportFeb").  Is there a way
do this?