|
S
stealthwifi author
Hello,
I need to add a new button to the list page, when clicked it needs to delete the selected records and send them to another table. Previously I had used the delete button for this with event code (below) except I was just told they need to be able to delete as well and some might not have delete permissions but still need to archive.
Any ideas how I can add this archive button to the list page?
Event Code from Before Record Deleted
strSQLSave = "INSERT INTO AllisonArchive (Type, Number, Notes, Common_Trade_Name, ProductNumber, Manufacturer, Location_dept, ContainerSize, Keywords, Distributor, ChemicalClass, MSDSNumber, ValidAsOfDate, AddedToSystem, FileLocation, Image, Image2) SELECT Type, Number, Notes, Common_Trade_Name, ProductNumber, Manufacturer, Location_dept, ContainerSize, Keywords, Distributor, ChemicalClass, MSDSNumber, ValidAsOfDate, AddedToSystem, FileLocation, Image, Image2 FROM " & strTableName & " where " & where
dbConnection.Execute strSQLSave
|
|
