Database Schema Through VB 1

[zivrap]

Hi All,

I have an access 2002 database and vb 6 pro. For one of my vb forms, I want the user to be able to select any field from any table in the database and place it on the form. I was wondering if vb has some sort of database schema explorer which would allow the users to do this(kind of like in crystal reports where you can choose the fileds you want to place on your report).

If this is not possible in vb, would any of you have any suggestions on how I would approach this problem? Thank you for the help.

 

[zemp]

See thread709-474678.

zemp

 

[zivrap]

Hi zemp,

Thanks for the link; I saw all the tables and fields in the debugger but I want to be able to allow the user to select fields and place it on the form. Would this be too difficult to do in vb?

 

[zemp]

No it shouldn't be difficult. You now have all the information in a variable. Just use the variable to fill a list box (or other control) that the user can select from.

zemp