[AccessD] rsR("order") vs rsR!Order

Jim Dettman jimdettman at verizon.net
Mon Aug 1 07:20:23 CDT 2011


It's also a tad faster.  All the bang/dot notation internally is converted
to that format before being executed.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
Sent: Sunday, July 31, 2011 11:28 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] rsR("order") vs rsR!Order

Hi guys & Gals,

Slower day at work today so I was poking around some code they use here in
my new role and found this syntax when dealing with recordsets in Access VBA

rsR.AddNew
rsR("order") = rsM("order")
rsR("sheetname") = rsM("sheetname")
rsR("sheetnumber") = rsM("sheetnumber")
rsR.Update

It is very, ummm, MS Excel in style, but it does work ok and update the
recordset(s) correctly.
However I would have written it like:

With rsR
	.AddNew
      !order = rsM!order
	!sheetname = rsM!sheetname
	!sheetnumber = rsM!sheetnumber
	!Update
End with

Not withstanding then with / end with bit.  What is the advantage (if any)
of one syntax over the other?  Is one method faster?
Actually, Why does the first syntax even work?  I would have though you
would have had to use the ! method, but very clearly I am totally wrong on
that count.

I had not seen code used like that before for MS Access recordsets.  Maybe I
need to get out more?

Your thoughts?

Cheers
Darryl

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