problem with DataReport and DataEnvironment

[rasty1611]

Hi,
I have a DataEnvironment and a DataReport in my Visual Basic project, in which I am using Access database. When I produce the report, during run-time, and when I close the report, and try to execute another SQL query to produce a second report I get an error, that the object (my DataReport) cannot stay open...

the run-time error that appears is :

"Run-time error 3705: Operation is not allowed when the object is open"

And when I press "Debug" the error is located in line:
DataEnvironement1.Command1 mystr1
at the object DataEnvironment

Can someone pls pls help ???
or if you know a DataReport , DataEnvironment tutorial, can someone please send me the link?
thank you, so much !!!

[hwnahk]

try to close ur objects
like

rs.close
set rs=nothing

[Hack]

Moved to reporting section

Using The Data Environment
Create Reports Using The Data Report
Data Report Tutorial
Data Report Demo

[rasty1611]

what is rs?

[KGComputers]

Hi,

rs stands for recordset...It is an object used for retrieving values from tables in a database...

[d3gerald]

what the above posts are talking is about the use of ado connection and recordsets.

i strongly suggest that you stop using data environment and migrate to using ado for more flexibility and lesser problems with your system.

check out beacons ado tutorial here

http://vbforums.com/showthread.php?t=337051

[rasty1611]

But I tried to go with ADO before and it was not working.. so I found a tutorial explaining step-by-step how to use DataEnvironment and Commands ...and so I did it with this...

The problem remains; I cannot produce more than once a report....

Can anyone please help me?

[alexis23]

try this.. i hope it could help.

On Error Resume Next
dataenviroment1.rsCommand.close
dataenvironment1.command mystr
On Error Goto 0
 
myreport.show

[rasty1611]

My problem is solved with this!!!
thank you very much Alexis23 !!!!

[gpadrao]

Try this in frm DataReport

Private Sub DataReport_Terminate()
DataEnvironment1.rsRecordset.Close
End Sub

change "rsRecordset" for your app

I´m sorry but my English is bad
I'm only try help you ...