after Access conversion error in reports

[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

 

[John Vinson]

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]