Hey all,
I have a rather pressing question regarding Access 2010. We have recently converted to Access 2010 from Access 2002. Some of the databases that we use were written in Access 97 (I think). Since we have converted to the newer version of Access, whenever a user clicks on a command button to view a report based on a specification, a compile error is generated stating that a User defined type is not defined. I was wondering if this error would go away if the database was converted to the 2010 version of Access. I am also having issues with dao and utility ,mda errors, but I will post those questions separately. I am including the code that is causing the error so that you can see what I'm talking about. The code in red is the problem code. I really appreciate any help the community can give me!
Option Compare Database
Private Sub Command10_Click()
DoCmd.OpenForm ("Warp Spec"), acFormAdd
DoCmd.GoToRecord , , acNewRec
End Sub
Private Sub Command14_Click()
Dim qdf As QueryDef, strSQL As String
strSQL = "SELECT * FROM [weave] WHERE [style] = '" & Me![STYLE] & "'"
Set qdf = CurrentDb.QueryDefs("qry view spec draw")
qdf.SQL = strSQL
qdf.Close
DoCmd.OpenForm ("DrawWarp Spec"), acFormAdd
End Sub
Private Sub Command16_Click()
DoCmd.OpenForm ("DrawWarp Spec"), acFormAdd
DoCmd.GoToRecord , , acNewRec
End Sub
Private Sub Command2_Click()
Dim qdf As QueryDef, strSQL As String
strSQL = "SELECT * FROM [weave] WHERE [style] = '" & Me![STYLE] & "'"
Set qdf = CurrentDb.QueryDefs("qry view spec")
qdf.SQL = strSQL
qdf.Close
DoCmd.OpenForm ("Warp Spec"), acFormAdd
End Sub
Private Sub STYLE_BeforeUpdate(Cancel As Integer)
End Sub
Thanks!