hidden form

[Guest]

how to retrieve the hidden form, if so, can it be done with a password

thanks

 

[Mark A. Sam]

Yes it can be done. Here is an example to display the form from a button:

Private Sub Command1_Click()

If InputBox("Enter Password to view Form!") = "myPassword" Then
Forms![myHiddenForm].Visible = True
End If

End Sub


The form name is: myHiddenForm
The password is: my Password

God Bless,

Mark A. Sam

 

[Guest]

Thanks..

but I made a mistake in my question, it was supposed to be a table not form

since I have stored few password in table, and want to hide it. Though if
hidden how can I read it if need to change password later.

would appreciate if you could answer my last query, i.e. I tried taking off
the all option from startup for showing menu's etc. i.e. all checkboxes
deselected.

if I need to make any changes how can I go in background i.e. dbase window
or even startup window

many thanks

Yes it can be done. Here is an example to display the form from a button:

Private Sub Command1_Click()

If InputBox("Enter Password to view Form!") = "myPassword" Then
Forms![myHiddenForm].Visible = True
End If

End Sub


The form name is: myHiddenForm
The password is: my Password

God Bless,

Mark A. Sam

how to retrieve the hidden form, if so, can it be done with a password

thanks

 

[Mark A. Sam]

Hello Gerald,

It sounds like you are using the built in Access security. I never go
there. I had tried it with a project years ago using Access 2.0, but it was
so frustrating and complicated that I won't ever use it again. It was a
stupid, nonsensical system then and Microsoft usually goes backward in
sophistication, so I don't expect anything has improved.

You can go to the Access Web if I recall and find an API to hide and show
the database window:

http://www.mvps.org/access/ (Click on API's then click on Manipulate Access
Window)

You will also have to disable the bypass key (which holding the Shift key
while opening the DB). You can then write code to Show or Hide the DB
Window, incorporating a password.

You could also write code to change the hidden atrbute of the tables, but a
sophistocated user could figure out how to rediplay them.

God Bless,

Mark

Thanks..

but I made a mistake in my question, it was supposed to be a table not form

since I have stored few password in table, and want to hide it. Though if
hidden how can I read it if need to change password later.

would appreciate if you could answer my last query, i.e. I tried taking off
the all option from startup for showing menu's etc. i.e. all checkboxes
deselected.

if I need to make any changes how can I go in background i.e. dbase window
or even startup window

many thanks

Yes it can be done. Here is an example to display the form from a button:

Private Sub Command1_Click()

If InputBox("Enter Password to view Form!") = "myPassword" Then
Forms![myHiddenForm].Visible = True
End If

End Sub


The form name is: myHiddenForm
The password is: my Password

God Bless,

Mark A. Sam

how to retrieve the hidden form, if so, can it be done with a password

thanks