Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2007

    Unanswered: Error on Print Preview

    Hi All

    I have a database that I use to create furniture budget from data extracted from AutoCAD. I have used it for over a year now and I just tried using it today and I am getting an error message which I cannot seem to resolve. I am attaching a screen shot of the error message I am getting. Basically, the user selects the report type they want by select a predefined form. Next they are requested to select a project and select the Run Report button. Another dialog box displays allowing them to select the phase by entering a value and pressing the Ok button. As soon as that is done, I get the error message. This had never happened before. Any help is greatly appreciated. If necessary I can post the a portion of the database. Thank you.

    Attached Thumbnails Attached Thumbnails screenshot.png  

  2. #2
    Join Date
    May 2009
    From Microsoft Access Re: SetValue action in a Macro:
    Quote Originally Posted by Ken Snell
    You cannot use SetValue action to set the value of a control in a report. Reports do not allow you to change the value of controls from outside the report.

    What you need to do is use a query for the report that returns all... [projects'] data records, then filter the report (OpenReport action, Where argument) to show just the records for the desired... [project] value. Then be sure to bind that textbox in the report to the... [project] field.

  3. #3
    Join Date
    Dec 2004
    Madison, WI
    If nothing has changed code-wise, you may also want to check if anything has changed regarding the default printer or printer driver for that/those specific users which are getting the error.
    Last edited by pkstormy; 09-17-09 at 19:40.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Ahh macros, the scourge of a good database ^^
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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