How do I print the current record from a form where the table has multiple
fields for a primary key???
I was able to print current records from a form where the table has only 1
field as a primary key with the following...

Do the text boxes in the detail section of a report comprise a collection of
some sort that I can roll through with a For...In statement? I would like to
change the text boxes in the detail section of a report to bold under a
certain condition. For example if a line's balance due ...

I have a report based on a query that looks for invalid items for one
particular store; if the query does not return records I would like to show
in the report header the store no., city, etc.
How do I do that?

Please help, I have a message box for an OnClick Event for a button:
RetValue = MsgBox("Are Details Complete?", vbOKCancel)
How ever, whether the user ticks Ok or Cancel the button still runs the
query. Any idea on the If statement that I'm missing?

When I use the label wizard, anytime I put more that one field on the same
line, the labels come out as #error
example; Mr & Mrs  - Jones
             1234 Oak Street

I created an Access 2002 report and gave users the option of either
printing it directly or viewing it in Print Preview.  That's because
the report is too long to print very often.  It contains calculated
fields,group totals, and overall totals, the sort that can be gotten

I'm trying to create a simple report with report with one subtotal per
group, and (possibly) a grand total at the end of the report.  I have
five fields in the table; date, payee, amount, memo and acct.  The data
is ordered on "acct + date" and is grouped on "acct".   The report ...

I have a report with several grouping fields.  
I want to know how to count the number of subgroups in a group (rather than
the number of records in a subgroup).
Thank you!

I would like to print page no. in a reports
generated thru' using Access reports.
How to do it? Is it possible to print
something like page 1 of 15, 2 of 15, etc.

I am using concatenated string fields to input information into a control on
a report.  I also need to be able to enter one additional line within the
control on the form that will contain a notation which should be formatted as
bold.  Is there any way to format only a word or ...

I am trying to create a hanging
    paragraph in a report, like
    this, where the first line goes
    to left margin, and rest of text

I was wondering if anyone could give me any insight on setting up a report to
figure a running total for an employee's schedule.
Currently I have a table named tblSchedule where all employees schedules are
entered in.  Whatever the employee's schedule is, is what they will work

I'm using Access 97. On option group on the data entry form offers 3 choices,
stored in the table as 1, 2 or 3. I want the resulting report to display "A"
if 1, "B" if 2, nothing if 3. The calculated control on the report shows the
Control Source as:

I have a customer database and need to pull two reports. One for active
customers only and one for all customers. How do I achieve this? I am verry
new to access.

I am having trouble passing a filter to a report using a form that contains 5
combo boxes. I have found that the apply filter event results in Acccess
asking for parameter values, even though I have passed the value through the
combo boc. Report filter is set to Yes, paths and ...