GhostWolf
Jul 17th, 2007, 12:37 PM
I have a report that doesn't print the last detail record from the table it's built over.
The original VB6 app was written to use a data environment to retrieve the report's data from an Access database, but we noticed recently that the report doesn't include the table's last record.
I thought I'd get around this problem by creating the report in Access, (still drawing its data from the same table), but when the Access report is displayed from the VB app it still omits the last record's data. What's interesting is that I can close the report that the application opened, manually open the (same) report from the Access database, and it will display all the records from the table.
For example, the following displays on the report when opened by the application:
Operator1
TranType1 105
TranType2 85
Operator Total 200
... but accurately displays the following when opened manually:
Operator1
TranType1 105
TranType2 85
TranType3 15
Operator Total 215
Does anyone have any ideas on this problem?
The original VB6 app was written to use a data environment to retrieve the report's data from an Access database, but we noticed recently that the report doesn't include the table's last record.
I thought I'd get around this problem by creating the report in Access, (still drawing its data from the same table), but when the Access report is displayed from the VB app it still omits the last record's data. What's interesting is that I can close the report that the application opened, manually open the (same) report from the Access database, and it will display all the records from the table.
For example, the following displays on the report when opened by the application:
Operator1
TranType1 105
TranType2 85
Operator Total 200
... but accurately displays the following when opened manually:
Operator1
TranType1 105
TranType2 85
TranType3 15
Operator Total 215
Does anyone have any ideas on this problem?