A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Print



 
 
Thread Tools Display Modes
  #1  
Old August 31st, 2004, 07:49 PM
Taher
external usenet poster
 
Posts: n/a
Default Print

Hi there

I am the same guy who is having trouble with printing
textbox on the last new page of report. If you can see my
last two posting both with Print heading you will get what
the issue is. Also i tried the force new page property but
it does not work with my form. I am sending you the sql of
my report, and i would appreciate if somebody could help
me with this.

SELECT DISTINCT [REPORT QUERY SUPPORT].P_Name, [REPORT
QUERY SUPPORT].O_Name, [REPORT QUERY SUPPORT].I_Name,
[REPORT QUERY SUPPORT].LOB_Name, [REPORT QUERY
SUPPORT].OU_Name, [REPORT QUERY SUPPORT].CM_Name, [REPORT
QUERY SUPPORT].TDCM_Date, [REPORT QUERY
SUPPORT].CM_ReportSort, [REPORT QUERY
SUPPORT].CM_Audience_Type, [REPORT QUERY
SUPPORT].CM_Value_Type, [REPORT QUERY
SUPPORT].O_ReportSort, [REPORT QUERY
SUPPORT].I_ReportSort, [PROGRAM SIGN OFF].S_SignAnswer,
[REPORT QUERY SUPPORT].DDCM_Start_Date, [REPORT QUERY
SUPPORT].DDCM_End_Date, [REPORT QUERY
SUPPORT].DDCM_Baseline_Nominal, [REPORT QUERY
SUPPORT].DDCM_Goal_Nominal, [REPORT QUERY
SUPPORT].DDCM_Baseline_Percent, [REPORT QUERY
SUPPORT].DDCM_Goal_Percent, [REPORT QUERY
SUPPORT].Jan_Nominal, [REPORT QUERY SUPPORT].Feb_Nominal,
[REPORT QUERY SUPPORT].Mar_Nominal, [REPORT QUERY
SUPPORT].Apr_Nominal, [REPORT QUERY SUPPORT].May_Nominal,
[REPORT QUERY SUPPORT].Jun_Nominal, [REPORT QUERY
SUPPORT].July_Nominal, [REPORT QUERY SUPPORT].Aug_Nominal,
[REPORT QUERY SUPPORT].Sep_Nominal, [REPORT QUERY
SUPPORT].Oct_Nominal, [REPORT QUERY SUPPORT].Nov_Nominal,
[REPORT QUERY SUPPORT].Dec_Nominal, [REPORT QUERY
SUPPORT].Jan_Percent, [REPORT QUERY SUPPORT].Feb_Percent,
[REPORT QUERY SUPPORT].Mar_Percent, [REPORT QUERY
SUPPORT].Apr_Percent, [REPORT QUERY SUPPORT].May_Percent,
[REPORT QUERY SUPPORT].Jun_Percent, [REPORT QUERY
SUPPORT].Jul_Percent, [REPORT QUERY SUPPORT].Aug_Percent,
[REPORT QUERY SUPPORT].Sep_Percent, [REPORT QUERY
SUPPORT].Oct_Percent, [REPORT QUERY SUPPORT].Nov_Percent,
[REPORT QUERY SUPPORT].Dec_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Percent, [PROGRAM SIGN
OFF].Source_document
FROM [REPORT QUERY SUPPORT] LEFT JOIN [PROGRAM SIGN OFF]
ON ([REPORT QUERY SUPPORT].P_Name = [PROGRAM SIGN
OFF].P_Name) AND ([REPORT QUERY SUPPORT].TDCM_Date =
[PROGRAM SIGN OFF].S_Date);

Thank you.
  #2  
Old August 31st, 2004, 09:07 PM
Marshall Barton
external usenet poster
 
Posts: n/a
Default

If you have nothing else in the report footer section beside
the signoff text box, then setting the report footer
section's ForceNewPage property to Before Section should be
all you need.

If you have other data displayed in the report footer
section then add a Page Break control just above the signoff
text box.

I would also consider using DLookup in the signoff text box
instead of messing with every report's record source query.
Assuming that P_Name is a text field and TDCM_Date is a date
field:

=DLookup("Source_document", "PROGRAM SIGN OFF",
"P_Name=""" & txtPName & """ And S_Date = #" & txtTDCMDate &
"#")

where txtPName and txtTDCMDate are the names of the report
text boxes bound to the P_Name and TDCM_Date fields.
--
Marsh
MVP [MS Access]



Taher wrote:
I am the same guy who is having trouble with printing
textbox on the last new page of report. If you can see my
last two posting both with Print heading you will get what
the issue is. Also i tried the force new page property but
it does not work with my form. I am sending you the sql of
my report, and i would appreciate if somebody could help
me with this.

SELECT DISTINCT [REPORT QUERY SUPPORT].P_Name, [REPORT
QUERY SUPPORT].O_Name, [REPORT QUERY SUPPORT].I_Name,
[REPORT QUERY SUPPORT].LOB_Name, [REPORT QUERY
SUPPORT].OU_Name, [REPORT QUERY SUPPORT].CM_Name, [REPORT
QUERY SUPPORT].TDCM_Date, [REPORT QUERY
SUPPORT].CM_ReportSort, [REPORT QUERY
SUPPORT].CM_Audience_Type, [REPORT QUERY
SUPPORT].CM_Value_Type, [REPORT QUERY
SUPPORT].O_ReportSort, [REPORT QUERY
SUPPORT].I_ReportSort, [PROGRAM SIGN OFF].S_SignAnswer,
[REPORT QUERY SUPPORT].DDCM_Start_Date, [REPORT QUERY
SUPPORT].DDCM_End_Date, [REPORT QUERY
SUPPORT].DDCM_Baseline_Nominal, [REPORT QUERY
SUPPORT].DDCM_Goal_Nominal, [REPORT QUERY
SUPPORT].DDCM_Baseline_Percent, [REPORT QUERY
SUPPORT].DDCM_Goal_Percent, [REPORT QUERY
SUPPORT].Jan_Nominal, [REPORT QUERY SUPPORT].Feb_Nominal,
[REPORT QUERY SUPPORT].Mar_Nominal, [REPORT QUERY
SUPPORT].Apr_Nominal, [REPORT QUERY SUPPORT].May_Nominal,
[REPORT QUERY SUPPORT].Jun_Nominal, [REPORT QUERY
SUPPORT].July_Nominal, [REPORT QUERY SUPPORT].Aug_Nominal,
[REPORT QUERY SUPPORT].Sep_Nominal, [REPORT QUERY
SUPPORT].Oct_Nominal, [REPORT QUERY SUPPORT].Nov_Nominal,
[REPORT QUERY SUPPORT].Dec_Nominal, [REPORT QUERY
SUPPORT].Jan_Percent, [REPORT QUERY SUPPORT].Feb_Percent,
[REPORT QUERY SUPPORT].Mar_Percent, [REPORT QUERY
SUPPORT].Apr_Percent, [REPORT QUERY SUPPORT].May_Percent,
[REPORT QUERY SUPPORT].Jun_Percent, [REPORT QUERY
SUPPORT].Jul_Percent, [REPORT QUERY SUPPORT].Aug_Percent,
[REPORT QUERY SUPPORT].Sep_Percent, [REPORT QUERY
SUPPORT].Oct_Percent, [REPORT QUERY SUPPORT].Nov_Percent,
[REPORT QUERY SUPPORT].Dec_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Nominal, [REPORT QUERY
SUPPORT].TDCM_Target_Variance_Percent, [REPORT QUERY
SUPPORT].TDCM_Target_Percent, [PROGRAM SIGN
OFF].Source_document
FROM [REPORT QUERY SUPPORT] LEFT JOIN [PROGRAM SIGN OFF]
ON ([REPORT QUERY SUPPORT].P_Name = [PROGRAM SIGN
OFF].P_Name) AND ([REPORT QUERY SUPPORT].TDCM_Date =
[PROGRAM SIGN OFF].S_Date);

Thank you.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I print the details view David Running & Setting Up Queries 5 August 28th, 2004 12:17 AM
Can't print from MS Office Programs AL General Discussions 0 August 4th, 2004 11:33 PM
Can't Print Frames? Bart Van der Donck Outlook Express 0 May 31st, 2004 11:08 AM
Print Reports Bill Setting Up & Running Reports 2 May 26th, 2004 02:57 AM
Excel Printing Annette Worksheet Functions 2 October 17th, 2003 01:14 AM


All times are GMT +1. The time now is 01:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.