Home All Groups Group Topic Archive Search About

Prompting for password

Author
13 Apr 2005 3:09 PM
Mauricio Silva
I have developed a form which connect to other database and list all the
users connected to it. In most cases, I have to enter a password in order to
do it. My question is:

Is there an InputBox Masked? I mean, if I use InputBox to ask for a
password, it will show the typed password because it is not masked as ****.
Is there a way to open the login dialog to log into the new database?

Thanks
Mauricio Silva 2005

Author
13 Apr 2005 9:45 PM
'69 Camaro
Hi, Mauricio.

> Is there an InputBox Masked?

Yes.  Open the form in Design View.  Select the text box that accepts the
password typed by the user.  Open the Properties dialog window.  Select the
"Data" tab.  In the "Input Mask" Property, type:

Password

Save the form, then open it in Form View.  The user's input will now have an
* displayed for each character typed into the password text box, thereby
hiding the actual password from passersby.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions.  Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.


Show quoteHide quote
"Mauricio Silva" wrote:

> I have developed a form which connect to other database and list all the
> users connected to it. In most cases, I have to enter a password in order to
> do it. My question is:
>
> Is there an InputBox Masked? I mean, if I use InputBox to ask for a
> password, it will show the typed password because it is not masked as ****.
> Is there a way to open the login dialog to log into the new database?
>
> Thanks
> Mauricio Silva 2005
>
Author
14 Apr 2005 1:19 PM
Mauricio Silva
Hi Gunny,

thank you for your answer, but I think I didn't explain myself quite well.

I am trying to avoid creating a new form just to input a password, what I am
asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile 
or an Access Dialog such as InputBox. Maybe an InputPassword Dialog.

Thanks again

Mauricio Silva 2005

Show quoteHide quote
"'69 Camaro" wrote:

> Hi, Mauricio.
>
> > Is there an InputBox Masked?
>
> Yes.  Open the form in Design View.  Select the text box that accepts the
> password typed by the user.  Open the Properties dialog window.  Select the
> "Data" tab.  In the "Input Mask" Property, type:
>
> Password
>
> Save the form, then open it in Form View.  The user's input will now have an
> * displayed for each character typed into the password text box, thereby
> hiding the actual password from passersby.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as "Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions.  Remember that the first and
> best answers are often given to those who have a history of rewarding the
> contributors who have taken the time to answer questions correctly.
>
>
> "Mauricio Silva" wrote:
>
> > I have developed a form which connect to other database and list all the
> > users connected to it. In most cases, I have to enter a password in order to
> > do it. My question is:
> >
> > Is there an InputBox Masked? I mean, if I use InputBox to ask for a
> > password, it will show the typed password because it is not masked as ****.
> > Is there a way to open the login dialog to log into the new database?
> >
> > Thanks
> > Mauricio Silva 2005
> >
Author
14 Apr 2005 2:39 PM
'69 Camaro
Hi, Mauricio.

> I am trying to avoid creating a new form just to input a password

Oh.  I assumed that the form you had already created to connect to the other
database and list the users connected to it had a text box available for the
user to type the password, since you mentioned that you had to enter a
password in most cases to connect to the other database.

> what I am
> asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile 
> or an Access Dialog such as InputBox. Maybe an InputPassword Dialog.

The only pre-programmed dialog window for this is the InputBox, which does
not allow for input masks.  Other than that, you'll have to create a separate
form, add a text box to a current form, or call an external executable file
that displays the user-defined dialog window that includes an input mask for
a password, then pass it to the database to connect to.  You could create a
form in an executable file with Visual Basic, but that's a lot more trouble
than just adding a special text box or creating a special form within Access.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions.  Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.


Show quoteHide quote
"Mauricio Silva" wrote:

> Hi Gunny,
>
> thank you for your answer, but I think I didn't explain myself quite well.
>
> I am trying to avoid creating a new form just to input a password, what I am
> asking is if there is a Windows' Dialog for it, such as SaveFile or OpenFile 
> or an Access Dialog such as InputBox. Maybe an InputPassword Dialog.
>
> Thanks again
>
> Mauricio Silva 2005
>
> "'69 Camaro" wrote:
>
> > Hi, Mauricio.
> >
> > > Is there an InputBox Masked?
> >
> > Yes.  Open the form in Design View.  Select the text box that accepts the
> > password typed by the user.  Open the Properties dialog window.  Select the
> > "Data" tab.  In the "Input Mask" Property, type:
> >
> > Password
> >
> > Save the form, then open it in Form View.  The user's input will now have an
> > * displayed for each character typed into the password text box, thereby
> > hiding the actual password from passersby.
> >
> > HTH.
> >
> > Gunny
> >
> > See http://www.QBuilt.com for all your database needs.
> > See http://www.Access.QBuilt.com for Microsoft Access tips.
> >
> > (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> > will be forwarded to me.)
> >
> > - - -
> > When you see correct answers to your question posted in Microsoft's Online
> > Community, please sign in to the Community and mark these posts as "Answers,"
> > so that all may benefit by filtering on "Answered questions" and quickly
> > finding the right answers to similar questions.  Remember that the first and
> > best answers are often given to those who have a history of rewarding the
> > contributors who have taken the time to answer questions correctly.
> >
> >
> > "Mauricio Silva" wrote:
> >
> > > I have developed a form which connect to other database and list all the
> > > users connected to it. In most cases, I have to enter a password in order to
> > > do it. My question is:
> > >
> > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a
> > > password, it will show the typed password because it is not masked as ****.
> > > Is there a way to open the login dialog to log into the new database?
> > >
> > > Thanks
> > > Mauricio Silva 2005
> > >
Author
23 Apr 2005 6:32 PM
Wayne Phillips
Actually this is possible, but requires the use of hooks (therefore I would
generally advise the normal form based approach).

If you want to use the Win API hook approach - you can read it here:

http://www.danielklann.com/excel/hiding_text_in_a_vba_inputbox.htm

Regards,

Wayne Phillips
http://www.everythingaccess.com


Show quoteHide quote
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote in
message news:4BDD9F68-E032-491F-A9A6-3EF08D2322E3@microsoft.com...
> Hi, Mauricio.
>
> > I am trying to avoid creating a new form just to input a password
>
> Oh.  I assumed that the form you had already created to connect to the
other
> database and list the users connected to it had a text box available for
the
> user to type the password, since you mentioned that you had to enter a
> password in most cases to connect to the other database.
>
> > what I am
> > asking is if there is a Windows' Dialog for it, such as SaveFile or
OpenFile
> > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog.
>
> The only pre-programmed dialog window for this is the InputBox, which does
> not allow for input masks.  Other than that, you'll have to create a
separate
> form, add a text box to a current form, or call an external executable
file
> that displays the user-defined dialog window that includes an input mask
for
> a password, then pass it to the database to connect to.  You could create
a
> form in an executable file with Visual Basic, but that's a lot more
trouble
> than just adding a special text box or creating a special form within
Access.
>
> HTH.
>
> Gunny
>
> See http://www.QBuilt.com for all your database needs.
> See http://www.Access.QBuilt.com for Microsoft Access tips.
>
> (Please remove ZERO_SPAM from my reply E-mail address, so that a message
> will be forwarded to me.)
>
> - - -
> When you see correct answers to your question posted in Microsoft's Online
> Community, please sign in to the Community and mark these posts as
"Answers,"
> so that all may benefit by filtering on "Answered questions" and quickly
> finding the right answers to similar questions.  Remember that the first
and
> best answers are often given to those who have a history of rewarding the
> contributors who have taken the time to answer questions correctly.
>
>
> "Mauricio Silva" wrote:
>
> > Hi Gunny,
> >
> > thank you for your answer, but I think I didn't explain myself quite
well.
> >
> > I am trying to avoid creating a new form just to input a password, what
I am
> > asking is if there is a Windows' Dialog for it, such as SaveFile or
OpenFile
> > or an Access Dialog such as InputBox. Maybe an InputPassword Dialog.
> >
> > Thanks again
> >
> > Mauricio Silva 2005
> >
> > "'69 Camaro" wrote:
> >
> > > Hi, Mauricio.
> > >
> > > > Is there an InputBox Masked?
> > >
> > > Yes.  Open the form in Design View.  Select the text box that accepts
the
> > > password typed by the user.  Open the Properties dialog window.
Select the
> > > "Data" tab.  In the "Input Mask" Property, type:
> > >
> > > Password
> > >
> > > Save the form, then open it in Form View.  The user's input will now
have an
> > > * displayed for each character typed into the password text box,
thereby
> > > hiding the actual password from passersby.
> > >
> > > HTH.
> > >
> > > Gunny
> > >
> > > See http://www.QBuilt.com for all your database needs.
> > > See http://www.Access.QBuilt.com for Microsoft Access tips.
> > >
> > > (Please remove ZERO_SPAM from my reply E-mail address, so that a
message
> > > will be forwarded to me.)
> > >
> > > - - -
> > > When you see correct answers to your question posted in Microsoft's
Online
> > > Community, please sign in to the Community and mark these posts as
"Answers,"
> > > so that all may benefit by filtering on "Answered questions" and
quickly
> > > finding the right answers to similar questions.  Remember that the
first and
> > > best answers are often given to those who have a history of rewarding
the
> > > contributors who have taken the time to answer questions correctly.
> > >
> > >
> > > "Mauricio Silva" wrote:
> > >
> > > > I have developed a form which connect to other database and list all
the
> > > > users connected to it. In most cases, I have to enter a password in
order to
> > > > do it. My question is:
> > > >
> > > > Is there an InputBox Masked? I mean, if I use InputBox to ask for a
> > > > password, it will show the typed password because it is not masked
as ****.
> > > > Is there a way to open the login dialog to log into the new
database?
> > > >
> > > > Thanks
> > > > Mauricio Silva 2005
> > > >