Recent content by Diederik

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...

Set the property PasswordChar of the inputbox to '*' Diederik

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 &quot;It seems that this system does run a little slower&quot;. 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...

Round(Price_ft/12, 2) might help? And I'm with Andy, count them bracket pairs... Diederik

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...

The EPSON OPOS set includes very clear programming samples. This can be downloaded from http://pos.epson.com/pointofsale/opos.html Diederik

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