I have a report where if an option box value is 1 then it prints the footer
(which is two pages long) otherwise it does not print the footer.  My problem
is that when it does not print the footer, I get a blank page.  This has
nothing to do with margins or page breaks (there is ...

I am trying to display horizontally, results from a query in a report. The
problem is that the results are from a table that has a field labled Category
Types. There are 10 category types. I am trying to display the results for
these category types horizontally, not vertically, ...

I am creating a report and want to count the number of
records in the report.  The data for the report is coming
from a parameter query.  I have tried putting =count(*),
under control source, in a new field but keep getting an

I have small database and I using OLE objects in tables because my text is
more than 255 symbols (using excell spreadsheet). The problem is when I am
making the report there is only ??????????? symbols instead of my text, which
is typed in my native language (Georgian Unicode)

In Access 2000, is it possible to link a subreport to its parent based on a 2
or 3 column combination? I've only ever done it with one column (usually a
PK). This time, the primary key sequence is actually like 5 columns -
however, I'd need at most 3.

I have couples attending an adoption seminar.  They complete an intake form
creating their "parent profile" and what they want in an adoption experience.
We want to have predetermined suggestions of where they will succeed based
on yes/no answers to topics such as:  Couple under ...

I made a Line Chart report using the Chart Wizard.
In the Y axis (Data) I have [Quantity] by sum.
In the X axis (Axis)I have [Date] by month.
In the Series box I have [Date] by year.

I've been tasked with exporting an Access 2003 report to Word. I've
tried this using SendObject to RTF but it seems a bit flaky. Searching
on this seems to reinforce the opinion that RTF is not going to work.
For various reasons I cannot use the Snapshot or PDF alternatives so I

I have difficulty to make a vertical line (columnar line).
If the page is full, I have the vertical from the top
until the page footer. But if the record is not full page,
the line discontinued.

With reference to your recent ad in the local paper for a
Software Programmer, described on page C7 of the Careers
Section in the March 7, 2005. I would be of an asset to
your company with my experience and knowlege in Software

I want the user to be able to open up a report that can only be printed with
information from a form.  When I open the report I get the box that want the
record ID.  I am assuming on the cmd button I have to add some sore of
criteria to get rid of the error.  How do I do that?

I have a text field in my report. Some of the words are cut off and didn't
show up. I checked my query and can see the whole sentence there. I set the
can grow property to Yes and no use. I need help about it.

I am attempting to add lookup fields to my report.  The report is based on
a query and the fields that I would like to include in my report are in a
seperate but similar query.  The two combined will not return the desired
results.  What expression should I use to retrieve the ...

I have some textbox on my report with data that it's size is dinamic: number
of lines, font size, ect...
For this i set the CanGrow property to true.
It always shows me all the data inside the textbox. Exept when the texbox is

It seems I can't get any reference to any of the controls of a group header
section. The code hangs on i=0
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Dim i As Integer