ADO and VBA - Problems

[Anonymous]

Hello

I'm triyng to use an ADO control with an access database in a vba proyect,
then i fill a datagrid with the database..

There's no problem inserting the control into the form and configuring it,
but when i execute the program no data is loaded into the data grid.

Does anyone know why???

[Anonymous]

Show the code or the connect string your using with the ADO control.

--
Veign
www.veign.com
NEW ActiveX Control - Jeweled Style Buttons
www.veign.com/download_activex.html#jwldbutn
Code Samples & Sample Projects
http://www.veign.com/information/application/info_app.html
Submit Your Best Code (you keep the rights)
http://www.veign.com/information/application/code_submit.html
---------
"Jose Luis" wrote in message
news:B0292639540503F2A0DEB6C2807128B6@in.WebX.maYIadrTaRb...
> Hello
>
> I'm triyng to use an ADO control with an access database in a vba proyect,
> then i fill a datagrid with the database..
>
> There's no problem inserting the control into the form and configuring it,
> but when i execute the program no data is loaded into the data grid.
>
> Does anyone know why???
>
>
>
>
>

[Anonymous]

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Archivos de
programa\Wilo\Wilo-Select Classic\Data\vsSpaix.mdb;Persist Security
Info=False

I've a problem when i set the datasource property of the datagrid, when i
compile it, it shows the error: "No se encontro el metodo o el dato
miembro", i'll traslate it for you: "I cant find the method or data member",
is this because this control in AutoCAD have less properties than in VB
Studio????..

Thank you


"Veign" escribió en el mensaje
news:D664FC3840B5900B3B5776FDFC38B6F4@in.WebX.maYIadrTaRb...
> Show the code or the connect string your using with the ADO control.
>
> --
> Veign
> www.veign.com
> NEW ActiveX Control - Jeweled Style Buttons
> www.veign.com/download_activex.html#jwldbutn
> Code Samples & Sample Projects
> http://www.veign.com/information/application/info_app.html
> Submit Your Best Code (you keep the rights)
> http://www.veign.com/information/application/code_submit.html
> ---------
> "Jose Luis" wrote in message
> news:B0292639540503F2A0DEB6C2807128B6@in.WebX.maYIadrTaRb...
> > Hello
> >
> > I'm triyng to use an ADO control with an access database in a vba
proyect,
> > then i fill a datagrid with the database..
> >
> > There's no problem inserting the control into the form and configuring
it,
> > but when i execute the program no data is loaded into the data grid.
> >
> > Does anyone know why???
> >
> >
> >
> >
> >
>
>

[Anonymous]

Well, they don't have less properties, but they have less properties shown in the "property window". That means that u have to connect it to the database manually (by coding) instead of just changing the properties in the property box (which is what u do in VB).
I had the same problem and Veign led me to this site:

http://www.freevbcode.com/ShowCode.Asp?ID=1728

which contained the code for doing so. It worked perfect for me. So why don't u give it a try....
Just notice that there is a couple of typing mistakes. Double check all the names.
(I think there is a oConn instead of Conn or something like that)
Good luck