[AccessD] Missing references

Shamil Salakhetdinov shamil at users.mns.ru
Sat Feb 17 09:22:43 CST 2007


<<<
Having resolved it once, the app will 
behave as if it were early-bound thereafter.
>>>
Arthur,

You probably meant VBA's/VB6's or VB.NET's 

With
====

Operator?

For "With" operator - yes, it was written somewhere that if you use e.g.

Dim wapp as object
Set wapp = CreateObject("Word.Application")
Dim wdoc as object
Set wdoc = wapp.OpenDocument(....)
...
With wapp.Selection.Font
   .Size = ...
   .Bold = ...
   .Italic  = ...
...

Then wapp.Selection.Font will be saved as internal object reference and it
will not be recalculated for wapp.Selection.Font.Size,
wapp.Selection.Font.Bold, wapp.Selection.Font.Italic, ... etc.

Although the next usage in the code of

With wapp.Selection.Font

Code construct, even in the same function will result in several late-bound
"round-trips" via IDispatch COM interface proxy-stub boundaries to
dynamically recalculate actual target object reference...


--
Shamil
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Saturday, February 17, 2007 5:55 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Missing references

Interesting thread.. I have not seen it mentioned that if you early bind to
an early version, Access will "re-reference" to any later installed version.


 This of course this does not work if the user has an earlier version or no
version at all installed ;-)

Robert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com
Sent: Friday, February 16, 2007 3:43 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Missing references

Quite right, and insofar as you resolve the late-bind issue asap, then such
binding shall not impede the subsequent performance of your app. Having
resolved it once, the app will behave as if it were early-bound thereafter.
 
A.


----- Original Message ----
From: Jim Lawrence <accessd at shaw.ca>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Sent: Friday, February 16, 2007 2:36:22 PM
Subject: Re: [AccessD] Missing references


Hi Jim:

The main reason for using late-binding is that an application developer does
not know what version of Word or Excel is on the clients' computer until the
application is run. By checking the local references a program can then
adapt to its' current surroundings; but this requires a late-binding design.

Just a comment
Jim
--
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