[AccessD] Selecting entire record

    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