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:
[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: