tab strip

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dears,

I have a form with 3 tabstrip, how can I password protect each tabstrip.

the records in the form is from 1 table

or

if above not possible, can I have each table records in each tabstrip form,
with a password protect

any help will be appreciated

Many thanks
 
Gerald said:
Dears,

I have a form with 3 tabstrip, how can I password protect each
tabstrip. [snip]
Click to expand...

With the usual warning that any sort of home-cooked password scheme like this
would be trivially easy to bypass for anyone who is knowledgeable in Access here
are two ideas...

You could set the TabStyle to "None" and provide buttons to change the TabPage
instead. Code behind those same buttons could prompt for a password...

PageOneButton_Click
If InputBox("Enter Password") = "YourPassword" Then
Me!TabControlName.Value = 1 '(this is for second page)
Else
MsgBox "Incorrect Password"
End If
End Sub

You could leave the TabStyle as it is and use the Change event of the
TabControl, but that code is going to fire just *after* the page changes so the
user would see what was on the page before entering the password. You would
have to initially hide all of the objects and then unhide them if the password
is correct.
 
Back
Top