Announcement

Collapse
No announcement yet.

Updating all records

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Updating all records

    This may appear to be a simple one but I am struggling to find the best way to achieve the following, and any assistance / examples would be most appreciated .....

    I have a table which through a blank form I have a button called "month-end" on selecting the button I wish to update a status field for all records which meet a specific date criteria with a value of '2'

    please could someone advise the best way to achieve this

    Thanks in advance.

  • #2
    Originally posted by awayman View Post
    This may appear to be a simple one but I am struggling to find the best way to achieve the following, and any assistance / examples would be most appreciated .....

    I have a table which through a blank form I have a button called "month-end" on selecting the button I wish to update a status field for all records which meet a specific date criteria with a value of '2'

    please could someone advise the best way to achieve this

    Thanks in advance.
    I would redo this into a control form. Then you can create a button of type php and apply the required code to the button. For update of the table you can use the regular sql macro's.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X