none
Print directly from code RRS feed

  • Question

  • I wrote a client tracking app for our local foodbank in access 2007/2010.  We would like to implement a barcode scanner into the intake process which would speed up intake.  The idea is to issue an ID card or use DL. What I would like to do is have the client scan his/her id card and  have the after update event automatically (via code) record the vist in our vist database and then automatically print out a pass to the food line on a reciept printer. Currently we record visits via a cmd button on our intake form and we hand write the pass with the date and family size.  I understand how to scan the Id into a field on a form and I have figured out how to record the visit automatically.  What I can't figureout is how to then automatically output the foodline pass (report) directly to the printer and then reset the form for the next client.  Any suggestions?

    Bruce L. Amer

    Saturday, March 24, 2012 7:53 PM

Answers

  • Bruce,

    Try starting here:

    http://www.granite.ab.ca/access/barcode.htm


    HTH, Bernie

    Sunday, March 25, 2012 2:23 PM
  • Hi Bruce

    First open the report you want to print invisible, just containing the record you want to print.
    Then use the DoCmd.Printout method to print the still invisible record and then close the report
    If done you can switch the form into the DataEntry mode which then is an empty form ready to input data.

    HTH
    Henry

    Bruce Amer wrote:

    I wrote a client tracking app for our local foodbank in access 2007/2010.
    We would like to implement a barcode scanner into the intake process
    which would speed up intake. The idea is to issue an ID card or use DL.
    What I would like to do is have the client scan his/her id card and have
    the after update event automatically (via code) record the vist in our
    vist database and then automatically print out a pass to the food line on
    a reciept printer. Currently we record visits via a cmd button on our
    intake form and we hand write the pass with the date and family size. I
    understand how to scan the Id into a field on a form and I have figured
    out how to record the visit automatically. What I can't figureout is how
    to then automatically output the foodline pass (report) directly to the
    printer and then reset the form for the next client. Any suggestions?

    Monday, March 26, 2012 4:12 AM

All replies

  • Bruce,

    Try starting here:

    http://www.granite.ab.ca/access/barcode.htm


    HTH, Bernie

    Sunday, March 25, 2012 2:23 PM
  • Hi Bruce

    First open the report you want to print invisible, just containing the record you want to print.
    Then use the DoCmd.Printout method to print the still invisible record and then close the report
    If done you can switch the form into the DataEntry mode which then is an empty form ready to input data.

    HTH
    Henry

    Bruce Amer wrote:

    I wrote a client tracking app for our local foodbank in access 2007/2010.
    We would like to implement a barcode scanner into the intake process
    which would speed up intake. The idea is to issue an ID card or use DL.
    What I would like to do is have the client scan his/her id card and have
    the after update event automatically (via code) record the vist in our
    vist database and then automatically print out a pass to the food line on
    a reciept printer. Currently we record visits via a cmd button on our
    intake form and we hand write the pass with the date and family size. I
    understand how to scan the Id into a field on a form and I have figured
    out how to record the visit automatically. What I can't figureout is how
    to then automatically output the foodline pass (report) directly to the
    printer and then reset the form for the next client. Any suggestions?

    Monday, March 26, 2012 4:12 AM
  • Henry,

    Thanks for the suggestion I am going to work on this strategy tonight  It really helps to have a dfew ideas to follow up on and get you goig.

    Bruce


    Bruce L. Amer

    Wednesday, April 4, 2012 2:15 PM
  • Bernie

    Thanks for the link.  It really helped


    Bruce L. Amer

    Wednesday, April 4, 2012 2:16 PM