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!
Skip SleeperIT ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
JimFiveConnect With a Mentor Commented:
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
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Skip SleeperIT ManagerAuthor 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 SleeperIT ManagerAuthor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.