Establishing a Password for a Delete Button

  • Thread starter Thread starter ssignore
  • Start date Start date
S

ssignore

Hello, MS Online Community!
I originally posted on April 15 asking how I could allow user permissions to
a control, but the VB script generously provided by Tom van Stiphout eluded
me (I did try, Tom!) as I don't speak VP.
I've reviewed the posts on Password Question also from April 15 and was
hoping to get some guidance on how I could password-protect the delete button
on a form?
Thank you!
Regards,
Simone
 
On Wed, 29 Apr 2009 12:31:01 -0700, ssignore

Let's try one more time. Bring the form to be protected in design
view. On the properties window locate the form-level properties. You
may have to click the form in the upperleft corner. Locate the events
on the property sheet. One of them is OnOpen. Drop down the list for
that event and choose Event Procedure. Then click the ... button just
next to it. A code window opens with a skeleton Form_Open event:
Private Sub Form_Open(Cancel As Integer)

End Sub

Change that to the code I suggested on April-15.

-Tom.
Microsoft Access MVP
 
Tom,
Can you have two event procedures on one form? I already have an event
procedure on BeforeUpdate with script you provided to me to prevent anyone
from being able to fully delete required data and move on to another record.
The OnOpen event procedure seems to get wiped out after I put in the script.
Thanks for the help.
Regards,
Simone
 
On Thu, 30 Apr 2009 07:54:02 -0700, ssignore

Yes, try it! You can have one event procedure for each event of each
control, and of the form itself.
I don't understand the wipeout part. That should not happen.

-Tom.
Microsoft Access MVP
 
Back
Top