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:
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:
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
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:
Code:
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:
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