Solved

Multi-column Form

Posted on 2013-12-11
6
458 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:fargus47
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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:fargus47
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:fargus47
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now