Solved

Report printing question

Posted on 2014-02-07
6
291 Views
Last Modified: 2014-02-08
I have a report which when previewed on screen looks fine.  The report has calculated fields that sum values from three different subreports.  But when I print the report to a printer, the calculated fields display as #Name?

What's up with that?

--Steve
0
Comment
Question by:SteveL13
[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
6 Comments
 
LVL 84
ID: 39841941
How are you printing to the printer? By that, I mean do you open the report in Preview mode, then print? Or do you select the report in the Nav Pane and "open" it? Or are you using code?
0
 
LVL 3

Accepted Solution

by:
suribaba801 earned 500 total points
ID: 39842025
I think the dialogue form is being closed from the 'Preview' command button (on the form) after the command to preview the report, so the data is not available if you wanted to print the report
0
 
LVL 84
ID: 39842272
I'm not quite clear on how the comment you accepted is relevant to the solution. You did not mention a dialog form, or how the data is being sourced.

Could you please clarify?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:SteveL13
ID: 39842474
I had this line of code after the code to open the report.  When I commented it out it worked fine.

DoCmd.Close acForm, "FrmTimeCardEntryHeader"
0
 
LVL 84
ID: 39843095
But you didn't provide us with the code, or the database, so we could not know how you're opening the report, or how the data is sourced.

In other words - how did the comment you selected tie in with the details of this question?

I've asked the Moderators to review.
0
 

Author Comment

by:SteveL13
ID: 39844138
I am truly sorry if I've done something wrong in regard to this question I posted.  When ID 39842025 was posted it led me to the solution.  

Again, if I have offended anyone with my awarding the accepted solution I apologize.

--Steve
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access Form - Default Value UDF(). How can the UDF() know what control did the call 3 18
ORDER BY 7 38
MS Access Error Handling 6 30
Email question 12 20
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

733 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