Our VB6 app makes use of an Access database report object that contains a
small amount of code.  We are currently preparing an update exe for this app
where one of the updates is a change to the code in the Access report.
Since the user may have changed the design of the report, we ...

I have a report that I want to pass to parameters on.
SELECT Responses.[Name of Business], Responses.[Main Category], *
FROM Responses
WHERE (((Responses.[Name of Business])=[Forms]![Main Reports].[BN]) AND

Is it possible to have the totals in a report to automatically populate into
an Excel cell?  I have a report that has 2 totals that I need to auto-
populate into an excel form.  
Thanks!

I have a report that potentially could hold up to 12 pages of material,
however as the details are filled in on the form, for the fields that
do not have a vaule contained in them, I do not want anything to print,
but I also want the next section to butt up to the current section, ...

With the data fields of Id, Date, and a Text field for "AM"
or "PM", I'd like to have my report display a heading for
the month, and under that, two side-by-side columns, one
with a header for "AM", and one with a header for "PM",

I'm having a problem when I export reports with hyperlinks to text files
(Access 2002, Office XP). The hyperlinks are very long, and they are broken
by line breaks in the text files. Any ideas on how i could prevent this from
happening?

This ought to be simple, but I'm going round in circles...
I have designed a report to use as an Invoice.  It has report
header/pageheader/detail/pagefooter/reportfooter.
If the invoice takes up more than one page, I want:

Hi I'm Jean and well I making a database project. I have the following
issue:
I want to print a record entering a  "Asset Number" filed (This field
is the PRIMARY KEY) in a input box and then print the entered record in

I'm trying to build a series of reports for a property tracking database
that I am building that will list information about the property and the
real estate agent that did the listing or made the sale.
My problem is that I need the column headers to remain in place even if

is it possible to change the subreports' source object depending on certain
criteria? I have 32 subreports and instead of making 32 main report I only
want to have 1 main report.  This would make future re-formating of the main
report easier.

Hi, new here so HI!
I have a sub-report that is used by several master reports. I would
like to hide (.visible = False) one of the text controls on the
sub-report depending on which master report is running it. Has anyone

Background info: I have one front end db. I have 3 separate back ends that I
can link to. All 3 back ends are similar in structure and content. The
difference is BE#1 contains data for 10 products, BE#2 contains data for 21
products, BE#3 contains data for 32 products. I can't ...

Does MS Access 2003 have the means to maintain graphic integrity whenever a
report is exported  to MS Word 2003?
I would like the lines to remain intact; however, when exported to Word, the
lines disappear.  Perhaps there is a hird-party software that can facilitate

I want to use the Round() function to format some data for a report.  How
can I do this in such a way that numbers ALWAYS have one digit to the right
of the decimal place for example:
1.0

I have inserted a bitmap into a report header, via Insert, Picture then
selected the picture from the file system. It shows up properly in design
view and print preview but nothing appears on the page when I print the
report.