If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Multi-column form
Hi
I have a query (which I have also done as a 'make-table' - if that makes it easier) that I want to display on a form. The fields are Assistant, Sales, Qty etc and I would like to display them in this format: Assistant 10 11 12 13 Sales 250 125 350 400 Qty 2 5 11 6 Can anyone help me, please. I have spend the last two days trying to get it right! Cheers. |
#2
|
|||
|
|||
Multi-column form
I have done this before using multiple subforms across the form. It requires
opening a recordset to place primary key values into hidden text boxes on the form. These text boxes are used as the link master property of the subform controls. -- Duane Hookom MS Access MVP -- AndyB wrote in message ... Hi I have a query (which I have also done as a 'make-table' - if that makes it easier) that I want to display on a form. The fields are Assistant, Sales, Qty etc and I would like to display them in this format: Assistant 10 11 12 13 Sales 250 125 350 400 Qty 2 5 11 6 Can anyone help me, please. I have spend the last two days trying to get it right! Cheers. |
#3
|
|||
|
|||
Multi-column form
Thanks Duane.
The strange thing is that I've set up a multi-column report that is fine - and looks as I want - but when I embed it as a sub-report into another report, it loses its formatting and becomes a single column down the left-hand side. Do you know why this is? Would it be easier to do this as a form, rather than a report? Thanks for your help Andy. "Duane Hookom" wrote in message ... I have done this before using multiple subforms across the form. It requires opening a recordset to place primary key values into hidden text boxes on the form. These text boxes are used as the link master property of the subform controls. -- Duane Hookom MS Access MVP -- AndyB wrote in message ... Hi I have a query (which I have also done as a 'make-table' - if that makes it easier) that I want to display on a form. The fields are Assistant, Sales, Qty etc and I would like to display them in this format: Assistant 10 11 12 13 Sales 250 125 350 400 Qty 2 5 11 6 Can anyone help me, please. I have spend the last two days trying to get it right! Cheers. |
#4
|
|||
|
|||
Multi-column form
AndyB wrote:
Thanks Duane. The strange thing is that I've set up a multi-column report that is fine - and looks as I want - but when I embed it as a sub-report into another report, it loses its formatting and becomes a single column down the left-hand side. Do you know why this is? Would it be easier to do this as a form, rather than a report? Thanks for your help Andy. Subreports have no concept of "pages". Pages are the responsibility of the parent report. A multi-column report that is set up as "Down, Then Across" will start a new column at the bottom of the *page* and a subreport has no idea where that is so you get one long column. Basically multi-column subreports only work when set up as "Across, Then Down" or when the subreport control has CanGrow set to false. Then the bottom of the control will take the place of the bottom of the page. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
#5
|
|||
|
|||
Multi-column form
Great explanation Rick.
-- Duane Hookom MS Access MVP -- "Rick Brandt" wrote in message m... AndyB wrote: Thanks Duane. The strange thing is that I've set up a multi-column report that is fine - and looks as I want - but when I embed it as a sub-report into another report, it loses its formatting and becomes a single column down the left-hand side. Do you know why this is? Would it be easier to do this as a form, rather than a report? Thanks for your help Andy. Subreports have no concept of "pages". Pages are the responsibility of the parent report. A multi-column report that is set up as "Down, Then Across" will start a new column at the bottom of the *page* and a subreport has no idea where that is so you get one long column. Basically multi-column subreports only work when set up as "Across, Then Down" or when the subreport control has CanGrow set to false. Then the bottom of the control will take the place of the bottom of the page. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |