? Compatibility issues with Access database and 64 bit systems 2

[Mayhem9]

Hello,

I received a lot of help here in the past with a tool log database, which was built and working well in Access 2003 (and still is). I have since shared it with some retired folk on a machining forum, so their wives have a record of what their tools and equipment is worth, should they die (a little morbid I know).

Anyhow, one of these guys cannot get the database to run and is somewhat ambiguous as to what the problem is. I have managed to find that the problem appears to be due to him running a 64 bit system. He sent a picture of the error message but some of it is difficult to read. However, I'm sure you guys will know it:

The expression On Open you entered as the event property setting produced the following error.  The code in the project must be updated for use on 64-bit systems.  Please review and update...

I have a macro that opens the main form, which I assume is the form that is returning the error. Here is the form open (I couldn't find 'on open) code:

'Find As You Type combo box code by MjaP
'[URL unfurl="true"]http://www.tek-tips.com[/URL]
'code links to class module FindAsYouTypeCombo

Private Sub Form_Open(Cancel As Integer)
  DoEvents
  faytMan.InitalizeFilterCombo Me.cmbMan, "Manufacturer", False
  faytCat.InitalizeFilterCombo Me.cmbCat, "Category", False
  faytLoc.InitalizeFilterCombo Me.cmbLoc, "Location", False
  faytPur.InitalizeFilterCombo Me.cmbPur, "Purchase", False
End Sub

Any thoughts? The database can be downloaded HERE if anyone has the time to have a look or point me in the right direction.

Thanks

 

[PHV]

The problem is probably with the Class module ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mayhem9]

Thanks PHV,

I'll take a look at the class modules. By the way - I posted the link to the database, as I have often been asked to do this in the past. I wasn't expecting someone to simply fix it for me.

 

[Golom]

Here's one possible issue. If you are declaring API functions then you need to deal with the changes from VBA6 to VBA7 as used on 64-bit systems.

And this is a similar take on it.

 

[Mayhem9]

Thanks Golom.

I have read the pages you pointed to and also some others and I am confused, as some seem to suggest that 32-bit code will work in the 64-bit version of Access 2010 but not the other way around.

Additionally, it seems that have a copy of Access 2010 in order to test any changes I make.