When I open a report in MS Access nothing happens and no error message is
displayed.  I have re-install MS Access and created new reports but they
cannot be viewed.
Any ideas?

I am using VBA in an Access 2000 database to programmatically print reports
to the default printer.  These two lines control the print:
DoCmd.OpenReport <ReportName>
DoCmd.PrintOut

Hi;
I use Access 2000 and have a report based on a query.Although when i open
that query,records are ordered perfect,opening  report is not the same as
its bound query,until i manually enter the ordering fields in property sheet

I have been asked to produce a report showing sales from all branches of my
Company. I currently have detailed info for my branch sales, and want to keep
this separate from the data from other branches. I have created a separate
table for the other branches to enter date, product ...

I have a number of text boxes on each line of my report but depending on
certain criteria, i want to play with the .visible property, eg.
If txtbox1.value = "Yes" then
txtbox2.visible = True

I am working on a simple pie chart that has several
different labels.  I want to arrange the labels evenly
around the pie chart so they are all visible and there
are no overlaps.

I have a series of reports which can be exported to Excel using the
following code:
   DoCmd.RunCommand acCmdOutputToExcel
Clicking on the "Analyze it With Excel" button, exports to Excel and formats

I created an Access2000 application many moons ago.
This program uses Access reports for printing data to the user and until now
this has always worked perfectly on some 20 customer computers where I
installed the program. These computers were either using the Access2000

How do I cancel the last page break on a report to stop printing a blank
final page?
T.I.A
Dave

I need to be able to have all dates returned from a query with start and end
parameters..
For example if the range is from 01/01/2005 to 01/15/2005 I need the report
to include those dates regardless if they are in the table queried or not.

Any one a solution for my problem.
I created a report with sales figures for an productgroup. This figures
result in a weekly report of over 150 pages.
I would use duplex printing if not for the problem that I keep getting the

I have a report based on a query with 2 separate expressions contained
within.  When I run the query the expressions run fine and I get the data
requested.  When I run the report, I'm getting the error that the expression
is typed incorrectly or too complex to be evaulated.

Many posts here indicate there is no fix to the fact that Access can't
convert a report to Word or other correctly.  Is there anything being done
about this?  Currently when converting a report to Word a lot of text is
dropped and I have to type it back into the Word document to ...

I need to use some functions like avg() and stdev(), but only on multiple
fields in the current row, not on a whole column, as is the default.  Would
someone please recommend some way of doing this?  For example, I have 3
columns, param1, param2, param3, and I want to show those ...

How can I get a field on a report to print a black box if the field is null.
I tried using the conditional formatting function but it didn't give the
option to choose if the field was null.
I cannot change the data format because the data is from a linked table.