ADO And Datareport 
Author Message
 ADO And Datareport

So I created a parent child ADO:

Private Sub Form_Load()

Dim oConn As ADODB.Connection
Dim oRS As ADODB.Recordset
Dim oRSChild As ADODB.Recordset

Set oConn = CreateObject("ADODB.Connection")
Set oRS = CreateObject("ADODB.Recordset")

oConn.Provider = "MSDataShape"
oConn.Open "Data Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=d:\Testen\CCRM.mdb;Persist Security Info=False"

oRS.Open "SHAPE {SELECT * FROM Overzichtenteamselectiedeel1 WHERE TeamId =
11} " _
    & "APPEND ({SELECT * FROM Overzichtenteamselectiedeel2} " _
    & "AS oRSMedewerkers " _
    & "RELATE TeamId TO TeamId)", oConn

And now I want to connect it to a datareport. Everything I tried comes back
with errors. Does NE1 know how to do it?
Thanks!



Fri, 27 Jun 2003 05:36:42 GMT  
 ADO And Datareport
The easiest way to use Datareport is to make your query in the
DataEnvironment and then go into the properties of the Datareport and attach
the Data Source.  Don't bother with the coding the DataEnvironment handles
it really nicely.

Scott


Quote:
> So I created a parent child ADO:

> Private Sub Form_Load()

> Dim oConn As ADODB.Connection
> Dim oRS As ADODB.Recordset
> Dim oRSChild As ADODB.Recordset

> Set oConn = CreateObject("ADODB.Connection")
> Set oRS = CreateObject("ADODB.Recordset")

> oConn.Provider = "MSDataShape"
> oConn.Open "Data Provider=Microsoft.Jet.OLEDB.4.0; Data
> Source=d:\Testen\CCRM.mdb;Persist Security Info=False"

> oRS.Open "SHAPE {SELECT * FROM Overzichtenteamselectiedeel1 WHERE TeamId =
> 11} " _
>     & "APPEND ({SELECT * FROM Overzichtenteamselectiedeel2} " _
>     & "AS oRSMedewerkers " _
>     & "RELATE TeamId TO TeamId)", oConn

> And now I want to connect it to a datareport. Everything I tried comes
back
> with errors. Does NE1 know how to do it?
> Thanks!



Sat, 28 Jun 2003 14:37:32 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. ADO and DataReport ?

2. ADO and DataReports Questions

3. ADO VB6 DataReport question

4. ADO with DataReports

5. DataReport using ADO - Please help

6. datareport and ADO

7. Help!!! with DataReport ADO RST

8. VB6, DataReport and ADO???

9. Please advice me on ADO/DAO/DataEnv/DataReport

10. VB6/MSAcess ADO Datareport Error

11. DataReports with ADO Data Control?

12. Bind an ADO recordset to a Grouped Datareport

 

 
Powered by phpBB® Forum Software