Creating a Query based Form

[Boost]

Hi there, I was wondering if the following was possible.



I would like to create a form, in order to bypass the Report Wizard, so end-users of my db can generate custom queries (select only the relative values) - then utilise the custom search form developed and provided by Gicu (whose assistive thread can be located https://www.accessforums.net/showthread.php?t=72947) to refine this data.

I want to generate a query this way, as I don't necessarily want every value held behind a record. Where previously, auto-generated queries include all values (Surname, Initials, 1st name, Last name, Middle Name, Job Position, Job Title, Job Location etc.) - I would like the end-user to define what values are contained within the query such as (Surname, Middle Name, Job Position) through a form based process in order to generate the specified query.

From here, the query will then be either stored in the dB or temporarily stored in the db - for the Custom Search form developed and provided by Gicu to utilise.

Any thoughts or alternative practices/recommendations would be mutely appreciated!

Cheers

Boost

EDIT: http://www.opengatesw.net/products/Access-Report-Builder/Report-Builder-for-Access.htm perhaps something similar to this.

[June7]

What you describe would involve programmatically setting report RecordSource and other design properties of report and it's controls. If you want something that flexible then I suggest buying that product would be more cost effective than building from scratch.

If you just want to delete and create query objects, that can be done in VBA with SQL. However, I don't recommend implementing process that routinely modifies db design.

[orange]

boost,

Another option, often used in similar situations:
-have users identify 5-10 of the "most needed" reports
-create such reports and make them selectable via a form with combobox.

OR Buy some supported software as June suggested.

You may get more ideas from this Martin Green article.

Good luck with your project