I am using Access Data base for expenses and have created all my people and
have done forcast amounts.  Now when I want to go to a specific established
record I can't it state that "You cannot use find or replace now".  Help!

Hi all,
I have built a Report in Access 2003 that calculates quite a lot of fields,
two of which calculate and return text values "High" or "Low" as their answer.
Then there is another field "Classification" that, in turn, uses the above

In my detail section of a report with seven columns, I have a column with
field name Reward with "Yes" or "No" responses as part of the record. In the
Detail footer, how can I add a text box to count the "Yes" and another to
count the "No" responses? Like =count([reward]="yes") ...

Is there a maximum size of an access report?  It seems I have hit this limit
and it won't go any bigger.  This is while designing it, not when it is run.
Thanks,
Drew Laing

I have created a report - no problem.  However, I want it to "prompt" me for
which record I want it to print.  For example I could have over 1000 records
in the database and I only want "ABC Co." (record 32).
How can I do this?

In VB I'm trying to cancel a report that is in progress if we find an error.
So as an example, in the OPEN section we read a system file, etc. and
realize we have a problem that effects the printing of the report and we
need to terminate.  I've tried:

     I have report with Grouping, It has 4 level of groups
In Every group section there is one line object.
I want report not to show line of the particual group section if there is no
data for group.

I am using Access97, and I want the ability to export various reports to
excel, via a macro. When I do this the formatting of the report is often
messed up - especially the column headers: extra column headers are
frequently added to the left of what should be the first column - ...

My Access report contains some characters from an extended characterset
(In Office subset: "Miscellaneous Dingbats" from "Notmal text")
These are WHITE  CIRCLE and BLACK CIRCLE.
All characters are formatted with Arial.

I'm trying to get a simple line chart going in a report.
The problem I'm having is Access's insistence of using the Transform/Pivot
functionality on the dataset I'm pulling from.
I don't want/need this. I want x-axis to be description, y-axis to be avg,

Hello:  I am creating a simple report that shows me:
- Order ID
- Order Date
- Order Amount  (This is a calculated field consisting of

I would like to change the field content before to print the detail part of
my print out.
I have two fields. The first one must be complete with the content of the
second one when printing (or previewing).

this is my code (in open) to set my report's recordsource (mysql is the
having clause.. this is there because i have a form that has a listbox that
the user has filter options for... the listbox are there results and then
they can print their results on this report)... everything ...

I am building a database to manage a fleet of transport
vehicles. I have among others these tables
tblVehicles (LicensePlate, AcqDate, HorsePower, MotorType)
tblRevenue (IDRevenue, DateRev, AmountRev, VehicleRev,

In a report's close event, I want to test to see whether it was opened in
acViewNormal or acViewPrint.
Surely there's a way to do that, right?
TIA,