Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2007

Tip: Looking for answers? Try searching our database.

Trapping Broken Reference

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NZ VBA Developer - 21 Sep 2007 01:20 GMT
Is there any way to trap the error for a broken/missing reference in a project?
Signature

Cheers!

The Kiwi Koder
Go the All Blacks!

Shauna Kelly - 21 Sep 2007 12:36 GMT
Hi

Yes, you can do that, but only if the user has trusted access to the VBA
project - and no sensible IT admin would allow that.

So the short answer is no.

The solution is to use late binding, and check whether your object has been
properly established. I generally sequester code that requires this into
small functions, and make the change to late binding near the end of the
coding process so I can have the advantages of early binding while I'm
working.

There's more info on this at
Early vs. Late Binding
http://www.word.mvps.org/FAQs/InterDev/EarlyvsLateBinding.htm

but it's only available for Wallabies supporters<g>.

Hope this helps.

Shauna Kelly.  Microsoft MVP.
http://www.shaunakelly.com/word

> Is there any way to trap the error for a broken/missing reference in a
> project?
NZ VBA Developer - 23 Sep 2007 10:28 GMT
Hmm... Very interesting but probably won't help in my case. Looks like I'll
have to rely on 'administrative' controls - a properly designed installation
package for rolling out the project to the users. Just hope the client's IT
manager isn't a Wallabies fan - or worse: an England supporter! <g>

Thanks Shauna
Signature

Cheers!

The Kiwi Koder
The ABs - 2007 Rugby World Cup Champions

> Hi
>
[quoted text clipped - 22 lines]
> > Is there any way to trap the error for a broken/missing reference in a
> > project?
Russ - 30 Sep 2007 06:40 GMT
The Kiwi Koder,

A Google search found this discussion:
<http://www.utteraccess.com/forums/printthread.php?Cat=&Board=84&main=749878
&type=thread>

If that info works for you or you find something that does, please post a
comment back here for everyone's benefit.

> Hmm... Very interesting but probably won't help in my case. Looks like I'll
> have to rely on 'administrative' controls - a properly designed installation
[quoted text clipped - 29 lines]
>>> Is there any way to trap the error for a broken/missing reference in a
>>> project?

Signature

Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.