How can I print a title on a report from a command button on my form?  I
have a couple command buttons on my form and depending on which one the
user click on the appropriate report title will show.  For example:
Command button: cmdBlkBelts would show "Black Belts" on the report as ...

I have added a field to an existing table that is a yes/no field that has
3000 records.  all of the records for now should be checked in (yes).  I know
I can set the default to yes for new records and that you can use ctrl ' to
repeat what is in the field for the previous record. ...

I have made a report and i have grouping by Lesson. But I want any Lesson
appear in different page. How Can I do that?
Thanks for your time.

Well, here's my problem.
I just got a new computer, which came with acess.  The program appeared to
be working fine.  I went to create a report, and went through the whole
process with the wizard, and then when I finished the last step and all it

I'm new to Access and wanted to ask about its master-
detail reporting capability.
I have a master table and two detail tables.
Ideally, all master records would be in a grid, and you

Hi, there,
I need to report on the Amount due and Payment details by Invoice number.  
The Invoice number and amount due is maintained in one table while the
Payment details are stored in another table.   The common link is the invoice

I have an unbound text box on a report that shows the date from data typed in
an unbound text box on the form (menu) from which the report is opened.  The
info from this text box on the menu is also used in some underlying queries
and effects the data on several reports incuding ...

I have about 6 headers in my report.  How can I hide a header if there's no
result for that particular header?
Any help is very muchappreciated. Thanks.

I want to print a report only if it fits on one page. If it has more
than one page, I want to display a msgbox and cancel the printing of
the report.
My plan was to make a report footer and a page footer in the report; if

Does anyone know a way to calculate and print the results of a t-test
(statistical comparison of two groups), within an Access Report?
thanks,
 L.

We want to create an Input Mask for a telephone number that has a prefix
already populated.
Eg (07) 1234-5678
The use of "0" is a problem here as the wizard assumes it to be null.

I am currently using A97, but am likely to upgrade to A2003 soon.
I need to email batches of reports (~ 5-10 reports to a batch) to various
recipients, who will have various versions of Office - from no version at
all, to Office Pro2003.

I have a standard form letter that I would like to put in a report (not sure
how) that when the user selects this report it will prompt them for the
customer name and the user will select "Acme Inc." and the standard letter
form will print out with Acme Inc.'s, address, city, ...

Hi. I'm trying to create a report that essentially has 4
columns (there's no data in the columns, I just want the
lines for people to write on the report).  This is an
auction form where people up the bid and leave their

There seems to be a disconnect between my default Windows XP printer and my
default Access 2003 printer.  I cannot seem to keep Access2003 from looking
for a network printer that is not my default printer instead of my local
default printer.  Even when I go in and manually change ...