[AccessD] DECLARE and SafePtr

[Bill Benson]

Thanks Jim for mentioning JKP's site before I could... I will say that I
have run into many APIs that he does not cover though. I look forward to
exploring the file Borge mentioned for things I have had to mess around
with in the past.

One of the most difficult things I have had to deal with are things like
strPtr and AddressOf. And still have not a clue how I made things work or
if I could do it again were a gun or even Arthur's Excalibur held to my
head.

On Sat, Oct 23, 2021 at 8:52 AM Jim Dettman via AccessD <
accessd at databaseadvisors.com> wrote:

>
>  Arthur,
>
>    You should give this page a read:
>
>
>
> https://codekabinett.com/rdumps.php?Lang=2&targetDoc=windows-api-declaration
> -vba-64-bit
> <https://codekabinett.com/rdumps.php?Lang=2&targetDoc=windows-api-declaration-vba-64-bit>
>
>
>  as it explains about the compiler constants and when you might use them,
> along with LongLong, LongPrt, and PtrSafe
>
>  and besides the file that Borge mentioned, there is a good reference here:
>
>
> https://jkp-ads.com/articles/apideclarations.asp
>
>  with the correct syntax.
>
> Jim.
>
> -----Original Message-----
> From: AccessD On Behalf Of Borge Hansen
> Sent: Saturday, October 23, 2021 1:12 AM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] DECLARE and SafePtr
>
> Hi Arthur,
> I've been following your thread re upgrading your Access app from 32bit to
> 64bit.
> I went through the exercise earlier this year.
> I recommend that you have both a 32bit and 64bit version of your Office
> running (on two different machines or VMs of course) to test that the app
> will run both on 32bit version of Office and 64bit version. Your client may
> have a mix of 32bit and 64bit Office.
> If you  have any third party DLLs - or similar - that your app is dependent
> on, make sure that a 64bit version is available.
>
> I used this file:
> Win32API_PtrSafe.TXT
> to help me with the conversion.
> I would search in our vba code for all instances of
> Lib "Kernel32"
> and then copy and paste and search for the specific Declare Function in the
> TXT file, (I would use Sublime Text for searching the .TXT file).
> Then copy and paste the whole Declare PtrSafe Function over the existing
> Declare ...  Lib "Kernel32" function.
> In only a few instances did I need to include testing - doing a
> #If Win64 then
> - and include the two different Lib "Kernel32" functions...
>
> You can download the
> Win32API_PtrSafe.TXT
> from here:
>
> https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win
> 32api_ptrsafe-with-64-bit-support
> <https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/win32api_ptrsafe-with-64-bit-support>
>
> Hope  this helps...
>
> /borge
>
>
>
> On Sat, Oct 23, 2021 at 12:12 PM Arthur Fuller <fuller.artful at gmail.com>
> wrote:
>
> > What s the syntax for such a Declare statement/
> >
> > --
> > Arthur
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>