Solved

input box with passwords

Posted on 2001-09-18
8
302 Views
Last Modified: 2012-08-14
I am using the following code in a onclick command of a button to pop up an input box.

I need this input box to show ****** asterisks when the person types in their password to open the form, is there anyway to do this in access 2000 and 97

here is the code that I am using


strMsg = "Please enter your password to add a part."
    strInputPassword = InputBox(Prompt:=strMsg, TITLE:="Password Required", XPos:=2000, YPos:=2000)

0
Comment
Question by:Rachy222
  • 2
  • 2
  • 2
  • +2
8 Comments
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 6491343
change the InputMask property of the TextBox to Password.
0
 
LVL 44

Expert Comment

by:Arthur_Wood
ID: 6491347
You cannot do this using an InputBox command, however.  You will need to create your own Dialog form, to implement the Password Mask on a textbox.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 6491378
As Arthur states, this mask can't be used for an input box.
I would advise to create a function that displays a modal  pop-up form for the password (no userID required?) and that returns a boolean value (OK/NotOK) to use in your startup form's open event.

Nic;o)
0
 
LVL 1

Author Comment

by:Rachy222
ID: 6491617
nico,

I have never made a function like this, can you include code and more specific instructions , please ,

thanks
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 17

Expert Comment

by:smozgur
ID: 6491801
Actually expert ameba had a link to do that in VB but i couldnot run it in VBA.

http://www.freevbcode.com/ShowCode.asp?ID=1214&NoBox=True

Related question :

http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20173715

It is great way to do it in VB.

(This comment is just to share the links about Inputbox and PasswordChar.)

regards
suat
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 50 total points
ID: 6491819
Hi Rachel,

I dropped a form sample in your mailbox.
It's based on a value-list combobox with both userID and password.

Clear ?

Nic;o)
0
 
LVL 49

Expert Comment

by:Ryan Chong
ID: 6493161
<listening..>
0
 
LVL 1

Author Comment

by:Rachy222
ID: 6493680
thank you very much
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now