This question involves the following:
Tables: Print_Shipments_by_Date, UPS_SHIPPING_EB (linked)
Forms: Print_Shipments_by_Date, UPSshippingEB
Reports: Print_Shipments_by_Date

Thanks in advance for any help. Surely I'm not the only one who has ever
wanted to do this.....
I have three tables like this:
Table 1

I wish to place a button in my form which will load a pre-defined report for
THAT RECORD ONLY. A the moment the reports I produce using the wizard
generates all the records.
I am sure this is simply- what am I missing please?

I am using access 97. Is there a way to get number of report instead of
manually count it one by one? Thanks.

I want to prepare a report which has name of members in short form
for example: Johannes Muda Hutauruk  from First, Middle and Last Name. I
want to make a calculated field in the query to have it shown on the report:
like this : J. M. Hutauruk,

I am using access 97. Is there a way to get number of report instead of
manually count it one by one? Thanks.

I've come across a client with a non-normalized table with sales of items
for eight different regions. So, the fields in the table are:
ItemCode
Region1SalesQty

MY REPORT IN ACCESS 20007 RUNS AND IS VISIBLE ON SCREEN. WHEN I TRY TO PRINT
THE REPORT I GET "THE EXPRESSION ON FORMAT AT EVENT PROPERTY PRODUCED AN
ERROR "DIVISION BY ZERO".  BUT I AM NOT DIVIDING ANYWHERE IN THE REPORT.  
WHEN YOU ASK FOR FURTHER DETAIL ON THE ERROR IT SAYS THE ...

I've tried this before but never got it right. I'm wondering if anyone out
there could help me out?
I've got two combo boxes:
cbFacilityID

I have created a report with several columns. I need to enter an extra
collumn to the report, but that is causing the report to exeding the size
limit. (is this correct english?? I dutch so I have an excuse ;-))
Some collumns have text in it. And the text knows only 2 vallues. Is ...

Ok, So, what I have done is create a set of tables that hold data
about terms and their definitions. Each term (except the root term)
have a parent. There are 5 tables: Root, Grandparents, Parents,
Children and Grandchildren. The children of grandparents are stored in

I am creating a database for complaints.  I have a main table for Complaints,
and a joined table for Illness Details.  Part of Illness details are
symptoms, and a person can have many symptoms.  I created a separate table
for Symptoms, linking it with the Illness Detail ID.  When ...

My project is in MS Access 2002.
In that I want to open one form multiple times.
I put one button on my main form.
Now whenever I click on that button than form will be open.

I set color in my Detail_Format event which works.
It does not carry when I send out email  docmd.sentObject via MS Word.
The color does not change when I receive the email report.
Are there any place ned configure at MS Word to carrry Report format from

I have main table with a Ref field as primary. This Ref field is related to
another Ref filed in a second table.
I have a report that is based on a query that contains that primary key. I
want the report order to be on a filed other than the primary key. When I