Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

after Access conversion error in reports

Discussion in 'Information Technology' started by dwojt, Jul 28, 2006.

  1. dwojt

    dwojt
    Expand Collapse
    Guest

    We have an old access database on a win3.1 system and I moved it off to the
    server. The access version is 2.0 and I converted it to Access 2k2. After
    the conversion when you look up product info. some fields are missing from
    the report. You get part numbers, weights, percentages, times, etc. but
    customer and description fields come up #errror. I went through the
    individual reports and the information is still there. Was wondering if
    there was a link that was broken or whatever? If anyone knows I'm at your
    mercy. TIA

    dwojt
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 19 Jun 2006 08:04:02 -0700, dwojt
    <dwojt@discussions.microsoft.com> wrote:

    >We have an old access database on a win3.1 system and I moved it off to the
    >server. The access version is 2.0 and I converted it to Access 2k2. After
    >the conversion when you look up product info. some fields are missing from
    >the report. You get part numbers, weights, percentages, times, etc. but
    >customer and description fields come up #errror. I went through the
    >individual reports and the information is still there. Was wondering if
    >there was a link that was broken or whatever? If anyone knows I'm at your
    >mercy. TIA
    >
    >dwojt


    There might have been some Access Basic code in the 2.0 application
    that didn't convert properly to VBA (there was a *huge* change in
    database architecture between A2.0 and A95). You'll need to open the
    report in design view and examine the code, the Control Source
    properties of these controls, the Query upon which the report is
    based, and just dig through and debug it.

    You say you went through the individual "reports" - do you mean the
    Tables? Data isn't stored in reports!


    John W. Vinson[MVP]
     

Share This Page