Button grid based on table for POS

[tquinn]

Hi,

I’d like to create a button grid to select products on my pos.



This would be done from queries, so I could have a tabbed section to pick the category...

What it should do is get the name and picture from the object and put it on a button, so that when I press one it adds the product to the sale.

It would get the sale details from some boxes on the form, and use them to create a new record. E.g. SaleID, Customer, Product, Price, Quantity, Total.

Could you also tell me how to total up the items in a sale? Each sale would be multiple rows on a table, with an auto number id for each line, but linked together with the SaleID. I’d like the total to be a row at the end of each sale, that I could display in the form.


Thanks,
Tom

[June7]

Not sure what you mean by 'get the name and picture from the object and put it on a button' - what is 'object'?

Use either Image or Button control to show image. However, will require code in Click event to save value to record since neither of these controls can pass value to field.

Textbox in form footer section can use Sum() expression to total records.

[tquinn]

The object is the product, so I’m looking to populate the buttons from the products table, so I don’t have to recode them every time a product changes

[pbaldy]

The dynamic part of this is not simple, and parts of your question imply you're just starting out. The drag and drop sample here uses code to populate controls at runtime. It could be adapted to your buttons. It becomes tricker when you want to organize buttons on tabs.

http://www.baldyweb.com/ChrisOSamples.htm

[orange]

Tom,
Further to Paul's comments and the examples from ChrisO, I would recommend you mock up (pencil and paper/or some graphic) a picture of your proposed "button grid". That would help reader to understand your intent; it may also help you with design ideas.
There are at least 2 things to consider:
-design of the tables and relationships to support your business, and
-design of the user interface for ease of use.

Good luck.

[Micron]

I think I get it, except for this part

This would be done from queries, so I could have a tabbed section to pick the category

Possibly a combo should be used to choose a category and not "tabbed section" (whatever that is) but queries cannot dictate what image a button shows. Nor would I use command buttons to indicate an item that can be chosen unless there was an accompanying visible control to indicate the current count. Otherwise, how would you know if the click added to the count or not? How would you remove 1 from a count without an accompanying minus button, which also would require an image, making this messier?

Anyway, there are tons of results if you Google MS Access POS. That should be the starting point, and if nothing is found that is suitable, it ought to at least shed some light on what is possible and aid in further discussion. No sense in recreating the wheel if you don't have to.