I have created POS application for my business that uses an Epson TM-U220 Series (Type B) receipt printer with tear off. I have formatted a report from my Access db as a receipt, but I need to send the hex string "1B69" in order to activate the paper cutter after the report prints.
How do I do that?
And when I give the print out some unknown characters keep on coming continuously which I had to switch off the printer to abort printing. What do you think is the reason. Is it something to do with the font size?
Soon I'll be starting a new DB which will be used to issue receipts to people who attend courses run by a business. I don't want or need it to be very complicated so was thinking a something like the following; TblClient (ID,client name & address fields) TblCourse (ID,Date, course name & Price fields)
Each client will eventually have numerous (many) Course records because they often complete more than one course, over many years. When I issue clients with Receipts I want each receipt to have a unique receipt number. On each receipt I will need the Client name, Price paid, date(s) & course name(s) with the unique receipt number. How can I impliment the receipt number?
I have a DB with a field named "rec #" That receipt number is made up of a date,a letter, a 4 digit number and a 3 digit number. That receipt number might look something like this 01012006P0002001
01012006 date P letter 0002 4 digit number 001 3 digit number
What I want to do is to split this receipt number into the individual parts and create a field for each part. Can someone help me ?
We have an Access database that opened some cash drawers attached to the computer through USB and it is working perfectly. We have some of the cash drawers that are attached to the EPSON Receipt printer and we also want to open those Cash Drawers attached to the receipt printer. Looking for code to open the cash drawer attached to the receipt printer, Is there any command available that I could send to the receipt printer and it would open the Cash Drawer.
I have also taken the screenshot of the utility program that will show the information regarding the printer and I am very expecting to get this working soon as we have build the Microsoft Access database that would checking the cash drawer status and also open the USB cash drawers.
How to use combo box that drops down the date received from which the user can select todisplay "receipt form" on and after that date. [need to use macro]
I was having trouble just setting each report with a particular print method - for some reason they just kept forgetting their individual settings and resorting to default on the machine.
This meant reports were printing on the wrong paper, or the wrong size paper, the wrong orientation and some times refusing to print if it couldn't find the paper (which is useful in runtime as it doesn't display error messages)
So I used Reports(rpt).printer properties (I forgot where I found this) to hard code the printer properties into each print command... this meant I had to use another function to insert the variables.
So all I had to do was say:
Code: PrintMe("Invoice","InvoiceID",iID)
and a report would print to exactly how I wanted... but it's just too slow!
See attached for full code, I have a niggling feeling it may be the function: PrinterOK, to make sure the printer exists or not.
Code: Function PrinterOK(sPrinterName As String) As Boolean Dim MyPrinter As Printer PrinterOK = False For Each MyPrinter In Printers If MyPrinter.DeviceName = sPrinterName Then PrinterOK = True Exit Function End If Next End Function
I know it's the printing code, because if I stop the printing and just preview then it shows up almost instantly.
Hey all, I have a problem I was hoping that someone could help me with. I am trying to add my digital signature to my report. Since I have added an activeX Control to my form which display and stores my signauture, I would like to display it on my report as well (if it apperas with the record) So I added it like any other control to the report but when it is saved it is letters and numbers, so I have to make it back into a digital signature. Can anyone help me.Thanks
I just started using A2003 and find the Dependancies feature very useful. However, I can't figure how to print them other than by doing screen shots. Is there any way to print the dependancies?
When i go into print preview on all my existing forms the information is displayed over the 'x' amount of pages it covers. I have created a new form and when i go into print preview it only displays a blank page.
I have a form which has a "Printing Button" The printing button has to print (through a macro) a report that I created based on the form's information. Now, it works perfect on the PC I work on (which has ACCESS 2007), but it gives me an error when hitting the same button from a PC using the runtime version (with no ACCESS 2007 installed).
The error is: The command or action 'Print' isn't available now.
The code of the macro that executes when hitting the button is:
How Come When I Change The Page Setup To Landscape In A Querrie.. Then Hit File Save...when I Close And Reopen This Querrie And Go To Print Preview It Is Still In Portrait Mode
Hi, How do i create an option inside the form, such that when the user ticks this option, it will print the form in this particular report. If user ticks another option, it will print the form in another particular report format... Thanks...
If you have a Print button on your form where you add records, can you set a specific font and background colour when you print or does it have to be the same as what's on your form? I have a red background on my form but I want to print just the text and in black and white.
Could anyone give some assist on how to print only the subform in a form. I'm looking to create a print preview command button that will allow only the sub form to be printed... Thanks for the assist.....
I have a form with multiple subforms. When I hit print selected record I get a blank sheet of paper. What could be set to not allow the data or the background of the form to print?
If I just print the subform out by itsself it works good. However when I have the main form open then try to print I get blank pages.
I am sure someone changed a fairly small setting, but I do not know what has been changed. Thanks.
I have a command button that brings up a report on my form. After the report comes up and the users has viewed it and printed it, I want a message box to come up saying "Are you done with the report." But when I set up the message box it comes up right after the report comes up. And the user is force to make a decision before its able to do anything. Is there a way to insert something in VB between the DoCmd.Open Report and my message box to tell the message box, wait until the user has hit the print button?
Hi, I have a form with some fields on it.. it's a subform. It has multiple rows. Is there any way I can print the rows as in a report. I Dont know how to pass the subforum values from the form to the printer? I tried the print table macro but it prints the whole table data and not just the data in the subform
:eek: When I go to print the form, it repeats the detail section over and over. Instead of being one page, it is 1414. How can I fix this problem? Thanks
I have my subform on my main form and when I press the print button that I created it prints the main form 200 times due to the amout of records in the table.
When I open the subform by its self then press the print button that I created it will print what I want, the subform only. Please help!! I want to print this subform from the main form.
I have a report in access. I have designed the report such that. When a user wants to print there is a prompt for the user to enter the order number.The report displays all the orders for that order number.A number is assigned for that print out.This number is unique for every order number the user enters.
How do i capture the generated print out NUMBER, store it in a table so that when there is another printing for the same order number No NEW PRINT OUT NUMBER is displayed.The user should also be prompted that he/she is printing an already printed orders. However in case of a new order number, the generated print out number should be differnt which should also be stored for future refencing.
I have what is hopefully a quick question. I am writing a simple program for my credit union to generate the paperwork for mortgages. Everything works with one small exception. Ther are two documents (actually Word Templates) that need to print on the front and back side. The credir union has an HP Laserjet 4P with a duplexing unit.
What I need to know is how to send commands to cause the duplex printing. Do you know how to do this or can you point me in the right direction on how to find this answer. I am including the relevant code for this section below, which works perfectly in every other aspect, just can't figure out how to get it to duplex.
I've created a form that contains 4 different subforms. Each subform carries behind it various calculations that display as totals on the form. If i print one of these subforms there are no difficulties at all in all the totals printing. However, when I print the main form all the totals within the subforms do not show up, even though they are displaying during the print preview and form view. Any ideas on how to correct this?
