Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / January 2005

Tip: Looking for answers? Try searching our database.

References thru VBA

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
past perfect - 14 Jan 2005 03:44 GMT
Hi,
I have a frontend/backend database. Sometimes when I install the
program on a new machine I find out that there are reference problems.
Is there a way to trap this error in code?
Then perhaps I could delete the reference if I feel I can live without
it.
As an example I reference MSWord. But I have Word 2003. The new user
might have MSWord 2000. I will get an error. If I could handle the
error in code it would look much more professional.
Thanks for your time
Paul Overway - 14 Jan 2005 04:30 GMT
If the reference is something like Word, Excel, or Outlook...you're better
off not to have it at all.  Use late binding instead (see help for
CreateObject/GetObject).  Using late binding, you don't need the reference
and can trap error 429 if CreateObject fails.

Signature

Paul Overway
Logico Solutions
http://www.logico-solutions.com

> Hi,
> I have a frontend/backend database. Sometimes when I install the
[quoted text clipped - 6 lines]
> error in code it would look much more professional.
> Thanks for your time
Douglas J. Steele - 14 Jan 2005 22:30 GMT
In addition to Paul's suggestion (which I agree with wholeheartedly), you
might want to read what MichKa has at
http://www.trigeminal.com/usenet/usenet026.asp

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
> I have a frontend/backend database. Sometimes when I install the
[quoted text clipped - 6 lines]
> error in code it would look much more professional.
> Thanks for your time
 
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.