build POS system using MS Excel

[Jerome Tan]

Hi there,

Is it possible to build POS (Point of Sale) system using MS Excel?

Regards/
Jerome

 

[Frank Kabel]

Hi Jerome
you may be a little bit more specific about what exactly
you're trying to achieve. POS systems can vary widely

 

[Jerome Tan]

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

 

[Tom Ogilvy]

ADO might be more appropriate since you seem to need two way communications.

DAO/ADO
http://www.erlandsendata.no/english/index.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.