Compile error on 64bit Office - Declare statements need to be updated

浩子 浩 1 Reputation point
2022-07-14T14:00:38.117+00:00

When I opened Endonte Manuscript Templates, I received an error, "The code in this project must be updated for use on 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute".
What should I do next?

220759-%E5%BE%AE%E4%BF%A1%E5%9B%BE%E7%89%87-20220714215812.png

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
797 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ken Sheridan 2,581 Reputation points
    2022-07-14T16:16:36.057+00:00

    In the VBA editor select Replace from the Edit menu and for the Current Project find and replace all instances of Declare Function with Declare PtrSafe Function. Do the same to replace Declare Sub with Declare PtrSafe Sub.

    It's possible, but probably unlikely, that some functions or sub-procedures might still be incompatible with the 64 bit Office environment, and would need to be replaced with other methodologies.


  2. Ken Sheridan 2,581 Reputation points
    2022-07-16T10:57:49.817+00:00

    You need to give us more information than that. What didn't work? Have you done a Find in the VBA editor to check whether all the relevant routines have been amended or not? If they have, are you still incurring a compilation error?

    0 comments No comments