[MSAccessProfessionals] Invalid Procedure Call error

Hello All,

 

Yesterday I started to get an error message for "Invalid Procedure call" when I tried to open a report. This report has been running for years with no issues. This morning after several hours, I deleted from the query this line 

 

MemoWithDate: Left([tblMaxCompensatoryMemo].[Paragraph2],Len([tblMaxCompensatoryMemo].[Paragraph2])-554) 

 

and the query ran successfully with no issues. So, I am assuming that either an office update or something is haywire with the database has recently occurred. I have checked vba references and there are no missing references. 

 

I am not sure where to go from here. Can someone help me find a solution. My user is to the point of extreme frustration with me. 

 

Thank You

 

Jim Wagner

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116642) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_