How can I automate the export of a report to EXCEL.  I am now using the the
File|Export option to do this but I would like to be able to eliminate this
manual step.  I an sumewhat familiar with VBA.
any help appreciated

I have an access database that has recently been upsized to sql 2005 - adp
front end and sql 2005 backend. I have several reports that are set up as
hyperlinks that require a field value as a parameter. When I click on the
hyperlink i get the "Enter Parameter Value' dialogue box. ...

I'm having difficulty getting this to work even though I thought it would
be straightforward.
I have a table in a database that is used for storing weekly inventory
counts of some supplies we use.  The table has a field for the date the

I got stuck - please help.
I have a repport need to pull out sum of 5 columns then take top 3 value 5
of these column, filed is YES/NO, ex:
Col1  Col2  Col3  Col4  Col5

I have a report, which if a query does not return any data, I then need to
write some text on to a report, is it possible to access report fields?
Kind Regards
Ricky

I have a report that I use unbound controls to total groups on.  There
are four groups of products on the report but it's not sorted  by the
group so I can't total normally.  I used control sources like this
----------

Hello! I am building a report based off of a query that only uses three
fields, a create time a user id and an incident number. I created a
report that will display these based on grouping by month on the create
time field. Using the =[RecordCount] through the control source field,

I am unable to remove a line from my report.  The line extends beyond the
width of the page and I would like to shrink the width down to fit on one
page, but I can't see the line in the design view to delete it.  Could it
part of the Header Format?

i am trying to print a report "sales report", it has customer first names,
last names, address..., some customer has short names, some has long names,
could i set a code for these text fields automatic fit, so i won't have to
adjust the field lengh all the time, thank you.

Please help me...a newbie here....
I having been working two days on a project, thought I was almost done until
I tried to create a report using a query I had succesfully made. I get an
error about too many fields.

I have a report that I am running from a query. The time in the tables is
just a general number, since most of the time the time is entered as '15',
'30', all depending on the length of time. When I run the report, I need it
to calculate the time for me. So if the total is 150, ...

Can anybody show mesample code for using TransferSpreadsheet?  I am unable to
find any documentation about it in the books I have other than stating that
there is such a thing.  the Access help screens do not show an example.
thanks

I'm doing a vehicle report for a fleet of vehicles. The table includes, among
other things, the date, current mileage and gallons of fuels purchased. I
would like to set up a query with a calculated field for miles per gal. This
would entail having the query include the previous ...

Access 2002:
In the Detail_Format event procedure, I'm using:
Me.NextRecord
Me.MoveLayout

Here is a little problem of mine that no one around me can answer (a
recurrent problem!). Imagine a very simple case study where I work on two
fields, let’s say: <Species> and <Locality>.
I want to report the results of a study (an inventory) so that I create a