Charlotte Foust
cfoust at infostatsystems.com
Fri Sep 18 09:31:08 CDT 2009
I'll take your word for it. I can't recall ever using it in DAO. 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 8:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Selecting entire record I very rarely use ADO. For me it's either DAO or ODBC. But according to Help, it is available in DAO as well. -- Stuart On 17 Sep 2009 at 15:27, Charlotte Foust wrote: > Only in ADO. > > 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 3:26 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Selecting entire record > > Damn! 16 years of using Access and I've never used GetRows(). > > Guess you are never too old to learn eh? > > -- > Stuart > > > On 17 Sep 2009 at 15:12, Charlotte Foust wrote: > > > 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 > > > > -- > > 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