Results 1 to 5 of 5

Thread: Query by Form

  1. #1
    Join Date
    Jan 2004
    Posts
    77

    Unanswered: Query by Form

    "I have a Query By Form setup (based on Ken Getz QBF.exe routine) -- it works great. I have one more wish. Is it possible to print the result of the QBF to a specified report?"

    I have this working somewhat. I have a PRINT (preview) button that captures the QBF data. However, I had to place the PRINT button on the same screen/form as the VIEW button. I would like is to have the PRINT button appear only on the VIEW screen (i.e., after the VIEW button has been clicked). That way, once someone has processed a query, if they decied to print it, they don't have to go back to the QBF screen.

    I have attached a small sample of my DB. Any suggestions would be greatly appreciated.

    Thanks,
    SKK
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Create a report and set up your print button so that it uses the same filter as the form's current filter.
    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

  3. #3
    Join Date
    Jan 2004
    Posts
    77
    That's exactly my problem. Not being a programmer, I was unsuccessful - it defaulted to the entire table, not my queried data. I'm not sure if you looked at my example attachment but I'm hoping I'm on the right track. Again, any suggestions would be appreciated.

    Thanks,
    SKK

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Yes, I looked at your file

    You've given me only the starting point ... like the "before" view, you've given me what you want but you haven't given me any clue as to WHY you've failed in your attempts.

    The open command for the report simply needs to pass the filter along from the form... ie

    DoCmd.OpenReport "ReportName", , , Me.Filter
    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

  5. #5
    Join Date
    Jan 2004
    Posts
    77
    OKAY I will try this.

    Again - Thanks,
    SKK

Posting Permissions

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