[AccessD] VBA 7 32/64 calls

[Jim Dettman]

  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