• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 481
  • Last Modified:

Multi-column Form

Hi,

Is it possible to create a form with 7 columns (one for each day of the week) where each column contains the same fields but displays the data for a particular day?  Could these be edited like a normal form?

Thank you!
0
Skip Sleeper
Asked:
Skip Sleeper
1 Solution
 
JimFiveCommented:
Sure, it's possible, but it may be more work than it's worth.

Method 1:
Use a table that has columns:
SundayDate, SundayInfo, MondayInfo, TuesdayInfo, WednesdayInfo, ThursdayInfo, FridayInfo, SaturdayInfo

And create a continuous form.

This method has ease of creation going for it but has normalization against it.  That is, it will be harder to create queries to find specific days based on this form.

Method 2:
Create a table with columns:
Date, DayInfo

Create an Unbound Form with the fields that you want.  In the OnOpen Event of the form use VBA to load data from the table.  Use AfterUpdate events on each data control to save any data changes.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
I have attached an example to get you started
1893311-Week.zip
0
 
Patrick MatthewsCommented:
I'm with JimFive on this one.

If your data model already has those as different columns, then this is both easy and desirable.  For example, if your table already has the week as its basic time period, with separate columns for each day of that week, then no "unnatural acts" are required.

On the other hand, if your data are stored such that 1 record = 1 day, then you are going to have to jump through a lot of hoops to make this happen.  My own opinion is that the game is not worth the candle.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Skip SleeperAuthor Commented:
Thank you for this amazing example!  If this is the start of the project it's beyond my meager skills at this point.  I'll keep the example for future use.  Thanks again!
0
 
Skip SleeperAuthor Commented:
highly skilled!
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Glad you liked the example. Sorry it was not what you were looking for (no points awarded).

As JimFive pointed out, this is possible but it will require you to be highly skilled at VBA.

Good luck with your project.

Boyd Trimmell, Microsoft Access MVP
aka HiTechCoach
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now