Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DataCombo seems locked after changing TabStrip
Hi,
we're trying to install a DataCombo-Control (Mircrosoft DataListsControls 6.0(SP3)) on an Excel2000 UserForm. It is placed on a MultiPage-Control. We have no problems with filling and displaying the DataCombo. On first use everything is ok. But as soon as you change between the pages of the MultiPage the DataCombo seems locked i.e. you can't edit the edit-field from the DataCombo (you can open the pull-down, you seem to be able to select an entry but the selected item is not displayed in the edit-field). If you move the mouse over the edit-field the cursor shows an arrow instead of the insertion-mark ('|'). Our system: Win2000 SP3, Office2000, MDAC 2.7, SQL-Server2000 SP3 Our code for filling the DataCombo is the following: Set recFahrzeuge = New ADODB.Recordset recFahrzeuge.CursorLocation = adUseClient recFahrzeuge.Open "Select * From tblFahrzeuge", cnn, adOpenKeyset, adLockOptimistic Set dummy = Me.Fahrzeug Set dummy.RowSource = recFahrzeuge dummy.ListField = "Fahrzeug" Does anybody know this problem? Any help is greatly appreciated. Greetinx from Germany Reiner |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
protect formulas in locked cells from changing if data is moved | Excel Discussion (Misc queries) | |||
Changing name for "Locked for editing by..." | Excel Discussion (Misc queries) | |||
tabstrip when chart is saved as webpgae | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |