Bound Denormalized Form (1 Viewer)

[Pat Hartman]

I've left the old versions here but ALWAYS go to the last post to get the current version.

This database contains two examples (using the same technique) of how to take data that is properly normalized and display it so that it looks like a spreadsheet (rows displayed as columns) but is actually updateable. The technique uses a separate subform for each column so it is limited but works well for 12 months. I don't know what a practical limit might be. You'll need to experiment.

 

[Pat Hartman]

Here's an updated version along with some documentation. I also added a report built using a variable crosstab. The technique creates an intermediate table to hold the column header values and assign them a number from 1 to x (width of report - probably not more than 20).

I updated the downloads and added some documentation.

 

[isladogs]

Hi Pat
Thanks for the update some six years after the original example.
I've only just spotted and approved your new post. As I'm sure you know, mods aren't informed when a post is made to this area.
Please see sticky thread about reporting your own post as that usually triggers a faster response.

 

[Pat Hartman]

Bump

 

[Pat Hartman]

Did some clean up work for a presentation. Fixed the sort, fixed the combo to only show expenses not yet selected. Updated the documents to match the current form versions.

 

[Pat Hartman]

Thanks for the link George. Here's a video of a presentation I did on the sample.