Password Box

[dan.cawthorne]

Dear All,

Im Strugling On How to Create a Password Promt Dialog Box,
I Have a Form That Open from other Form when I Click on the Command
Buttom,

But What i would like to happen is before the New Form Is Opened That
The Password Dialog Is Displayed Which Ive Created,

Extsiting Form is Called "Projects_Qsearch" and the Form is Opens is
"Project_Analysis_Create" but inbetween the Process Ive Created this
Form "Enquiry_Analysis_Password"


The "Enquiry_Analysis_Password" Form
Consists of a Single Text Back Named "txtpassword". with a Lable Named
"Please Input Password" the Text Box Has an input mask of Password. so
its shows **** when typing.

And I have Command1 Button on the form, Labled Enter, When This Button
us Entered with the Correct Password, it will open the form
"Project_Analysis_Create"

Whats The VBA Coding in Getting This to Work, on this Button?

Regards

Daniel

 

[Ofer Cohen]

Look at this link on "How to create a User Login Form in Microsoft Access", I
think it gives a good example how to achieve that

http://www.databasedev.co.uk/login.html

 

[dan.cawthorne]

Look at this link on "How to create a User Login Form in Microsoft Access", I
think it gives a good example how to achieve that

http://www.databasedev.co.uk/login.html

--
Good Luck
BS"D











- Show quoted text -

Thank You Very Much, That May Come To Some Use, MAybe I Could Set up
Level Permissions as well, were only certain Users have access and
other buttons are grey's out!

 

[Douglas J. Steele]

Thank You Very Much, That May Come To Some Use, MAybe I Could Set up
Level Permissions as well, were only certain Users have access and
other buttons are grey's out!

Just be aware that "home grown" security seldom is. It may deter the honest
users, but if someone wants to get into your data, they will definitely be
able to. (Heck, even Access User-Level Security can be circumvented, which
is likely why they removed it from Access 2007)

 

[dan.cawthorne]

Just be aware that "home grown" security seldom is. It may deter the honest
users, but if someone wants to get into your data, they will definitely be
able to. (Heck, even Access User-Level Security can be circumvented, which
is likely why they removed it from Access 2007)

Well Thank You Doug, Im Just Trying to Polish me Access Skills Up,
Learning Things Slownly, But Its So Frustraing When you Just Cant Do
Somthing,

But The Users Who Will Be Using The System are going to be Braindeads,
They Never Knew What Access Was Till Last Week, So Im Not To Botherd
about it Been Super Security,