We are running Office XP.  There is a requirement to print vastly more data
than can be from a memo field, and they would like functions that are in
word like numbering, tabs, and so forth. Is there a way to place a field in
each record that may or may not link to a word document, ...

I want to add static text in a report thats static to the report

I have a bound control and a lable in the page header section.  The lable
has typical page header stuff like the name of the table and page numbering.  
All is well until the report footer, which is a lengthy subreport, where I
don't want the bound control showing up.  Is there a ...

This will be really easy but its driving me mad !
When i insert a page break into a report it looks fine on the design version
- but when I print the report it adds a blank page where I have inserted the
page break. I don't want a blank page I just want that page to end and the

Hi Again,
       (I decided I should rephrase my subject)
        I have a report with two subreports in it's detail section.
        These each report on sales in their areas.  I have a textbox in

I'm trying to calculate for a report the previous year to date value of a
control I'm using this:
=DLookUp("[Sum of
txtDomfactot]","qryFDASalesV2","Year([txtmonthlabel])=Year([txtprevyr])")

Our application runs on Access xp. One of our customers reported a random
"out of stack" error while previewing some reports (docmd.openReport...)
The error causes Microsoft Access to crash (the user has to kill the process
via the task manager).

I have a designed a database for a contractor.  I have a form to enter
quote information to specify the scope of work.  I have a quotes table
with the fields: estimateID, quoteID, Alternative A, Price A,
ALternative B, Price B and Alternative C, Price C. On the form I have

Using Access 2003 (on an Access 2000 format db).  Am attempting to use the
OutputTo action (via macro) to save reports to Rich Text Format (.rtf).  I
need to be able to send the saved .rtf file so that the recipient can edit
and send back.

I have a report that is modified through the use of a form. After the user
makes his selections on the form the saved report is modified and presented
to the user to preview.
After the user closes the report I DO NOT want him to save the modified

Hopefully someone can help me out as I've been scratching my head on
this one and can't figure it out.
I'm putting together a report that will contain line numbers.
I've implemented the suggestions located at

Anytime I try to create a report (using the design view or report wizard) I
get the following error message.
"There was a problem retrieveing printer info. for this object.  The object
may have been sent to a printer that is unavailable."

Hello i would like to get a sum for a few different
fields for the non-for-profit organization i am doing a
database for.  I have syntax like this:
=sum([field1]+[field2]+[field3]) (etc...) but i keep

I generate reports based on a date field and those dates either 6 months or
12 months prior to todays month.  The filter works fine the last 6 months of
the year but now in January month(Now())-6) returns nothing.  What do I need
to do?

I posted a question days ago regarding my desire to have some of the contents
of a text box in bold and other parts not bold.  Marshall Barton was kind
enough to direct me to www.lebans.com (a wealth of goodies for anyone saavy
enough to know how to implement them).