I have a report with many clients and their expenses of the month, but some
of them have 2 or 3 pages of expenses, what im trying to do is this:
Page 1
Page Footer

I have need to send a report via email to a recipient who in turn needs to
enter information into 4 fields.  Is there a way to protect the report so
that ONLY those 4 fields can be changed?
I tried emailing a form, and I lose the format.  Should I try to email a

I have a report which contains the status of all the student activities.  
The information in the report comes from a table.  
The report is grouped by the type of student group.  In the report, I have
total of 5 columns for different types of activities.  If a student in a

Is it possible to do this with Access 2000?  I will need to add to my report
at a later date, and my client will want to change the criteria.
Joan

       From a word macro in VBA, I am trying to create a report in
access DB. The report is based on a query with a parameter.  I am using
Set rpt = Application.CreateReport
rpt.RecordSource = <<Query_Name>>

I have a nested report of the form:-
   Region
         Location
                Report

I'm trying to set the ControlSource for an unbound control on a report
and I'm having trouble with the syntax.  If I use
Me.Budget.ControlSource = "Budget"
this works, but what I actually want is to add 2 numbers together,

....In my Membership Database, is there a way to print
the date in "Red" if the date is over a certain year in my report....?
....like...
....if the date is <01/01/03...print red...?

Can anyone tell me how I can insert Spanish text (with diacritical marks) in
a printed document?
Thanks,
Gerry Goldberg

With the acsendreport, i cannot give an filtername or parameter.

I have a database full of individuals information, with the SS# as the
primary key.  Each individual may have several case notes, each case note is
a separate record associated with a particular SS#.  So there are several
case notes associated with one SS#.  I need to create a ...

How do I count the number of records in the detail section with VBA and refer
to the number in the detail footer section using VBA?

Hi Experts,
I hope the subject makes sense with what I need to accomplish. I'm calling a
report via an unbound form which sets the Condition(s) for the report.
Partial (end part) code is:

Someone asked yesterday about sub totaling each page in a report. While that
fix works to a degree for me, what I ultimately would like is just a sum on
the final page of my report. I have two fields I want summed: "Qty" and
"Cost." Qty is a field on the report; the "Cost" field ...

I am trying to put a border around my reports; here is the code that I found
in the news group help file.
Me.DrawWidth = 2
Me.Line (0, 0)-(Me.ScaleWidth, Me.ScaleHeight), B