>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

"Tom van Stiphout" wrote:

> On Wed, 29 Apr 2009 12:31:01 -0700, ssignore
> <ssign***@discussions.microsoft.com> wrote:
>
> 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
>
>
> >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
>

>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
>
>"Tom van Stiphout" wrote:
>
>> On Wed, 29 Apr 2009 12:31:01 -0700, ssignore
>> <ssign***@discussions.microsoft.com> wrote:
>>
>> 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
>>
>>
>> >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
>>