[AccessD] Bind Form to RecordSet

Hi Arthur:

I have had no experience using SPs with MySQL as it is a fairly resent
addition to the product (5 years?).

Stuart seems to be able to do it with no problem though. ;-)

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, February 25, 2013 9:33 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Bind Form to RecordSet

I figured that out, Charlotte. Now I'm on to new problems. I want to
execute a stored procedure in a MySQL database and assign the result set to
the RecordSet of a form. Any suggestions how to do that?

A.


On Mon, Feb 25, 2013 at 12:23 PM, Charlotte Foust <charlotte.foust at gmail.com
> wrote:

> The RecordSource property takes a string.   When you bind a form to a
> recordsource name, you get a DAO connection.  The Recordset Property, as
> opposed to the Recordset Object, is for ADO binding.
>
> Charlotte
>
> On Sun, Feb 24, 2013 at 1:51 PM, William Benson (VBACreations.Com) <
> vbacreations at gmail.com> wrote:
>
> > What the ...???
> >
> > Maybe I am coming in too late on this thread to understand the import of
> > this statement, which all are apparently taking as fact so I guess I may
> as
> > well take it as fact too ... but ... I *never* would have thought that
> > access forms could be bound only to adodb recordsets as opposed to DAO
> > recordsets. I mean after all, ADO came along later in the Access
> lifecycle
> > than DAO, correct? And weren't forms always able to be bound to
> recordsets?
> >
> > I feel totally lost in this.
> >
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com [mailto:
> > accessd-bounces at databaseadvisors.com] On Behalf Of Salakhetdinov Shamil
> > Sent: Sunday, February 24, 2013 2:08 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Bind Form to RecordSet
> >
> >  Hi Arthur --
> >
> > Access forms can be bound to ADODB recordsets only.
> >
> > -- Shamil
> >
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Arthur
Cell: 647.710.1314

Prediction is difficult, especially of the future.
  -- Niels Bohr
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com