Solved

input box with passwords

Posted on 2001-09-18
8
307 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
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
 
LVL 17

Expert Comment

by:Suat Ozgur
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 50

Expert Comment

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

Author Comment

by:Rachy222
ID: 6493680
thank you very much
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

773 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