[AccessD] Selecting entire record

Yes, but I have rethought the problem and have come up with a different and 
much easier solution.

Thanks anyway. :)

Susan H.


> 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