[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