Data Control Help Requested! 
Author Message
 Data Control Help Requested!

Hi:

I have a VB4 project (DAO 3.0) that is running now under VB5 (DAO 3.0).

I get a Run time error (13), Type mismatch when I try to set a data
control from a recordset.  Everything works fine in VB4.

The data control (dcChangeFC) properties include:

        Recordset Type = 1 - Dynaset
        RecordSource =
        DatabaseName =

Sql1 = "SELECT * From ChangeT"
Set rsChangerFC = Db1.OpenRecordset(Sql1, dbOpenDynaset)

If rsChangerFC.RecordCount > 0 Then
    rsChangerFC.MoveFirst
    Set dcChangeFC.Recordset = rsChangerFC    ***** I get the error
here!!
    Label2.Caption = "Entries Identified"
    Command5.Visible = True
Else
    Label2.Caption = "No Entries Found"
    Command5.Visible = False
End If

Any ideas as to what I'm missing??

Thanks in advance,

Dean



Tue, 19 Oct 1999 03:00:00 GMT
 Data Control Help Requested!

I betcha you have to fully qualify the right oside of the equation

i.e. >    

Set dcChangeFC.Recordset = rsChangerFC    ***** I get the error here!!
make it
Set dcChangeFC.Recordset = rsChangerFC.recordset
(seems redundent doesn't it)

BTW I don't have vb5 yet - this might just be one of the reasons.

Quote:

> Hi:

> I have a VB4 project (DAO 3.0) that is running now under VB5 (DAO 3.0).

> I get a Run time error (13), Type mismatch when I try to set a data
> control from a recordset.  Everything works fine in VB4.

> The data control (dcChangeFC) properties include:

>         Recordset Type = 1 - Dynaset
>         RecordSource =
>         DatabaseName =

> Sql1 = "SELECT * From ChangeT"
> Set rsChangerFC = Db1.OpenRecordset(Sql1, dbOpenDynaset)

> If rsChangerFC.RecordCount > 0 Then
>     rsChangerFC.MoveFirst
>     Set dcChangeFC.Recordset = rsChangerFC    ***** I get the error
> here!!
>     Label2.Caption = "Entries Identified"
>     Command5.Visible = True
> Else
>     Label2.Caption = "No Entries Found"
>     Command5.Visible = False
> End If

> Any ideas as to what I'm missing??

> Thanks in advance,

> Dean



Fri, 22 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Help ! ADO data control and standard data control

2. Help Help Help with Data Control and ODBC databases

3. data control and remote data control

4. Data Control vs Remote Data Control (for Axx95 and VB4/32 Enterprise)

5. Create User Control as Data Source Using ADO Data Control

6. Data controls or no data controls?

7. data control and remote data control

8. Help: DBGrid - Adding data without Data Control?

9. error 6152 and 6153 in data grid sp4 with ado data control Help for italian boy

10. error 6152 and 6153 in data grid sp4 with ado data control Help for italian boy

11. help, help, Data-outline control!

12. Help: Using the datarepeater control with an ActiveX control containing an embedded datacombo control


 
Powered by phpBB® Forum Software