Delete Button vs. Delete Query

[JennyL]

Hi,



I am trying to decide if I should use a delete button or delete query to delete a record. I only want the users who knows the delete password to delete the record. there are many tables linked to the "account table" and I want to limit the users who can delete. There will be times that users will probably create the wrong account due to typo, and needs it to be removed from the database. in those cases, they will need to notify the manager and then manager will go in to delete the record.

should I create the delete button with password vba code next to the sub-form records? or should build a separate form using delete query where manager will have to enter the account number and then hit delete? the separate form of course will be under the Admin navigation page, so only users with admin rights will have ability to see this delete form.

Any feedback is greatly appreciated!

[ranman256]

use a delete button,
the code behind the button can ask for the password, user enters it, do a dlookup to confirm, then run the delete query.

sub btnDelete_click()

ret = InputBox ("enter password","Delete record")
vValid = Dlookup("[pass]","tPasswords","[pass]='" & ret & "'")
if IsNull(vValid) then
   msgbox "Incorrect password"
else
   docmd.openquery "qdDel1Record"
endif

end sub

[JennyL]

use a delete button,
the code behind the button can ask for the password, user enters it, do a dlookup to confirm, then run the delete query.

sub btnDelete_click()

ret = InputBox ("enter password","Delete record")
vValid = Dlookup("[pass]","tPasswords","[pass]='" & ret & "'")
if IsNull(vValid) then
   msgbox "Incorrect password"
else
   docmd.openquery "qdDel1Record"
endif

end sub

What does qdDel1Record mean? so I should create a delete query with criteria "Enter Account Number"? Otherwise, how would database know which record to delete?

Thanks!

[aytee111]

Create a special form for deleting a record. The user enters the password to open the form (a check in VBA). On the delete form, the manager will select the record using a combobox and all the data will be displayed. A button can be called "Confirm deletion", when clicked you can run a query to delete that record, something like :
DoCmd.RunSQL " DELETE * FROM tablename WHERE IDname =" & Me!SelectedID & ";"

[HiTechCoach]

Use a delete button to run a delete query.

I second aytee11's idea for the form. I like it. I would also have the delete form check to be sure that the user does not have the data entry for open also just to be safe.

For functions like this I like to use an separate "Admin" front end linked to the same back end. I find it much easier to secure an entire front end.