[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