[AccessD] Issues with running applications in 64 bit version of Office

Darryl Collins darryl at whittleconsulting.com.au
Sun Jan 29 16:40:18 CST 2012


Doug,

Check out conditional formatting (Google" #IF VBA7").  Here is a good example of what we use here for 64bit and 32 bit compatibility between PC's

<<http://stackoverflow.com/questions/3072356/what-are-the-differences-between-vba-6-0-and-vba-7-0>>

Cheers
Darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy
Sent: Saturday, 28 January 2012 5:45 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Issues with running applications in 64 bit version of Office


I have used a slightly modified version of the relinking code from the Access Developers Handbook for many years. I liked using it as it didn't depend on the Office Dialogs so could be used in runtime versions on computers without Office installed. I dropped the code modules into a customer's application as usual when we split their database and all was well. Until they tried running the application on a computer with Office 10
64 bit. Code breaks on the 32 bit api calls. Not good.

Has anyone run into this and figured out how to work with both 32 bit and 64 bit versions of Access? For the short term I am going to use the Office dialogs, but would prefer to use the Windows api.

Doug

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list