I wrote a simple app in Access 2002 with 3 different reports.  I used a Switch
Board as my menu and each report is called via the Open Report from the
menu. I distributed the app to team members in my company who mostly have
Access 2002. The reports work perfectly on computers ...

How do I show just the day of the week in a date field, i.e., "Tuesday".
TIA!

My VBA module prints out 18 versions of the same report, with a different
record source each time.
I can't figure out how to get the code to stop and let the user look the
report, print it out if required, and then continue to the next version.

Each time I press the button to send the print the report access crash.  The
code is under a button on click event:
   Dim stDocName As String
  stDocName = "Professional profile sheet"

Dear Group:
Ran into a strange behavior on Access 2000 report on Windows 2000 PC. Just
couldn't figure out what was the problem. Please advice. TIA.
I createe a report and set it to landscape print format. On my form, I click

I created a report with multiple sub reports.  When I preview the report, all
looks good, but when I go to print the report, this is the error message that
I get.  Can anyone help me with this.

I'm getting a weird error message and I don't know when the problem started
or what I may have done to cause it.  My database is just a contact
management database.  I have a report that lists each contact with their
associated cell phone, home phone and email address.  The error ...

I want to have all fields in the same row grow to the height of the tallest
field. Nothing changes when I use the Format menu and select Size to Tallest.
All properties for each control are set to "grow". Any suggestions?

Is it possible to send reports via email from within an Access 97 mde file?
I have a procedure that opens outlook in case it isn't already open, then
uses the sendobject function to send a snapshot of a report. It works fine in
the mdb file, but I get an error from the mde saying ...

I am trying to create a report from the table below. My goal is to create a
chart that takes a given date, and for each Dept. (e.g., 305, 315, 325,
800, 700, etc., also shown in a column on the chart), checks the range of
data for whether or not that date falls within the "Time In" ...

What I want to do is always show two decimal places even if the number is 13
or the percentage is 13.  So I would want the numbers to look like 13.00 and
13.00%?  Is there a way to do this?
Thanks in advance

Can anyone assist me with this please.
I have a report that I run in access which shows how much time has been used
by a group of people however the time formats do not allow the time to be
calculated over 24:00:00.  For instance if they have spent 26 hours working

I have created a report which lists the hire id of plant that is to be
invoiced during a set perior of time.  However to print these individual
records out, I have to go into the plant details form, search for the record
using hire id and then press print.  

I have a report without recordsource that includes 3 subreports based on 3
different queries. So there's no link between subreports and main report as
the main report is just used as a collector of the 3 subreports. Each of
these queries have 2 similar fields called 'seller' and ...

I recently posted the below question (can't find it  now) and received an
answer, but I have a further question.  
The answer I received was "use a crosstab query."  OK, I have done that, and
it worked, THANKS!!  BUT, my problem now is that it's not showing ALL of the