Bound Denormalized Form (1 Viewer)

Status
Not open for further replies.

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:45
Joined
Feb 19, 2002
Messages
42,970
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.
 

Attachments

  • BoundDenormalizedForm130810.zip
    1.5 MB · Views: 1,844
  • BoundDenormalizedForm_20210319.zip
    1.5 MB · Views: 433
Last edited:

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:45
Joined
Feb 19, 2002
Messages
42,970
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.
 

Attachments

  • Bound Denormalized Forms.pdf
    351 KB · Views: 430
  • BoundDenormalizedForm_20210319.zip
    1.5 MB · Views: 439
  • HowToUseVariableReport.zip
    186.2 KB · Views: 461
Last edited:

isladogs

MVP / VIP
Local time
Today, 13:45
Joined
Jan 14, 2017
Messages
18,186
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.
 
Last edited:

Pat Hartman

Super Moderator
Staff member
Local time
Today, 09:45
Joined
Feb 19, 2002
Messages
42,970
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.
 

Attachments

  • Bound Denormalized Forms_DocsOnly20231005.zip
    817.8 KB · Views: 83
  • BoundDenormalizedForm_20231005.zip
    1.6 MB · Views: 103
Status
Not open for further replies.

Users who are viewing this thread

Top Bottom