Skip Sleeper
asked on
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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!
ASKER
highly skilled!
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
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
1893311-Week.zip