Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154

    Red face Unanswered: POS, Fields on buttons?!?!?

    Greets;

    I have access 2003. Anyway, I'm creating POS (or attempting to) db, and want to create a form to handle sales, what i want the user to see is....

    a 5x5 (or more) grid of buttons, each button will have on it a field from a stock list (which would have been previously filtered), when the button is pressed then then item is added to the transaction table.

    Everything is contained within (tbl_stock) and the transactions are carried out in (tbl_Transaction) and (tbl_transaction_items). transaction_items is a lookup field that adds the items to a record, and to a transaction number from tbl_transaction. Tbl_transaction has the date/time of the sale, a transaction id, and has the multiple items linked to it.

    I can already have this work through a form with drop down boxes, but to display the records onto buttons would be more ideal. I'd appreciate any help where possible;

    Thanks a ton;

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Force the button captions to display your field data. You will need to do this with code though.

    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8
    me.buttonName.caption = vblookup(......)

    The hard part is when do you run the event to display the right info
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •