Jim-
It's supposed to do that automatically - at least for the Access and VBA libraries - but it often fails on other Office libraries.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
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 Jim Wagner
Sent: Tuesday, March 26, 2013 7:28 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Error with date function
John,
That is good to know. I will remember this for a long time. If I switch between access versions often enough, is there a way to have access connect to the microsoft outlook current version on the machine?
Jim Wagner
________________________________
________________________________
From: John Viescas <JohnV@msn.com <mailto:JohnV%40msn.com> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Tuesday, March 26, 2013 11:23 AM
Subject: RE: [MS_AccessPros] Re: Error with date function
Jim-
Whenever you have a "missing" or invalid library reference, all sorts of things break, including built-in VBA functions like Date.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
Sent: Tuesday, March 26, 2013 7:01 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Re: Error with date function
Bill,
I was missing the Microsoft Outlook reference. I guess when I opened the database up in 2013 it used 15.0 for outlook. I unchecked it and went to the 14.0 and the database opened. So my question is how does outlook 14.0 reference produce Dates error function?
Jim Wagner
________________________________
________________________________
From: Bill Mosca <wrmosca@comcast.net <mailto:wrmosca%40comcast.net> <mailto:wrmosca%40comcast.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Tuesday, March 26, 2013 10:49 AM
Subject: [MS_AccessPros] Re: Error with date function
Jim
Check for missing references in the Code window. Tools>references. If any are marked as missing uncheck them and find the latest version in the list of libraries.
If none are marked as missing, re-register your DAO dll file.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> , "luvmymelody" <luvmymelody@...> wrote:
>
> Hello all,
>
> I opened a database this morning and I get a message that says
>
> Undefined function 'Date' in expression.
>
> The database is usually run in Office 2010 but I think that I opened the database in office 2013 once. Will this cause the database from not opening?
>
> Thank You
>
> Jim Wagner
>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (8) |
Tidak ada komentar:
Posting Komentar