[AccessD] Fastest Way To Get Data Field From Recordset

Charlotte Foust cfoust at infostatsystems.com
Wed Jun 29 09:46:47 CDT 2005


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

-- 

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
-- 
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