[AccessD] VBA 7 32/64 calls

[David McAfee]

Thanks Jim!

I have some reading to do!

On Wed, Feb 10, 2016 at 10:09 AM, Jim Dettman <jimdettman at verizon.net>
wrote:

>
>   It will work.  Read this for all the info.
>
> http://rdsrc.us/ZVseHE
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> David McAfee
> Sent: Wednesday, February 10, 2016 12:45 PM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] VBA 7 32/64 calls
>
> I just realized my previous request had the wrong subject line.
>
> The VBA 7 subject line was for this question / problem:
>
> Everyone is able to use my little database mapping app that I created
> except for one person in Accounting. She has Office/Access 2010 64bit
> edition installed. Apparently everyone in that dept does, but she's the
> only one messing with Access.
>
> She or IT was under the impression that the 64 bit edition was needed for
> Excel Power Pivot. I told them that there was a 32 bit installer for Power
> Pivot available, that the only thing that I knew of that was better in
> Office 64 bit was Excel's ability to handle 2gb files.
>
> Any, the problem that I am dealing with now is that the app does several 32
> bit calls such as fosUsername and ahtCommonFileOpenSave for browsing and
> selecting files.
>
> I looked for VBA 7 equivalents and found one, but it returned "admin"
> instead of "dmcafee".
>
> It looks like I have to figure out which of the global constants are 32
> bit, and use a  64 bit version instead. What a PITA for one user.
>
> What really sucks is that I don't have the version, so I can't test these
> things before hand, and she is located at a different location.
>
> I tested this on my (32bit) box:
>
>  #If VBA7 Then
>     MsgBox "VBA 7"
>  #Else
>      MsgBox "Not VBA 7"
>  #End If
>
> And it works, so I'm wondering if I could put the declarations in their
> appropriate place inside the IF statement. Or do I (god forbid) make a
> custom version for that user?
>
> Looks like I'm going to be getting back into Web FE with SQL BE for future
> projects. :/
>
> D
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>