Solved

Access Form - Continuous - Display records and go to a second column

Posted on 2014-01-01
9
1,287 Views
Last Modified: 2014-01-04
Hello all,

Strange question but never know til I ask.  

Have a tabbed form.   On one of the tabs I have 2 subforms.  One subform has an input area for inputting the person's name or entity name as well as a listbox to show all names in the system already

The second subform shows all parties that I've input or selected for this record (Continuous Form).

Due to the length of those 2 subforms I can only get 3 or 4 lines on the 2nd subform to display and then the Scroll control shows.  However I have enough room on that 2nd subform that I could get 2 columns across and 3 to 4 rows each.

So, my question.  Is there some way to get a continuous form to display 4 lines tall and then go to a 2nd column and show 4 more lines?  I don't think it can, but I'm not very versed in this Access
0
Comment
Question by:wlwebb
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 333 total points
ID: 39749688
No. A Continuous form shows a single record at a time, and cannot be shown in "Columnar" view.

You could kludge up a form with multiple subforms - i.e. a form with two subforms side-by-side - and then embed that form in your main form, but keeping track of which record is showing in which subform would be a major PITA.
0
 

Author Comment

by:wlwebb
ID: 39749693
That's sort of what I concluded....  I'll leave open for a while longer to see if anyone else suggests anything different but your comment about multi subforms is all I could come up with too.  AND YES I agree that would be a major PITA
0
 
LVL 84

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 333 total points
ID: 39749899
You could also perhaps use a Grid control that's compatible with Access and work something out that way.

However, in my opinion, you might look into reformatting the parent and child forms to make better use of screen real estate. Of course, that's easy to say, but can be quite hard to do :) .

Good luck, and Happy New Year!!
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39749908
I think this might actually be doable... I was working a project where I was required to create a sub report for transactions by hour of day and I wanted to organize it across the page and wrap instead of in a single column. Here is a screen shot of the report:
screenshotI had fits with it because in looking at the report between the designer mode and the report view mode, it did not work BUT in print preview mode it does work.
Here is the Report View of the same subform:
screen shot2
Here is the design View:
screen3
I had to adjust the columns of the parent form as well as the size dimensions of the sub form MANY times before I was able to do what I wanted.

I hope this helps...
0
 

Author Comment

by:wlwebb
ID: 39749917
Technodweeb,
I'm not following.  Are you bringing a "Report" onto a Form?
0
 
LVL 11

Expert Comment

by:Gregory Miller
ID: 39749918
Ooops... got distracted mid read and had reports on my mind...
0
 
LVL 30

Expert Comment

by:hnasr
ID: 39750089
"go to a 2nd column and show 4 more line" needs clarification.

Upload a sample database and give a scenario to see the issue.
0
 
LVL 36

Accepted Solution

by:
PatHartman earned 167 total points
ID: 39750117
Sorry, Access forms do not support this but I wish they did.  I have found several situations where this would have been more convenient.

This doesn't sound like a place where multiple subforms would solve your problem but there are instances where that would work.  A time card for example.  There are only 7 days in the week so you would use 7 subforms; one for each day.  I have also used the technique for comparing things.  Think of those shopping web pages where you can select 5 items and see their specs side by side.  I did a form and a report like that to compare the details for up to 5 investment properties.
0
 

Author Closing Comment

by:wlwebb
ID: 39755792
Thanks all, your comments confirmed my conclusion...
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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.

820 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