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