UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Report Subform Parts, Access 2013    
 
   
xjohnson
post May 23 2019, 02:14 PM
Post#1


Utterly Banned
Posts: 37
Joined: 6-October 18



Hello,

On my form AFRs there is a 'Preview AFR' button to show the report for 'AUTHORIZED FIELD RETURN'. On the report I attempted putting the parts associated with this AFR Number.

The subform has the parts listed and quantities but I don't know how to make it 2 columns to allow for maximum 30 parts. Also a way to put 'Qty' and 'Part Number' above the parts.

Can someone please help?

Thank you
Go to the top of the page
 
June7
post May 23 2019, 05:08 PM
Post#2



Posts: 614
Joined: 25-January 16



For multi-column subreport, review https://social.msdn.microsoft.com/Forums/of...rt-with-columns

Put subreport labels in its report header and set header to Visible Yes or use label controls on main form to show "Qty" and "Part Number".

This post has been edited by June7: May 23 2019, 05:12 PM

--------------------
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
DEBUG! DEBUG! DEBUG! http://www.cpearson.com/Excel/DebuggingVBA.aspx
Go to the top of the page
 
xjohnson
post May 23 2019, 05:16 PM
Post#3


Utterly Banned
Posts: 37
Joined: 6-October 18



Thank you I will try tomorrow morning
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    25th June 2019 - 12:48 PM