[AccessD] Selecting entire record

Charlotte Foust cfoust at infostatsystems.com
Fri Sep 18 09:31:08 CDT 2009


I'll take your word for it.  I can't recall ever using it in DAO.

Charlotte 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Thursday, September 17, 2009 8:09 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Selecting entire record

I very rarely use ADO.  For me it's either DAO or ODBC.

But according to Help, it is available in DAO as well.

--
Stuart

On 17 Sep 2009 at 15:27, Charlotte Foust wrote:

> Only in ADO.
> 
> Charlotte
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> McLachlan
> Sent: Thursday, September 17, 2009 3:26 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Selecting entire record
> 
> Damn!  16 years of using Access and I've never used GetRows().
> 
> Guess you are never too old to learn eh?
> 
> --
> Stuart
> 
> 
> On 17 Sep 2009 at 15:12, Charlotte Foust wrote:
> 
> >     avarData = rstTemp.GetRows(intNumber)
> > 
> > Where intNumber is the number of rows to retrieve.
> > 
> > Charlotte
> > 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> > McLachlan
> > Sent: Thursday, September 17, 2009 2:39 PM
> > To: Access Developers discussion and problem solving
> > Subject: Re: [AccessD] Selecting entire record
> > 
> > Ok, the first part was obvious:
> > 
> > Dim  vRow as Variant
> > 
> > The same question remains "how would you assign a row to a
variable"?
> > 
> > vRow = ????????
> > 
> > (an Access solution please, not .Net)
> > 
> > --
> > Stuart
> > 
> > On 17 Sep 2009 at 14:09, Charlotte Foust wrote:
> > 
> > > Dim the variable as a variant.  It's much easier in .Net because 
> > > you
> 
> > > can actuall dim row objects.
> > > 
> > > Charlotte
> > > 
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> > > McLachlan
> > > Sent: Thursday, September 17, 2009 1:52 PM
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Selecting entire record
> > > 
> > > How would you assign a row to a variable?
> > > 
> > > --
> > > Stuart
> > > 
> > >  On 17 Sep 2009 at 13:41, Charlotte Foust wrote:
> > > 
> > > > Not sure I understand what you're trying to do.  You could dim a

> > > > variable and assign the row to it then use the variable, but 
> > > > what exactly did you want to do with it?  Did you want to 
> > > > duplicate the
> 
> > > > record in the same recordset, copy it to another or what?
> > > > 
> > > > Charlotte
> > > > 
> > > > -----Original Message-----
> > > > From: accessd-bounces at databaseadvisors.com
> > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan

> > > > Harkins
> > > > Sent: Thursday, September 17, 2009 12:25 PM
> > > > To: Access Developers discussion and problem solving
> > > > Subject: Re: [AccessD] Selecting entire record
> > > > 
> > > > Well yes... I'm sorry -- I said SQL didn't I. I meant using an 
> > > > ADO
> 
> > > > Recordset object. I want to move through the entire table,
> selecting
> > 
> > > > the whole record for copy purposes.
> > > > 
> > > > Susan H.
> > > > 
> > > > 
> > > > > Isn't that what Select * is for?
> > > > >
> > > > > Charlotte
> > > > 
> > > > --
> > > > 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
> > > 
> > > 
> > > --
> > > 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
> > 
> > 
> > --
> > 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
> 
> 
> --
> 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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list