Reporting Problem with Access 2003

  • Thread starter Thread starter Bob B
  • Start date Start date
B

Bob B

Hello All,

I have a client who decided to upgrade to Office 2003. The application
I wrote is in MS Access 2K (MDE file) and everything functions well in
his new Office 2003 environment except two reports. I can run the
reports on my development machine (Windows 2K, Office 2K) and all is
well with the world. When he runs the reports on his machine (Windows
XP, Office 2003), both reports indicate "no data cancelling report"
and fail to run.

Bob
 
Hi Bob.
You may want to make sure that there is a local printer identified. For
instance include genberic printer driver for LPT 1, it does not need to be
hooked up.
Hope this helps.
Fons
 
Fons,

I'm not sure if I was clear in my first post. The application has
about 15 reports and they all function correctly which might eliminate
the local printer issue...correct?

The two that don't work (NO DATA FOUND) are generated from an ON CLICK
event from my client's customer order screen. The screen contains a
sub form with all the orders for a customer and the report(s) use the
ORDER ID from the sub form to create the report(s).

Bob
 
Bob, You are correct, this eliminates the no printer possibility. Is there
any chance the data tables are linked and that in the upgrade process the
link was changed or lost? When you open the report in question in design
view on the client's computer, can you see the source data?
Hope this helps.
Fons
 
Fons,

The tables are linked as the application consists of an MDB and an MDE
file. Also, something rather interesting is one of the problem reports
can be run two ways:
1. From the customer screen containing a subform with all the
customer's orders. The report the Order ID from the subform to create
the report. (it doesn't work here - NO DATA FOUND)

2. Or from a another form where the user enters a ship year in a text
box and using option buttons (all or one) either selects a particular
customer from a drop down list or all customers. (it does work here)

So basically, the same report runs fine from one form but not from the
form containing the subform.

Bob
 
Fons,

I did open the reports in design mode as you suggested and was able to
produce the reports in design mode. But it still gives NO DATA found
when I run them through my application.

Bob
 
Back
Top