Results 1 to 4 of 4
  1. #1
    loveyeshu is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    2

    Report from a Form to create an invoice of the record shown in the form


    I am using a web based Access 2013 Database. I have successfully created an invoice report that opens when I click a button on a form. I need to either be able to 1. Print just the open Form or reference the Purchase Order Number from the form to the Report to be printed.

    Because this is a web based database, none of the wizards work. I Just need to print this Purchase Order Form. Can anyone PLEASE help me

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    Mean you need to print the Purchase Order report?
    Should be able to modify the working macro to include filter criteria. The parameter would reference the form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    loveyeshu is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Jan 2015
    Posts
    2
    I am an Access noobie. Filter Criteria is stumping me. I am guessing that is the "Where Condition". I have the report linked to the form easy enough, however the data in there is from 1 record ( not the one I have open and am trying to print). Any advice on figuring out the conditions and how to reference the right tables or reports to print out the correct purchase order on the report would be super helpful. Thank you.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,931
    I don't use macros and never built web db. I have only worked with web dbs posted to forum. Sometimes I can figure out but need the db. If you want to provide, follow instructions at bottom of my post.

    Yes, "Where Condition". Exactly what do you have in the argument?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 06-26-2014, 06:50 AM
  2. Replies: 5
    Last Post: 04-04-2014, 03:33 PM
  3. Edit record in form with original entry shown
    By erknoebe in forum Access
    Replies: 5
    Last Post: 09-29-2010, 02:33 PM
  4. Entire form not shown in form view
    By ksmall1998 in forum Forms
    Replies: 12
    Last Post: 09-22-2009, 06:38 AM
  5. Replies: 1
    Last Post: 03-02-2009, 11:54 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums