General discussion

Locked

VB6 Data Report

By rangling ·
I am developing a VB6 application using the Data Report Module, I need to be able to generate reports for different clients, however i keep getting the same report even though i change the data. How do I update the recordset?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

VB6 Data Report

by nikki96 In reply to VB6 Data Report

Are you using the ADO control? Are you rebinding?

Collapse -

VB6 Data Report

by rangling In reply to VB6 Data Report

The question was auto-closed by TechRepublic

Collapse -

VB6 Data Report

by MadestroITSolutions In reply to VB6 Data Report

Ha my friend, I was having the same problem with this stupid microsoft data reports. Its really annoying because no matter what you do, refresh, rebind, etc, it keeps showing the same data. Well, after good 3 days of browsing Microsoft Online Document maze (Knowledge Base), I finally found the answer to the problem: You need to close the recordset. That is the only way, the report truly unbinds. Here is how:

Include the following line before you modify the recordset with the new data:

'(assuming recordset name = Rs01)

if Rs01.state = adstateopen then Rs01.close

And thats it, it will refresh every time.

Good luck!

Collapse -

VB6 Data Report

by rangling In reply to VB6 Data Report

The question was auto-closed by TechRepublic

Collapse -

VB6 Data Report

by rangling In reply to VB6 Data Report

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums