Thank you Roy
I got the solution while fooling around with ADO, we can use Table and
Procedures of ADOX.Catalog ... Anyway, it is a relief that people like you
are out there to ask for help ...
Warm Regds
Biju Sebastian

----- Original Message -----
From: Pardee, Roy E <roy.e.pardee@l...>
To: professional vb <pro_vb@p...>
Sent: Wednesday, August 16, 2000 10:21 AM
Subject: [pro_vb] RE: MS Access


> You can query one of the system tables for this like so:
>
> SELECT Name
> FROM MSysObjects
> WHERE (Type In (1,5,6)) AND
> Left$(Name, 4) Not In ("MSys", "~sq_") ;
>
> The Type field distinguishes the various types of objects in the table--1
is
> a local table, 5 is a query and 6 is a linked table.  The 'Not In' bit
> strains out system tables and queries.  You can inspect this and other
> system tables by checking the System Objects box on Tools -> Options ->
> View.
>
> Just set the RowSourceType property to Table/Query & enter the above in
the
> RowSource prop to the above statement.
>
> If that doesn't suit, there is a more complicated method involving a
> callback function & some ADO/DAO coding.  See the help topic "Create a
list
> box or combo box that gets its rows from a function" for details.
>
> HTH,
>
> -Roy
>
> -----Original Message-----
> From: Prajapati, Vibha [mailto:VPrajapati@i...]
> Sent: Wednesday, August 16, 2000 9:09 AM
> To: professional vb
> Subject: [pro_vb] RE: MS Access
>
>
> You mean,
>
> Display Listbox with the Tables and Queries
> Selected Table or query should open when the user clicks it. OR Display
the
> fields of the selected Table
>
> I think i would be able to help you out, if i know what exactly you are
> planning to do.
>
> Vibha
>
>
>
> -----Original Message-----
> From: Biju Sebastian [mailto:bijukainikkara@h...]
> Sent: Wednesday, August 16, 2000 1:27 PM
> To: professional vb
> Subject: [pro_vb] MS Access
>
>
> Hi All
>
> Can I populate a listbox with all the Tables and Queries in a particular
> MDB file?  I want the user to select between the tables and queries
> after opening an MDB file?
>
> Please help out
> Thanx in advance
>
> Regds.
> Biju Sebastian
>