Listing table names

[sconly]

is it possible to list the tablenames from a database in a listbox/combobox on a form in another database ?

if so, HOW??

Matt

 

[ritchieroo]

You can get table names from the MSysObjects system table (usually hidden), and use the following SQL syntax to access an external database.

Private Sub Form_Load()
  Dim sSql as String
  sSql = "SELECT [Name] " & _
      "FROM MSysObjects IN 'C:\someother.mdb' " & _
      "WHERE Type=1 and Flags=0 " & _
      "ORDER BY [Name];"
  Combo0.RowSource = sSql
End Sub

This example assumes that the external database doesn't have passwords or login details.

 

[sconly]

just what i was after. CHEERS!

next thing.

how do i open a form 'frmSearched' with the details of the table i selected from the combobox ?

Matt

 

[ritchieroo]

what do you mean by "details of the table"?

 

[sconly]

sorry i meant the records/data, ie. name address ,etc

Matt

 

[ritchieroo]

Do you know the structure of each external table in advance?

Are you going to open one form that could potentially display many different tables, or will you have diffent forms for each table?