I have a form and a report that are almost identical. I want to create a
button on the form to allow me to print the report. So say I'm on recordID 15
when I print the report, the report should just have recordID 15's
information.  How would I go about setting the criteria for ...

I hope you can help me with this one as our db admin person has left. I have
a SQL backend with a ADP frontend. Within the frontend i have set up a combo
box that contains a list of all the access reports you can run, and another
combo that contains criteria for those reports. ...

I have a report that takes an argument "OrderId". When the user opens it from
the access client file, he is prompted for it. That's ok
When I open it from my C# program with the DoCmd.OpenReport command, I can
already know the OrderId. I want to pass it as an argument.

I have a report that has a Group Header, but no page or report header.
However when I print preview the report the first page only has the group
header, the detail is on the second page and fills about 2/3rds of the page.
How do I get the detail on the same page as the header?

I copied the following code that was posted last year.
This is a difficult situation.  I can only come up with one
way to get that effect and it requires that the detail
section has its KeepTogether property set to Yes.  You can

Hi, I want to print terms and conditions on every alternate page.
An aggreement report consists of the client details and items that comprise
the aggreement. A subreport displays the terms and conditions for the
selected aggreement.

Hi, is there any way in a Report to customize the date displayed in the
report to be mmm/yy?  Or even mmm/yyyy would be better for me than the
options Access seems to  offer in their reports.
All I see there is Short Date, Medium Date, Long date - they all take up so

I have a DB that has started being used by many different departments of the
company I work in.  User input has shown that almost every area that looks at
the gathered information would like to be able to sort by 2 different fields.
1. Item/Part # - want to be able to sort by a ...

I have a subreport which contains headers.  How do I have the subreport
headers show up when placed in the main report?

Would someone show me how to center vertically the text on label please?
I open the NAME’s property box and set the "Text Align" property
to "center", but the name centered horizontally, not vertically.
Thanks

I have several reports based on simple select or select w/WHERE queries.  
Can anyone tell me how to add a count of the records on the report:
Example:
Select col1, col2, col3, Employment_status

In my report, I cannot have more than 99 records in a group.  I have set up a
counter but I can figure out how to force a new group and page once the
counter hits 99.  Addtionally, I must label each group differently.  The
first group is "A" then "B"... through "Z" and then "AA". ...

Hey guys,
I have one report with a set of data like id,id2, text,text, price
(cca. 100 rows, 4 pages). Now I would like to add to that same report
an another set of data like text, text (cca. 200 rows, 8 pages). How

Following on from my recent "RecordCount" thread ...
I have an unbound report which contains two subreports.  I've used the
method suggested by Al to count the records in the subs but I want the main
report to close if both subs are empty.  I've successfully trapped error 440

Hello,
A couple of days ago I posted a similar question, but I will try to include
some more details this time.  If I need more detail to clarify what I need,
please let me know.