Search results

I have managed to find a fix. I have found this piece of code that works great: var = "com3" Open var For Output Access Write As #1 Print #1, Chr$(27); "p"; Chr$(48); Chr$(25); Chr$(250); Close #1 Thanks for the help: Danian

I am trying to create a EPOS system for a local small store. I have created 2 tables tblTransMain, which holds ID, Order Date, Order Time, Payment Type and Sales Clerk. This has a subform called tblTransactions, which holds all the transaction info. I have so far created a form called...

Not a clue what you are talking about! I have found the above code and just trying to get it to work. not very good with vb. really need some help though...

I have found 2 pieces of code on the internet that should open COM3 and fire a kick to open a cash drawer. The code is in VB, but I want to use this in an access database. The code is 1.) Dim iFile As Integer Dim arrbData() As Byte iFile = FreeFile Open "COM3" For Binary Access Write As...

Can anyone help?

I am planning to use the kick below which works in the same way as a printer. All i need is the code that goes behind the cmd button fire the kick. I have been informed that the kick recognises all printer codes. Can you provide working code to fire the printer/Drawer...

This is the cash draw trigger i bought: http://www.gigatms.com.tw/products-detail.asp?pid=26 not to sure about the api driver

I am trying to create a simple till system that creates transactions. I have bought a till and kick that runs on USB. The company I bought the equipment from supplied and application that allows you to test the drawer. You select the port (Comm3 in my case) and select open. This then firers the...

This is ok but i need the data to go into certain cells. Microsfy query does not allow this.

I have a database that works as a sales system. From a table in the database I run a query that calculates the totals for that day. i.e. Date……….Dept 1…..Dep2 07/11/05…...£10………£10 What I need is: 1. You click a button 2. It copies the date and finds it in the excel spreadsheet as the sheet...

Scott, It does do this. It adds the record, but i cant seem to get it to update. I get it to add a new record everytime to + buuron is clicked. what i need is a piece of code that runs on the after update. It would be something like: After update overwrite tblquantity.QuantitySold with...

I have a form that is bound to a table and also a subform that is also bound to a table. On the Subform I have a Plus and Minus buttons that sort of work at as a tally chart. Every time you click the plus button it adds 1 to the quantity textbox and vice versa for the subtract button. What...

Can anyone help....

I have a form that calculates the total cost. It also as an option to revoke the transaction. The code used is below: =DSum("Cost","tblTransactions","OrderID = " & [ID] & " AND Revoked = False") I have since added in the option to Discount a product. It writes back to the same table but I can...

Thanks for the reply, that works great. The only problem I have now is that the barcode is entered and selects the product, it then removes the barcode but tabs down to the next textbox. I need it to stay in the same combo box cmbBarcode. I know this is simple, but I am not sure how to do it...

I have a combo box that I use a barcode scanner with. I scan the barcode and it finds the product using the code below: Private Sub cmbBarCode_Click() ' ADD A TRANSACTION AUTOMATICALLY Dim RS As ADODB.Recordset Set RS = New ADODB.Recordset RS.Open "SELECT * from tblTransactions"...

Can anyone help with this? Thanks D

no one want help! D

Thanks for the reply. I did what you said and it worked. the only problem i have is with changing the date. I have created a textbox and called it txtEnterDate. What i need to happen is when the date is entered into the textbox it changes the query date. I have attached DB. Look at form...

What is a continuous form and how do create one? D