?
Solved

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

Posted on 2014-01-01
9
Medium Priority
?
1,321 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1332 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 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 1332 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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 38

Accepted Solution

by:
PatHartman earned 668 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

762 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