Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms > button question
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 3 Topic 44661 of 46474
Post > Topic >>

button question

by =?Utf-8?B?amFja3JvYnluMQ==?= <jackrobyn1@[EMAIL PROTECTED] Aug 7, 2008 at 02:47 PM

I have a basic continuous form that a user can enter basic info about an 
accident eg Reference number, employee name, vehicle number etc etc. next
to 
each record there is a button that takes me to a larger form conected to
the 
same table, this is so a manager can add a more complete picture of the 
accidents events, i want this button to ask for a password before opening
the 
form. how can i do this? the buttons on click code is as follows:

Private Sub Command154_Click()
On Error GoTo Err_Command154_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "IncidentsEntryFRM"
    
    stLinkCriteria = "[Ref_No]=" & "'" & Me![Ref_No] & "'"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Command154_Click:
    Exit Sub

Err_Command154_Click:
    MsgBox Err.Description
    Resume Exit_Command154_Click
    
End Sub

Can you just add the code required to ask for a password please

Thanks
 




 3 Posts in Topic:
button question
=?Utf-8?B?amFja3JvYnluMQ=  2008-08-07 14:47:01 
Re: button question
"Pete D." <p  2008-08-07 18:34:11 
Re: button question
=?Utf-8?B?amFja3JvYnluMQ=  2008-08-07 16:14:00 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 20:17:06 CST 2008.