[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