[AccessD] Changing VBA code for 64 bit compatibility

[Steve Schapel]

Hi all.

Sorry, a bit green on this topic.  But I want to change the code in an 
application that contains a very large number of Declare statements, so 
that it will be compatible with 64 bit Access.

I think I know what has to be changed.  But so far it looks like a long 
tedious task.

Has anyone worked out a way to streamline this process.  I know I could 
flick through and replace e.g. "Declare Function" with "Declare PtrSafe 
Function".  But as far as I can see, I would still need to manually 
check each instance for "As Long", and where applicable edit to "As 
LongPtr".  Is that right?

Many thanks.

Regards
Steve