Re: Prompting for password
- From: "Wayne Phillips" <wayne@xxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 23 Apr 2005 18:32:22 GMT
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
"'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:4BDD9F68-E032-491F-A9A6-3EF08D2322E3@xxxxxxxxxxxxxxxx
> 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
> > > >
.
- References:
- Prompting for password
- From: Mauricio Silva
- RE: Prompting for password
- From: '69 Camaro
- RE: Prompting for password
- From: Mauricio Silva
- RE: Prompting for password
- From: '69 Camaro
- Prompting for password
- Prev by Date: Re: How do I recover password in MS ACCESS
- Next by Date: Re: access security turn off?
- Previous by thread: RE: Prompting for password
- Next by thread: Users and Groups list empty
- Index(es):
Relevant Pages
|
