DataGrid (VB6) in Acces2003 form

[Jurek]

Hi all,

DataGrid from VB6 in in main form.
I build recordset :

Dim qdf_temp As QueryDef
Set qdf_temp = CurrentDb.CreateQueryDef("", tmpSQLstr)

Dim rs As Recordset
Set rs = qdf_temp.OpenRecordset

If I try

DataGrid.DataSource=rs

I receive message "Type mismatch"

Why ? Where is mistake ?
What is difference when I build recordset which based on DAO or ADO? Is
different internal structure or something another ?

Regards
Jurek

 

[Douglas J. Steele]

Not sure, but since you're dealing with objects, not variables, you probably
need to use

Set DataGrid.DataSource=rs

 

[Jurek]

Hello,

Thank's for answer.

Of course , should be as you wrote. I missed "set" in post :-(

I try use DAO, but I'm not sure that it is possible, is it ?

Regards
Jurek

 

[Douglas J. Steele]

I would expect DAO should work: I believe VB6 predates the introduction of
ADO, so its controls would be execting DAO recordsets.

 

[Robert]

I was wondering how you get a datagrid in Access. How is that done? Can it
be done in Access 2002?

Robert

 

[Douglas J. Steele]

Try setting the DefaultView property of the form to Datasheet and see
whether that's what you need.

 

[Robert]

Somehow I had gotten the impression you could only do that with subforms.
If you double click on a line is there some way to get key value for that
line for a drill down?

 

[Douglas J. Steele]

Referring to the control should give you the value for the active row.

 

[Robert]

Thanks.

Referring to the control should give you the value for the active row.