Form/Query Help

[ashleydkennedy]

I want to create a form to use as a database query tool. I would like to have a drop down box that has a list of the tables used in my database, then I would like a list box that shows the columns from the table that the user selects in the list box (maybe done through some sort of lookup). I would like to run a query based on these constraints and possibly attach a date parameter constraint to this as well. Is this possible?

 

[ashleydkennedy]

I know you can do this stuff easily with the database window and query wizard, but I am trying to make a front end to my database and make it easy to use for the people at work. However, I guess this would be a big task. Maybe easier to just forget it? Any thoughts?

Thanks again,
Ash

 

[Ricki]

Hi Ashley, I don't know about whether this is the wisest approach to your problem or not (as per prior replies), however getting a list of tables, then for a given table a list of fields, is quite simple. The 'tabledefs' collection is all the tables in your database, and for each table the 'fields' collection is all the columns in the table. Let me know if you'd like a code sample on how to work thru this.
Regards,
Ricki