ACCESS FEED: [MS_AccessPros] Re: Datepart not available

Rabu, 17 Februari 2016

[MS_AccessPros] Re: Datepart not available

Bill,

I usually do just that and 99% of the time, it fixes it. There are no references that show missing. How do I check to see if the references are the same version? See my other reply.

Doyce

---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :

Doyce

When one PC gets an error and everyone else is fine the first thing I do is give that PC a fresh copy of the FE. If that doesn't fix it run a test with the accdb on that PC so you can do some debugging. It might be that the PC in question has an older version of a reference so the one you used is now marked as MISSING in the references.

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, <winberry.doyce@...> wrote :

Pros,

I have one PC running an accde file that errors when a particular form is opened with this error message:

Function is not available in expressions in query expression '(((DatePart("yyyy",[ORDDTE_27]))>=Year(Date())-1)'. The particular form opens on every other PC using the same copy of the ACCDE file. The database is split and each user has their own accde file on their PC. Here is the SQL of the form's record source:

SELECT [SO Master].ORDNUM_27, [SO Master].COMNT2_27, [SO Master].COMNT3_27, [SO Master].CUSTID_27, [SO Master].CUSTPO_27, [SO Master].ORDDTE_27, [SO Master].COMNT1_27, DatePart("yyyy",[ORDDTE_27]) AS CurYear
FROM [SO Master]
WHERE (((DatePart("yyyy",[ORDDTE_27]))>=Year(Date())-1));

Doyce

__._,_.___

Posted by: winberry.doyce@roadsysinc.com

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)