Jim-
You should be using "late binding" that doesn't depend on the correct Outlook
library being loaded. Declare any ol constants you use in your code as
constants, declare all your objects as Object, then remove the library
reference.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
----------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of luvmymelody
Sent: Friday, May 25, 2012 6:38 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Undefined Function in Expression error
Hello,
So I have a form that needs a Outlook reference to open and I usually work in
Access 2010 and it works great. I tried to open it at home and I received a
Undefined Function in Expression error. I googled it and found that I have a
missing outlook reference to 14.0 version. So I unchecked the reference to 14.0
and changed it to 12.0 and it worked.
How do I get the form to work in both versions of access without having to go
back and forth in the references?
Thank You
Jim Wagner
Tidak ada komentar:
Posting Komentar