ADO might be more appropriate since you seem to need two way communications.
DAO/ADO
http://www.erlandsendata.no/english/...php?t=envbadac
Since POS systems are written using code, and Excel provides a programming
language, you could certainly code a POS system in Excel to meet your
specific needs. Printing out a receipt should require little more than
filling in the information in cells in a worksheet formatted to appear as
you want to print it, then printing. If you want the data added to a
database, then you would need minimal code to do this.
--
Regards,
Tom Ogilvy
"Jerome Tan" wrote in message
...
I intend to make it for receipt printing. I'm having trouble making using
MS
Access.
It's for our photo shop, I want to use it to generate receipts for
printing.
Is it possible to integrate it with ODBC?
Regards/
Jerome
"Frank Kabel" wrote in message
...
Hi Jerome
you may be a little bit more specific about what exactly
you're trying to achieve. POS systems can vary widely :-)
-----Original Message-----
Hi there,
Is it possible to build POS (Point of Sale) system using
MS Excel?
Regards/
Jerome
.