Hi i have some trouble printing reports based on condition. (Access
2003)
I have report being printed (2 sided print out). This reportd has a
groupheader0 which is grouping by counties. I would like to program it

I have a report that I have been emailing help on with you guys. Everyone has
been such a great help.  My report is a 12 month rolling report, which is
based off of a crosstab query. I need a field called count. This will count
what months have data in them. So for example:

I have two forms "client" and "employee details"  I want to put a hyperlink
on the client form that will open up the employee details.  the relationship
is as such. one to many client to employee details.
client; ID, employee ID

Are there any downsides to putting a subform (which exists already for other
reasons) onto a report using the subreport feature?

Is it possible to make a whole sub-report shrink and grow?   (The vertical
attribute available for regular controls).

I maybe doing this all wrong but what I want to do is have users enter data
in a form. Once done entering the data then they would click on a button to
open a report w/ only the data they entered. For example say they entered
data about a sale made the report would then be a ...

Hi Peole, im having some trouble getting my access database to email the pdf
thats being created. Ive managed to get the report automatically emailed as
a HTMl file but would really love to get the PDF conversion working and as
such have tried changing the "docmd.sendobject" I ...

I just downloaded Leban's ReporttoPDF function for auto PDF printing.
I'm experiencing a problem with embedded bitmap images in the PDF
output.  I receive "an error exists on this page" and sometimes
"invalid image", and the bitmap images are either blacked out or only

I'm creating a report where I want to count 2 things:  Number of Unique
Clients and Total Number Of Enrollments.  A client can have multiple
enrollments.  
I can do the counting of total number of enrollments but I can't seem to get

Hello.  I have a wonderful project to complete.  I am trying to maximize my
efforts by combining several reports into 1.  To do this I need to set
objects on my report... ie text boxes and images to display based on a value
on a record.  I have two types of records... typeA and ...

i set the print margins, which are different for all my reports, through the
page setup in print preview. then i save the reports. when i exit the
database and reopen it the options i have saved are not working properly. for
certain reports i have to reset the print margins. why ...

My SQL Code is as follows:
SELECT tblBillSeats.BankName, tblBillSeats.BPseats, tblBillSeats.Pamt,
tblBillSeats.BTseats, tblBillSeats.Tamt, tblBillSeats.BType
FROM tblBanks INNER JOIN tblBillSeats ON tblBanks.BankName =

I understand how to align text, left, right, centred
I want to be able to centre text in a control horizontally (up or down)
as is the case when using a text box in MS Word
Can this be done please, thanks

Using a macro I can generate and export files in pdf format. Then I have to
create an email, attach the report and send. Is there a way to email a report
in pdf format directly from Access utilizing a macro?

I have a subreport in my main report.  The report is in a footer that is
called RT Footer.  In the RT Header of my main report, I have the following
in a text box: =Reports!rptCOMMISSION_REPORT.rptCREDIT.Report!tEXT28.  This
textbox is supposed to give me the total for the linked ...