Solved

Multi-column Form

Posted on 2013-12-11
6
464 Views
Last Modified: 2013-12-12
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
Comment
Question by:Skip Sleeper
6 Comments
 
LVL 15

Accepted Solution

by:
JimFive earned 500 total points
ID: 39712600
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
 
LVL 21
ID: 39713093
I have attached an example to get you started
1893311-Week.zip
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 39713959
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Skip Sleeper
ID: 39714013
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
 

Author Closing Comment

by:Skip Sleeper
ID: 39714034
highly skilled!
0
 
LVL 21
ID: 39714498
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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question