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 / July 2006

Tip: Looking for answers? Try searching our database.

Adding multiple Office References

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
PamelaDV - 31 Jul 2006 01:43 GMT
OK - I am getting an odd error in my application.  I have done my
research and discovered that the error I am getting (Function is not
available in expressions in table-level validation expression) is
actually a references problem.

I run Office 2003 on my computer and in this last version that I
created of my Access application I created a reference to Excel for
some functionality that I created to export reports from Access to
Excel.  I believe that my problem is that most of my users have Office
2002 on their machines - so the reference that I have for Excel 2003 is
going to be different and not in the same place.

So my question (I promise I'm getting to it) is  ....

Is there any way that I can add the Excel 2002 reference to my
application without having Office 2002 installed on my machine?

Also, I distribute the application with a wise installer.  Would I be
able to specify the location of the excel.exe reference in the
installer?

Any help is greatly appreciated.

Thanks!
Rick Brandt - 31 Jul 2006 02:00 GMT
> OK - I am getting an odd error in my application.  I have done my
> research and discovered that the error I am getting (Function is not
[quoted text clipped - 20 lines]
>
> Thanks!

Google these groups on the term "late binding".  It is a way to utilize external
code libraries without adding a reference at all.  Then your code works despite
the version the user has installed (as long as the calls you make to the library
ar not version sensitive).

It is actually an easy conversion to make if you already have functioning code
with early binding and it really is the ONLY way to build apps that will be used
on multiple machine configurations.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

PamelaDV - 31 Jul 2006 04:02 GMT
Thank you Rick!  I have taken your suggestion.  I have changed my code
to utilize late binding and I am going to try it out tomorrow.  I will
let you know how it goes.  Thank you very much for your advice.

Pam

> > OK - I am getting an odd error in my application.  I have done my
> > research and discovered that the error I am getting (Function is not
[quoted text clipped - 34 lines]
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
PamelaDV - 31 Jul 2006 20:51 GMT
Rick - this did work.  Thank you very much!

Just as an FYI ...  the following article was of the most help to me
...

http://www.granite.ab.ca/access/latebinding.htm

On to bigger and better things!

> Thank you Rick!  I have taken your suggestion.  I have changed my code
> to utilize late binding and I am going to try it out tomorrow.  I will
[quoted text clipped - 40 lines]
> > Email (as appropriate) to...
> > RBrandt   at   Hunter   dot   com
 
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.