Display in listbox from textbox input

[stevebanks]

Hi,

I am trying to create a till system using access, I have a barcode scanner reading into a textbox, which I then need to get to action an entry into a listbox and calculate the totals.

I am thinking that if the entries can go into the listbox into a temporary table, then when the sale is cashed off it would move the data into the main salesdata table?

Please can anyone help me with suggestions?! My brain isn't quite working this monday morning ( or any morning for that matter!)

Hope that all makes sense?!

Thanks

Steve

 

[kjv1611]

Possible idea (not that it is the answer for sure, or even that it will definitely work for your situation):

1. Create a table (or use the table you've already created for this project).
2. Use this table (or a query of the table) for the query source for your List Box.
3. When inserting the new value into the text box from the bar code scanner, use code or a query connected to an event (such as an after update event of the text box or a button with a click event) to add the new value to the table.
4. In that same code (in number 3), at the end, put in a statement to requery the user form, or possibly even just the list box, to reflect the updated changes.

 

[stevebanks]

sounds like a good plan! Thanks, i shall give it a go in the morning (midnight here now!), will keep you updated... Sounds like a good possibility though,

thanks, i just couldn't get my head round it!

steve

 

[formerTexan]

A few questions. Will you be scanning multiple items as part of a single transaction? Is payment part of the same transaction? Will it be exact payment? Will part or all of the transaction ever be cancelled/backed out? Will you need an audit trail? Will you need to keep your till in balance?

Cheers,
Bill

 

[stevebanks]

Hi Bill,

The answer to all of your questions is yes...

Thanks

steve

 

[formerTexan]

Hi Steve,

Writing an application that conforms to standard accounting practices is beyond my expertise. But it obviously has been done many times over, so its worth a Tektips or Google search in this area for some ideas. That aside, here are some generic suggestions.

1. Get your tables right first. Consider setting up a Transaction table to correspond to your till transactions. Each till transaction gets its own transaction ID. Then use seperate linked tables for scanned items and cash receipts/dispersals.

2. Either use temporary tables until everything balances out for a given transaction and then post to permanent tables, or use a field (probably boolean) to designate whether the transaction has been successfully completed

3. Include Date/Time stamp fields for all of your records.

4. Have an in depth look at ADO or DAO transactions (not to be confused with the aforementioned transactions) and the rolling back of transactions.

5. Get your accounting gurus in the loop.

Cheers,
Bill