I'm kinda lost and need some help.
I have a form with a button: On click it opens a report (based on
DoCmd.OpenReport "testReport", acPreview)
The report should grab the data from a table "test" (2 columns - "date" and

I have a report that prints a list of members and one of the fields is a
yes/no field for those below the age of 18. I have already created the
sorting by those below 18 but what I want to do is to force a page break the
moment it hits the first record of below 18 but I ended up ...

I was told that there is a way to make mailing labels with the data taken
from a table in access. Is this true and if so can someone point me in the
right direction?
(I have a list of a few hundred customers and i wish to send a package to

Can someone please tell be how to print a report that only prints
predefine number of records on each page
--
mashyp

I am trying to create a directory for a large company via an Access report.  
Most of the information for the directory is stored in a database.  However,
there are some items that are not stored in the database (i.e., listing of
conference rooms and their phone extensions, phone ...

I have a set of 5 Report objects that all pull from the same Query.  The
Query possesses 12 fields where 10 of them are split among the five reports
(two fields per report).
I have a parameter in the Query to prompt the user.

Hey newbie here - I have done a basic report and it looks good.  
The only problem I have is that ALL the records are printing on my report.  
I want all records to print except for the records that have the Status of
"Closed".

I have a report with some numeric values listed, but I need to make a sum of
them all and display it at the end.
How can I do that?
Thanks in advance.

I have a db for a Personal Injury Law Firm.  I have a seperate table for
each type of case-Auto Accident, Medical Malpractice, Slip & Fall Etc.
Each table has a calculated field to record the Statute of Limitations for
that case-(Date of accident plus the statutary time period to ...

I have a field with this lookup:
SELECT tblUOMLength.txtUOMLength, tblUOMLength.Description
FROM tblUOMLength;
It's bound to Column 2 and displays values like this:

My new Dell 1700 laser will not print the top .25 and bottom .19 inch.
My question is what is normal for other brands of lasers?
I have some 5 up pre-printed cards that need to be filled and they have no
top border.

i'm sorry for my english i' from Italy.
i see this link http://www.lebans.com/justidirect.htm in a italian newsgroup
for access ( it.comp.appl.access).
The routine is good for my db (Access 2002, O.S. Windows 98), but when i

I have just written a VBA script (below) that successfully prints a single
record to pre-defined report, then uses SendObject to load it onto an E-mail
(and inserts the E-mail address, etc ). Not bad for a newbie.
But the report has some formatting that makes it difficult to use ...

I am stuck on how to make one record appear with all its associated sub
records. What I am doing is almost identical to a scenario where you have a
customer in a video shop, and the report you want to generate is one that
shows some customer details, and along with that it shows ...

I have a report formatted as a "booklet."  The cover is the result of the
report header section being made just big enough to completely fill the
first page.
After that, the data prints.