[AccessD] Fastest Way To Get Data Field From Recordset

If they do, they should be Colbyized! <g>

Charlotte Foust


-----Original Message-----
From: Foote, Chris [mailto:Chris.Foote at uk.thalesgroup.com] 
Sent: Wednesday, June 29, 2005 7:51 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Fastest Way To Get Data Field From Recordset



But it presumably will not die if someone has (cough) used a space in
the name Charlotte?

Regards
Chris Foote - UK


> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte 
> Foust
> Sent: Wednesday, June 29, 2005 3:47 PM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Fastest Way To Get Data Field From Recordset
> 
> 
> The first option  is the slowest way.
> 
> Charlotte Foust
> 
> 
> -----Original Message-----
> From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
> Sent: Wednesday, June 29, 2005 7:37 AM
> To: accessd
> Subject: [AccessD] Fastest Way To Get Data Field From Recordset
> 
> 
> To all,
> 
> I have taken over a project and where I would normally use something 
> like
> 
> strMinPayroll = rsMinPayroll.Fields("LowPayrollNo")
> 
> it is written as
> 
> strMinPayroll = rsMinPayroll!LowPayroll
> 
> Is there a difference in speed with these, i.e. is one more efficient 
> than the other etc....
> 
> Thanks in advance for any help on this...
> 
> Paul Hartland
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com