MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000

Dear all,

I've encountered an unusual problem having just recently upgraded an Access
97 database to Access 2000 format and was hoping somebody could point me in
the direction of a solution.

1. The problem:

Essentially, a couple of the reports which contain SeriesLine charts are NOT
displaying the series-lines (i.e. the results) on the charts correctly in
Preview mode or when printed out. However, they ARE displaying the results
correctly on the charts when the reports are viewed in DESIGN mode.

2. Background:

-I have upgraded the database from Access 97 to 2000 format with very few
changes.

-The forms and reports are from the original Access 97 database

-A few minor mods were made to the VBA code but none of this affects the
reports.

-I have checked the recordsets used by the charts in both 97 and 2000
versions and the data used is identical. Thus it appears to be something to
do with how the chart 'object' is interpreting the recordset.

The Access 97 database was using the following references
-DAO 3.51.
-Microsoft Access 8.0 object library

The Access 2000 format db includes the following references
-DAO 3.6
-Microsoft Access 8.0 object library

Thanks in advance

Nick J




.

Relevant Pages

  • Re: MS Access reports containing line charts are inaccurate after upgrade from access 97 to 2000
    ... > I've encountered an unusual problem having just recently upgraded an ... > Access 97 database to Access 2000 format and was hoping somebody could ... > NOT displaying the series-lines on the charts correctly ... > results correctly on the charts when the reports are viewed in DESIGN ...
    (comp.databases.ms-access)
  • Error when previewing a report
    ... and converted to Access 2000 format. ... system being used is Windows XP. ... run/preview some of the reports, ... database, the report runs perfectly. ...
    (microsoft.public.access.reports)
  • Re: Chart Viewing
    ... the reports & charts to different people without Access. ... be able to convert both to a format that they will be able to view and run ... The only way to give Access charts to people who do not have Access installed is ... In the case of the former the recipients would need to download and install the ...
    (microsoft.public.access.queries)
  • Re: Using the same format on all Forms
    ... as it lets you create forms and reports quickly to your own style. ... Allen Browne - Microsoft MVP. ... I only want this particular database to use the same Format for the forms. ...
    (microsoft.public.access.forms)
  • Strange Form & Report Import Problem - Access 2007
    ... I have automated software that imports new forms, reports, etc. on database startup. ... Occasionally, but always on the same machines, the user will subsequently open one of the new forms or reports, and it will be minimized to the size of a pencil eraser. ... If I am using a db in Access 2003 format, and I do the import in Access 2003, everything is fine. ...
    (comp.databases.ms-access)