Table headers in a list box (Custom Report)

[Rajtomar]

I have a big table with many fields (more than fifty). They are not in
one table but related.

Now user's come with a requirement of a separate type of report
everyday which has different fields. because of which i have to design
a report for them with the required query.

I was therefore wondering can i make a form which has two list boxes
the one on left side will have all the fields of the table (only
headers needed, not data).
Users can select multiple no. of fields from that list box which will
appear in another list box.
Users should be able to then select the order of fields, field for
sorting, report layout in landscape / portrait, paper size. and finaly
when they hit a button it should generate a report with the selected
fields.

Some one please guide my way through it.

I had problem in frst step itself ( Getting Table headers in list box)
List box displays only data.

Thanking in anticipation

 

[Tom van Stiphout]

On Wed, 25 Nov 2009 01:48:29 -0800 (PST), Rajtomar

While that may seem a good idea at first, very quickly you are
developing a Report Designer, and Access already has one. You could
not possibly write 10% of its functionality in a month.
So for those power users offer their own copy of Access, connecting to
the same back-end, so they can create their own reports. For everyone
else a good criteria form that offers some data filter and some sort
options is probably enough.

-Tom.
Microsoft Access MVP

 

[Rajtomar]

I quite appreciate your understanding and certainly that will be the
finest way to accomplish my task.

But If you can suggest me one more thing , it would become just
perfect -

If it is possible to place a command button on the form and on click
it should open the report wizard.
After the report is generated and is used for printing or saving
purpose, that report should be deleted from the database otherwise
such reports will kep adding to it

So if a code can remember the prestored reports name and just delete
any other report would be fine.

Thanks a lot

 

[John Spencer]

Take a look at

Customized report/query based on user input

You might want to consider the Query By Form applet at
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='DH Query By Form'


***FEATURES***

The DH QBF is a complete query by form applet that can be easily integrated
into any existing Access application. Typically, the functionality provided by
DH QBF can replace many "canned" reports. The developer imports several forms,
tables, a query, and a report from the DH_QBF.mdb, creates some master
queries, and deploys.

The developer creates one or more master queries that join tables, alias
field names, create calculated columns, etc. The users can then select a
master query (data source) from a drop-down and then select up to 30 fields
from the master query. Users can define sorting and criteria as well as
grouping and totaling. All of this "design" information is stored in two
tables for re-use.

The results of the queries are displayed in a datasheet subform contained in a
main form. The main form has options to send/export the records to print, Word
table, Word merge, Excel, HTML, CSV, Merge to Report, or a graph. Most formats
allow the user to automatically open the target application. The Word merge
process will open a new Word document and link to the merge fields.

--
Duane Hookom
MS Access MVP

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County