none
how Adding A Command Button To Each Rowin table RRS feed

  • Question

  • hi for all

    I have table with many columns and I want to display command bottom for each row in table so that I can to delete the current row if I need that 

    thanks for all

    Thursday, September 8, 2016 10:57 AM

Answers

  • Hi wissam alshamy,

    According to your description, unfortunately, Access does not support this feature. If you have any feedback for Access, please feel free to submit them to User Voice:

    https://access.uservoice.com/

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Sunday, September 18, 2016 1:57 PM
    • Marked as answer by David_JunFeng Monday, September 19, 2016 5:25 AM
    Friday, September 9, 2016 9:29 AM

All replies

  • Take a look at DeleteDemo.zip in my public databases folder at:

    https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

    Note that if you are using an earlier version of Access you might find that the colour of some form objects such as buttons shows incorrectly and you will need to  amend the form design accordingly.  

    If you have difficulty opening the link copy its text (NB, not the link location) and paste it into your browser's address bar.

    This little demo file illustrates the use of command buttons for deleting the current row.  The demo uses a dorm in single form view, but the methodology will work equally well in continuous forms view.

    Ken Sheridan, Stafford, England

    Thursday, September 8, 2016 11:26 AM
  • Not in tables, but you can have a form in Continuous Forms mode to do that.

    No need for button: just make sure you have RecordSelector set to Yes, so you can select the row, then hit Del to delete the row.

    But if you insist on a button, put this one-liner in the Click event:
    RunCommand acCmdDeleteRecord


    -Tom. Microsoft Access MVP

    Thursday, September 8, 2016 1:38 PM
  • Hi wissam alshamy,

    According to your description, unfortunately, Access does not support this feature. If you have any feedback for Access, please feel free to submit them to User Voice:

    https://access.uservoice.com/

    Thanks for your understanding.
    • Proposed as answer by David_JunFeng Sunday, September 18, 2016 1:57 PM
    • Marked as answer by David_JunFeng Monday, September 19, 2016 5:25 AM
    Friday, September 9, 2016 9:29 AM