Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Heading #Name? Error when print (2000)

    I have a report that is called from a form that is set up like a dialog box. When they open the form, they make some selections, A machine name and then a start date and end date. They click on a button and it calls the report that is based on a query.

    In the report header I have an unbound text box where I want the dates that were selected to print. Here's the command: ="Between the dates of " & [Forms]![frmTotalMoneyExpendedbyMachDialog]![cboBegDate] & " & " & [Forms]![frmTotalMoneyExpendedbyMachDialog]![cboEndDate]

    When the report is run and is on the screen I see the dates and they are correct. But when I print the report, the printed result has the #Name? error. I did some searching in help and it told me to check syntax and names and I have and can't find anything wrong there. Then it said to find this file Msowcf.dll. I do have it on my machine located at crogram filesmicrosoft officeoffice.

    I'm at a loss.
    Thanks,
    Deb

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Heading #Name? Error when print (2000)

    I would suspect that the form with the machine name, start date and end date has closed.

  3. #3
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Heading #Name? Error when print (2000)

    I do close the form. So I'm assuming from your statement I have to leave the form open?

    Thanks,
    Deb

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Heading #Name? Error when print (2000)

    Yes, if you want to get the info off the form you need it open.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Report Heading #Name? Error when print (2000)

    You have to leave it open until your report has closed because you can only reference a form's controls while the form is open. One way to handle this is to set the visible property of the form to False when you open the report and then in the Report_Close event, test to see if the form is still loaded and if it is, close it. If you need any help with that, let us know.
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Oct 2002
    Location
    Sayre, Pennsylvania, USA
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Heading #Name? Error when print (2000)

    That fixed it. Thanks once again.

    Deb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •