[AccessD] Selecting entire record

Stuart McLachlan stuart at lexacorp.com.pg
Thu Sep 17 22:09:19 CDT 2009


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





More information about the AccessD mailing list