Runtime error 6160, data access error.

[Pat]

Hi:

Here is what I have done, I created a customized datagrid,
in order to put on some combobox. I chose datagrid because I donot want to
handle those data connection stuff.
It works great when there is data in the backend table.

But I have the above error when the recordset is empty,
it is strange that if I use datagrid directly, everything is fine. All I
have done is that reassign the dataSource to
the underlying datagrid in my user control. Any help will be greatly appreciated.

Pat


=================================
MyGrid.ctl
Public Property Let DataSource(ds As Object)
Set DataGrid1.DataSource = ds
End Property

[dnagel]

Not fresh on this anymore... but

try
DataGrid1.DataSource = ds.name

'replace ds.name with the appropriate property
'if that not the right one...

D.




"Pat" <pwang@uclink.berkeley.edu> wrote in message
news:3c489a9e$1@147.208.176.211...
>
> Hi:
>
> Here is what I have done, I created a customized datagrid,
> in order to put on some combobox. I chose datagrid because I donot want to
> handle those data connection stuff.
> It works great when there is data in the backend table.
>
> But I have the above error when the recordset is empty,
> it is strange that if I use datagrid directly, everything is fine. All I
> have done is that reassign the dataSource to
> the underlying datagrid in my user control. Any help will be greatly
appreciated.
>
> Pat
>
>
> =================================
> MyGrid.ctl
> Public Property Let DataSource(ds As Object)
> Set DataGrid1.DataSource = ds
> End Property

[PARDON MUCHENJE]

HI

MAY I ASK HOW A VISUAL BASIC v6 PROGRAM CAN BE CONNECTED TO AN MS ACCESS
DATABASE SO THAT I CAN PERFOM SOME CALCULATIONS USING SOME OF THE DATA.
I ALSO REQUEST TO BE INFORMED HOW I CAN INSERT SOME VALUES FROM THE VB PROGRAM
INTO THE ACCESS DATABASE.


MY E-MAIL ADDRESS IS THE ONE SPECIFIED ABOVE

THANKS.