Have a look at www.adams1.com/pub/russadam
Here you'll find loads of information on barcodes
Oh, and there's also a 'bar coding' forum in tek tips...
Diederik
Epson does provide some simple VB samples (but then I take it you already checked them?)
Installed POS-peripherals can be found in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\OleForRetail\ServiceOPOS
and then them subkeys CashDrawer, LineDisplay, POSPrinter etc. (as per UPOS-specs) where...
Look out for any bar code scanner/reader with a keyboard wedge interface... Basically they just put the date into the keyboard buffer.
Oh, and one of the cheapest around..
Diederik
Did you checked out www.monroecs.com?
Here you'll find them Common Control Objects, which will enable you to code vendor independent.
So what you get is:
application <-> CCO's <-> Service Object
and the only thing to worry about is the interface between your application and the CCO's
Using them...
TLowder,
Although I can't answer the question, it seems indeed that having a Windows-printer installed using the same port that POSPrinter want's to use, blocks POSPrinter.
This is "logical", as the POSPrinter needs exclusive use of the port (see the UPOS documentation)
JohnVai,
POSPrinter is...
I'm not sure, but will the barcode scanner, even an USB-connected one, not just fill the keyboard buffer?
In other words: you can handle it as keyboard input?
Diederik
Greg,
Using strSerial = mscomm1.input will put the current received data stream into your variable. Next occurence will replace it by the next stream...
So something like:
strSerial = strSerail & MSMComm1.input
will give a better result.
Anyway, doing a keyword search on this forum on MSCOMM...
As you stated yourself "It seems that this system does run a little slower".
Most probably the following is happening:
The scanner sends all data in 1 go, however, as the system is busy assigning CPU-time to all the running processes, the data is NOT put in MSCOMM1.Input completely...
Oliver,
I just sticked to your original query/question.
'A' is an alias for table Docs (which you now call tblDocuments)
'B' is an alias for table Revisions (which you now call tblRevisions)
(so you got that one right)
'T' is an alias for the subquery result, so that it can be used in the...
Hmm, I did test that query on some of my tables; so maybe I got something wrong by translating it back to the example..
LEFT JOIN (SELECT MAX(RevNo) AS MaxRevNo, DocNo
FROM Revisions
GROUP BY DocNo
) T ON T.DocNo = Revisions.DocNo...
OK, maybe this will get you somewhere:
SELECT A.DocNo, B.MaxRevNo, B.NoChanges
FROM Docs AS A
LEFT JOIN (SELECT T.MaxRevNo, DocNo, NoChanges
FROM Revisions
LEFT JOIN (SELECT MAX(RevNo) AS MaxRevNo, DocNo
FROM Revisions
GROUP BY...
Oops, I made a typo (sorry):
SELECT TOP 1 DESC
should obviously be SELECT TOP 1
(the DESC command to be used after the ORDER BY-clause)
Damn, normally I test stuff that like in the SQL Query Analyzer, not top of my head and this is a fine example why
Diederik
This is not the most elegant solution, but then...
SELECT A.DocNo, B.MaxRevNo, B.NoChanges
FROM Docs AS A
INNER JOIN (SELECT TOP 1 DESC RevNo AS MaxRevNo, Changes AS noChanges, DocNo FROM Revisions ORDER BY RevNo DESC) B ON B.DocNo = A.DocNo
ORDER BY DocNo
(per DocNo obtain only 1 record from...
This code does work on a TM-210, although it can be necesary to issue a 'set font' command first (to prevent the printer from using only 32 chars/line):
OPOSPOSPrinter.RecLineChars = 40
This does work perfectly in VB and VBA
Diederik
...a barcode. For this, one need to reference the scanner manual
Some can even be setup to send barcode marker data (fe. Interleaved 3 of 9 requires a * or ! as start- and stop marker, which will normally be stripped by the scanner), or strip control numbers from the barcode
2. barcode format...
Maybe thread222-58793 will help (which hints on using an Image Control...)
Otherwise, you'll have to rescale the picture manually using the PictureBox1.Picture.ScaleHeight & .ScaleWidth properties.
I found that after rescaling the picture to fit the contril, it is necessary to resize the...
sergiogove,
Just get yourself some OPOS drivers from a peripheral manufacturer (fe. https://www.epson-pos.com/cgi-bin/sddl/down/scripts/dw_start.jsp)
Most have included a 'samples' part in their ADK (Epson has) including LOTS of sample code.
To get started: for printers, it's boils down to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.