Class Not Registered

[Ragnar78]

Hy,

Im' trying to use the normal tools that appears when i create a normal Form..
When i try to insert a combobox or a Listbox and it asks how the info should be retreived, when i press nesxt it tells me that Class not Registered.

Can anyone help me out?

Thx again

 

[Joe Was]

For a ListBox the Wizard starts with the selection of the type of data the ListBox will be using: Lookup values is a table or Query, Type Values in, Find Records.

Hit "Cancel" and not "Next." Then see if you can add the code yourself without getting an error?

Try:

'Where "Word" is the field's name to populate the ListBox with and
'ListBox_Lookup" is the name of the ListBox.
'This code will make the selected "Word" the active record in a form that displays records from a table.

Private Sub ListBox_Lookup_AfterUpdate()
' Find the record that matches the control.
Dim rsc As Object

Set rsc = Me.Recordset.Clone
rsc.FindFirst "[Word] = '" & Me![ListBox_Lookup] & "'"
If Not rsc.EOF Then Me.Bookmark = rsc.Bookmark
End Sub

If this works: You may have a data source that Access is not able to find or the Wizard's choices are generic and may not apply to your case?
If this does not work: Then it's a new one for me too!

 

[Ragnar78]

Hy,

Actually i added code to a previous combobox using the "rowsource" property in the "Beforeupdate" event and it works correctly...


This is the simple code...

Private Sub Combo1_BeforeUpdate(Cancel As Integer)

Combo1.RowSource = "SELECT STATUS FROM Indexes;"

End Sub

I can actually even retreive the data found in the objects...like for example when i do an "Afterupdate" in the combobox, i can update the listbox (that is also having the same "Class not Registered" problem...) with the results...so the objects work fine but its the wizard that is not configured i guess.
The wizards, from what i understood, are being controled by the Jet DB engine, and i have the latest version...
i even registered it manually with regsrv32.exe