Results 1 to 6 of 6
  1. #1
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78

    Printing receipt from an applciation

    Hi


    Firstly i wanted to ask if for printing a receipt the only option is to make a report and print it from it .
    And secondly what is the way to get informations on a form to print them with a therminal printer.
    I have tried Docmd.Printout "me.total.value" as an example but i keep getting an error message.
    how do i solve this problem
    Regards

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    as you have surmised, you need to create a report and print that.

    Providing your form is not to complex, you can easily copy it into a report object

    1. Open the form to be converted.
    2. Go File > Save As > Save Object As.
    3. click on Save the current database object>Save Object As.
    4. Enter the name for the report in the popup window.
    5. Change As from Form to Report.
    6. Click OK.


    regards printing to a thermal printer - just make it your default printer

    and by the way 'i keep getting an error message.' is sooo unhelpful. Laziness on your part to provide the information means we have to spend time asking or imagining which of the 10,000 errors you may be getting. Many will not bother (including me)- so you end up not getting responses.

  3. #3
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    Thanks Ajax but i m a bit confused.isn t it going to print it in A4 format that way,i have trid what you have told me but i don t get it rigth

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    in a report you can set the paper size - choose one that suits your printer, then move the controls around so they fit

  5. #5
    Business is offline Advanced Beginner
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2016
    Posts
    78
    i get you Ajax but i want to know if there are no other ways by manipulating codes.In fact i got an invoice form with fields.
    I arrange to make a change field where once clicked it s open the cash drawer and does the change calculation.I was wondering if i could do a module to call that is going to print the informations that are on the form once the change field is clicked.
    I guess it s possible but i wonder about the codings.

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    [QUOTE]I was wondering if i could do a module to call that is going to print the informations that are on the form once the change field is clicked.
    ...[
    ...I guess it s possible/QUOTE]You guess wrong, Not from the form - as previously advised, you need a report.

    Alternatively you can go a more complicated way and create a text file, update it with the values you want to print, save the file then send it to the printer.

    see these links or google 'access vba write to a text file' and 'access vba send text file to printer' to find more

    http://stackoverflow.com/questions/1...file-using-vba
    http://www.dbforums.com/showthread.p...-file-with-VBA

    Update - you may have guessed right - have just found this link which may be what you are looking for

    https://bytes.com/topic/access/answe...t-printer-port

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

Similar Threads

  1. Grocery receipt template
    By Kitchensock in forum Access
    Replies: 8
    Last Post: 10-06-2015, 03:53 PM
  2. Cash Receipt form
    By Newby in forum Forms
    Replies: 1
    Last Post: 03-09-2015, 11:50 AM
  3. Printing a receipt automatically
    By jalals in forum Programming
    Replies: 1
    Last Post: 04-17-2013, 03:53 PM
  4. Creating Incremental Receipt Numbers
    By JorgeCUC in forum Queries
    Replies: 15
    Last Post: 08-25-2011, 08:50 AM
  5. HELP with crazy receipt numbering
    By jlm722 in forum Forms
    Replies: 15
    Last Post: 09-23-2009, 01:49 PM

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