Rearrange tabular frm/rpt on the fly

[TruthAndBeauty]

Say I have a canned, 20 column tabular form/report. The user wants a simple GUI that allows them to rearange the report. The users doesn't want to design or create a newform/ report they just want a subset or different view of this one.

The users get .mde or .ade files.

Simply letting the user select a check box to hide the column doesn't remove the space the column was occupying nor does it allow for rearranging.

I can build a form where the user can select field in the order they want them displayed but I don't know how to tell MSAccess to use the field to construct a form or report automatically.

Any help? Thanks
Thanks

 

[BobJacksonNCI]

If Tools / Office Links / Analyze It With MS Excel is available, how about letting the users customize as they desire? Or, Tools / Office Links / Publish it with MS Word?

Those allow MS Office users to customize to their hearts content without risk to your database.

Bob

 

[MichaelRed]

Thread703-481600.


If you can get the list of "fields" to be displayed by the user from somewhere, you can create a known/named recordset and then use the concept shown in hte ref thread to create a report. With 20 fields, I'm sure you will need to make large 'adjustments' to the details, but the concept is o.k. for simple tabular reports. To support sorting/grouping totals, subtotals or even varying field widths, you would need to extend the simple sample.




MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[TruthAndBeauty]

Not sure what" concept shown in hte ref thread to create a report" your referring to unless it's the "Tools / Office Links / Analyze". I havenot played with this before and I'm exploring the Office link idea now.
----------------------
I work with recordsets; however, I know how to populate a report but I don't know how to create (format) a report on the fly so that the format is sized for the columns requested. My users are no interested in getting "technical" which meansit must be quick and easy to use.

---------------------------------------
Do you see any problem using the datasheet form??

I created a form1 with a datasheet subform1.
The datasheet contains the 20 columns of data with headers.
I saved the .mdb to a .mde

I opened the .mde and the form1(with subform1)

I discovered that the user can drag and drop columns.resize columns, freeze columns and filter columns.

The user can also select Format on the menu bar and select hide-columns, unhide-columns, sort, and remove horizontal and vertical lines, just to name a few.

I'm thinking I cana use the main form to provide a place to enter addtional criteria and operator (such as <,>, between, such as a start-stop data range).

If I limit the number of columns to the max number that will fit on a landscape page I wont have the problem of the users not finding the 10+ fields far out on the right scroll.

 

[BobJacksonNCI]

I frequently take an existing Access report and use
Tools / Office Links / Analyze It With MS Excel ...

I'm posting here because I've primarily transferred report information to Excel, so I don't have much experience exporting query results to Excel...

But I DO recommend you try that out, especially if your users are comfortable with Excel - it IS quick and easy!

 

[BobJacksonNCI]

Just tested - the process works great with queries.

If your users are comfortable with Excel, this lets you give them the data and get back to your latest crisis.

Bob

 

[TruthAndBeauty]

Thanks,
I'm going to give it a try.