[AccessD] Fastest Way To Get Data Field From Recordset

I think you get round that by using the square brakcets rsMinPayroll![LowPayroll]





Message date : Jun 29 2005, 03:53 PM
>From : "Foote, Chris" 
To : "'Access Developers discussion and problem solving'" 
Copy to : 
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

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm