[AccessD] Bind Form to RecordSet

Thanks for the link, Jim. I spotted some code therein that deals with the
prospect that we're using a stored procedure, so I'll start playing around
there.

A.


On Mon, Feb 25, 2013 at 1:16 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> 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
>
> --
> 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