>Hi,
> Do you know how to put all the table name into the combo box ?
> Because after use adbobject(), the tables name will store in an array right, but how to put all of the table name into the combo to let user select ?
> Thank you
>
>regard,
>kengwen
You could create a combobox class for this
Add 2 properties to it:
aTableArray(1,1)
cDatabaseName
In the Init, do
With this
If !Empty(.cDatabaseName) And DBUsed(.cDatabaseName)
Set Database To (.cDatabaseName)
ADBObjects(.aTableArray, "Table")
ASort(.aTableArray)
.RowSourceType = 5
.RowSource = "this.aTableArray"
EndIf
EndWith
At design time, after you've dropped this control on a form, set the
cDatabaseName
property to the name of the database you want to use.
Insanity: Doing the same thing over and over and expecting different results.