[FORM] Query Builder Form Generator (GENERATE FORM BASED ON TABLE) (1 Viewer)

BlueIshDan

☠
Local time
Today, 19:20
Joined
May 15, 2014
Messages
1,122
Developed on Access 2010

Hello World!

Ever hate creating a form every time you want to create a query builder for a new table? I know I do! That's why I created an access form that allows you to generate a query builder form for any table within the same access database.

This is all done with one form and one module.

[IMAGE] Query Builder Generator: Query Builder.PNG
[ACCESS DB]: View attachment query_builder_generator.accdb

For every field in the table, a label and combo box will be generated into the form header. The combo box will contain any distinct values for that field. Selecting a value will filter the results in the detail portion of the form.

To use, extract and either place your tables into this access database or bring the module and form into your existing database.

PLEASE PLEASE PLEASE
Do test this out and let me know of if you find any errors. This is going to be a tool that grows and generates more and more intelligent forms based off of your access database! So jump on the band wagon and enjoy the ride haha :)

Regards,
BlueIshDan :)
 
Last edited:

Users who are viewing this thread

Top Bottom