|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
I split my database (Access2k) and then went into the front end to test my forms, now I'm getting the compile error, the form has a multi list select box (which I got from this wonderful site) and then you press a button to preview a report, when I press the button the Visual basic debugger window appears and with the compile error:
On Error GoTo Err_cmdOpenQuery_Click Dim MyDB As DAO.Database Dim qdef As DAO.QueryDef Dim I As Integer Dim strSQL As String Dim strWhere As String Dim strIN As String Dim flgSelectAll As Boolean Dim varItem As Variant Set MyDB = CurrentDb() I read some of the previous threads regarding compile errors, but I'm still stuck. Hope someone can shad some light on this... |
|
#2
|
|||
|
|||
|
The error means the required references are not present for the declared variables in the project.
|
|
#3
|
|||
|
|||
|
A2K and newer use ADO as the default. You have to explicitly add a reference to the DAO libraries if you want to use DAO. My recommendation is to convert your code to ADO
__________________
====== Doug G ====== I didn't attend the funeral, but I sent a nice letter saying I approved of it. --Mark Twain |
![]() |
| Viewing: ASP Free Forums > Programming > Visual Basic Programming > Compile error: "User-defined type not defined" |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|