I have added the following to my report: (Note: I have a parameter set in my
query for data to display between two dates)
 I added 2 text boxs to my report header (1 for the start date and 1 for
the end date):

I'm trying to do the above in code.
I've tried this:
Me.RecordSource = Forms!frmOR.RecordSource
in the report's open event but I get parameter values popping up so it isn't

I am trying to print a report using two different critera.  This is what I
have but something is wrong:
I am sure it has something to do with the quotes....
stLinkCriteria = "[ProjectID] = " & PreviewProject & And &"[WorkOrder#] =" _

My report has a text box with "=Count(1)" to produce a count at the end of
each sort in the detail.
The detail is sorted Three ways: County, Member then Doctor. But some
members have more than one doctor ( member #123 has 2 doctors, member #999

In a database for parking garage leases, I have the following:
1. In combo box LOCATION - drop down choices "Garage A" and "Garage B"
2. In combo box ACCESS - drop down choices "24/7," "Night/Weekend,"
"Pool-24/7" and "Pool-Night/Weekend"

How do i put out a message box that say "Your file has been printed" after
the file has been send to the printer for printing?

I've recently moved up to 2007. I'm using a report, I always used in 2003 to
print #10 envelopes. I'm getting an extra page between every addressed
envelope. In 2003, you'd just shorten width until the extra page went away.
I've not been successful with 2007. Anyone have any ...

I was wondering if anyone might be able to help me out with the following
problem i have.
In the Access report, i have a textbox whose control source has the
following value in it.

I have two tables, products and customers...
From first I call data in form (products), and from second in subform (who
buy some product).
I have query in report, product have ID and customers in subform IOI ID.

I've read th
I have a subreport (sub 1) that has several page break controls.  My master
report (mast 1) contains a few controls to create a table of contents for
(sub 1) and a sub report control that contains (sub 1).  If (sub 1) is run

I am using Access XP.  I have this re-occurring problem regarding alignment
of numbers in reports.
For numbers, I always overwrite the existing format and replace it with
something like the following:     $#,###.00;($#,###.00);-;-

I have a report which shows data, one sheet per school, for secondary
schools. On each school's sheet I need to list the feeder primary school(s).
At the moment, when there is more than one feeder primary school, the report
is creating one duplicate sheet per secondary school, ...

I asked this question, but it was about two weeks ago, and I only just had
time to adjust the db to test it out!
I was trying to get a report to generate based on the current record viewed
in a form.  I have subforms going, but I was able to address that by simply

I want to print multiple reports from a table, it can be 0 Reports or 5,
10 or whatever.  The table includes...
Report Number    Report Name
1        rptCashOut

How do I start a new page number at each group?
For example, I have 5 offices - SF, LA, VA, NJ, NY.
For SF, I want to show 1 of 10.  Then when it gets to LA, I want to show 1
of 20.