
Can anyone explain why this happens?
I have a app written in VB6, using CR that comes with Visual Studio 6 (CR ver is 4.6)
One of the reports I have is based on a table (and only one table) in an access database. In fact, the table only has one data column. There are no calculations, sorting or complex functions at all. The report just prints the contents of the table.
When the user clicks the 'Print' button, I remove all records in the table and re-populate it, based on options selected by the user. Then I activate the report. The report runs fine the first time. However, if the user then changes one of the options and re-runs the report, only the header and footer information is displayed. No data from the table. Even though there is data in the table.
At first I thought it could be that the disk hadn't written the data from cache/memory yet. But if this was the case it should have printed the data from the previous print. Just to be sure I put a 'For...Next' loop in, up to 5000, with just a 'DoEvents' statement in it. This didn't fix the problem.
Can anyone explain why this is happening please?
Thanks for any ideas.
Brent.