View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Snowy Snowy is offline
external usenet poster
 
Posts: 9
Default Add Database Names, table names & related fields from table in combo box

Hello All.

I have three combo box on my vb form namely.
1. cmbDatabases.
2. cmbTables.
3. cmbFields.

I have connected to mysql through ADODB.
Their are above 100 databases in mysql.
What i want is to show these databases names in 1st combo box i.e.
cmbDatabases then
show table names from selected database in 2nd combo box i.e. cmbTables
and then show related fields from tables in 3rd combo box i.e
cmbfields.

can anyone tell me how to fetch databases name, related tables & fields
in combo box.

Thanks
Snowy