I have a report that shows detail only from a head of household query. The
report also has a subreport that lists the related records (family members)
from another query. I need the detail section of the main report to count the
records that are displayed in the subreport. I ...

I have created a crosstab report where when you do a print preview Access
only shows the first page and doesn't activate the navigation buttons at
the bottom of the print preview window so you can navigate to the rest of
the pages. If you open and close the Page Setup dialog then ...

I have a report which is based on years of students in the college. There
will always only be 2 years in the report because its a 2 year college. The
lower class is called A1 and the 2nd class is called A2.
Now it is grouped by student year (ie. in which year they began the

How can I change the printer page layout to landscape via code? Basically I
would like to avoid having the user set the layout every time manually.
Thanks
Regards

I'm a newbie to access. Have a contacts db. In table for contacts include 2
BD fields - one mm/dd/yyyy, one mmmm/dd (don't know years for all contacts &
don't need to know age for most contacts). In all records where mm/dd/yyyy is
known, have included mmmm/dd in the second field ...

I need to get the recordsource property value (or even the SQL string itself
if possible) for any given report. I have tried all day and cannt figure it
out.
For what its worth, I have a custom report db that doesnt need to be linked

I have an application wherein I need to force a
blank page, sometimes at the beginning of the
report and sometimes at the end. How do I
do that?

I have created a form which generates an invoice number. I have also created
an invoice (report) which is based on the values in this form. The report is
based on a query which prompts for invoice number. Thus when the user prints
the invoice based on the data in the current ...

I have an application which is a .mde front end / .mdb back end.  Depending
on certain circumstances a page break needs to be added or removed from
within a particular report.
I used the DeleteReportControl and CreateReportControl to do this. While

Am making a report from a table.  I want each record in the report to print
out on a 3x5 index card.  I don't want to use a full sheet of anything and
then have to separate.  I just want each record to print on a 3x5 index card.

I think I've read every post here regarding Access reports to PDF, but I
can't solve my problem.
I have code that works fine to create a PDF file from a report using a
unique name that becomes the PDF filename. What I need is an automated

I need help in getting my report to count yes/no fields from my query. I need
the count to ignore the no or nulls and count only the yes. I have created an
unbound text box in the report footer with the follwing expression -
=Count([PassFail]) Is Not Null Or Not False - Where the ...

I have created a database and am running into a few problems which I
thought someone out there can help me with. Here is the situation:
User logs on to my Intranet and clicks the link to open up the System
Request Change database. Opening the database will bring them to the

Hello, I have a access mde that I have 100+ users using as a front-end.  I
want to deploy some of my access reports as pdf.  For example, let's say I
have a Invoice screen with two buttons, one says Print and the other says
PDF.  The print button will print the Access Invoice report ...

I need to use a Organization name in the data base for a page header.