I need to adjust code for users with a variety of 32 or 64bit, ACCESS 2010 or 2013 ...AURGH (its a problem out of my control -truly)
So I set up code to test what is running, adding the PtrSafe code to any declare statements in 64bit... but its not working correctly
... set up some code to simply trace what's happening
problem is in the first test the answer is Win32, but then in the second, I get "vba7 - Win64"
wholly perplexed, Mark
... running ACCESS 2013
MsgBox SysCmd(acSysCmdAccessVer) yields 15.0
If Win64 Then
MsgBox "Win64"
Else
MsgBox "Win32"
End If
If VBA7 Then
If Win32 Then
MsgBox "vba7 - win32"
Else
MsgBox "vba7 - win64"
End If
Else
If Win32 Then
MsgBox "NOT vba7 - win32"
Else
MsgBox "NOT vba7 - win64"
End If
End If