Peter's Software
Helping you create better Microsoft Access applications

Table of Contents

1. I'm getting a compile error "User-defined type not defined" and the line "cnnCurr As ADODB.Connection" is highlighted.



2. I'm getting a compile error "User-defined type not defined" and the line "cat As New ADOX.Catalog" is highlighted.



3. I want to drag items from one listbox to another and insert records into a table when the items are dropped on the second listbox. How can I do this?

Answers

1. I'm getting a compile error "User-defined type not defined" and the line "cnnCurr As ADODB.Connection" is highlighted.
   
   This error can occur when you have module references (click Tools > References from any module in design mode) that conflict with the DAO/ADO setting in Drag-N-Dropper. If you are using Access 2000/DAO, then you can set the Drag-N-Dropper compiler directive constant "DD_DAO_OR_ADO" (see the basDragNDropper declarations section) to "DAO". For Access 2000 and 2002, this constant is set to "ADO" by default. See the help file section entitled "How to Compile for ADO (or DAO)" for more information.
   [Back to the top]
    
2. I'm getting a compile error "User-defined type not defined" and the line "cat As New ADOX.Catalog" is highlighted.
   
   This error can occur when the required module reference (click Tools > References from any module in design mode) "Microsoft ADO Ext. 2.x for DDL and Security" is not checked. If you are using Access 2000/ADO, then make sure this library reference is checked. See the help file section entitled "How to Compile for ADO (or DAO)" for more information.
   [Back to the top]
    
3. I want to drag items from one listbox to another and insert records into a table when the items are dropped on the second listbox. How can I do this?
   
   There are 3 different ways to do this with Drag-N-Dropper.
   
   
   1. Let Drag-N-Dropper handle it automatically
   2. Execute Explicit SQL on drop
   3. Execute a Custom Function on drop
   
   
   As shown in "Example 3" in the Drag-N-Dropper demo, DD can build and execute SQL Insert statements if the underlying table fields have matching names. When you don't have matching field names, you can use Explicit SQL (see the help file) to execute a more complex SQL Insert statement. If your needs go beyond running an SQL statement, you also have the option of executing a Custom Function on drop (see the help file for more information).
   [Back to the top]