Charlotte Foust
cfoust at infostatsystems.com
Thu Sep 17 16:09:56 CDT 2009
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