VB

The PC runs on windows XP. There are multiple printers connected to the PC. One of these printers is a receipt printer, model: Epson TM-U220. Attached to this receipt printer is a cash box that needs to be open when there is a cash transaction. The computer (MS Access) will send code to the printer: chr(27)+’p’+chr(0)+chr(100)+chr(25) and the printer will give command to open the cash box. budget :$35 timeline : 2 days ........................................... Also, with your solution, there will be an additional customer pole (customer display) attached to it. The customer pole will display text lines, like “Company Name”, “Welcome” Once there is a cash transaction, the pole display will display like, “Total: $XXX”; “Paid:$xxx” “Change: $xxx (if any)” After the transaction, the display reverts to above, company name. The Program I am running is Microsoft Access 2007 (MS Access). I need to have procedures written in Visual Basic codes, called from “forms” or command buttons, or macro from MS Access to do the things mentioned above: 1. For cash transactions, the procedure would be able to send the required string of codes to the printer to open the cash box. 2. For all sales transaction, whether cash, visa, nets ..., to send the text to the pole register. I therefore do not think you need any sample receipt because that is already covered in my MS Access program. This also includes if necessary how to configure the PC to accept the equipment that I am connecting to the computer; the printer and the customer pole. i. The printer should be okay because it is now already printing receipts from MS Access. ii. The customer pole is a new one that I purchased and it is supposed to be connected to a serial port, but my pc does not have one. Also, I do not want it to be connected to a serial port. I have a cable that receives rs232 connector at one end and usb at the other end, and therefore the customer pole is connected to a free usb port on the PC. Is the requirement clear? Do you have any questions? If this is clear and acceptable to you, we can proceed. By the way, the POS is “life”, that means is in actual operation. So if it is possible, we could work on the cash box life, on the PC, but for the customer pole, could we work together on a notebook and later transport to the PC? I am asking this is because it may require a little bit more time, if there are differences between connecting to notebook and pc. This, I hope will cause minimal disruption to the operations. So far I have tried this test routine on the pc and returned with: EPSON TM-U220 Receipt USB001 Driver winspool Sub sdp() Dim prtDefault As Printer Set [login to view URL] = [login to view URL](0) Set prtDefault = [login to view URL] With prtDefault MsgBox "Device name: " & .DeviceName & vbCr _ & "Driver name: " & .DriverName & vbCr _ & "Port: " & .Port End With End Sub 1. Codes for opening cash box – to be written in MS Access as Modules; to send code “chr(27)+’p’+chr(0)+chr(100)+chr(250) to printer; if this works the printer will open the cash box. (command to module could be triggered by text box or command button). 2. Codes for sending to customer display – to be written in MS Access as Modules; to send information from TEXT BOX in MS Access to Pole display. Message is received in the pole display in the correct format, it is working. The Customer pole is VFD-450E Ver 5.46, can get details from website. Additional information submitted: 06/04/2010 at 7:42 EDT: Printer is serial printer connected to PC through a RS232 to USB adapter. Attached is simple access file, because the original one is too big.