hii

i want to do the follwing coding in the vba microsoft access 2003 to 
generate a user password such as 

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a  then 

[Name].enable = true
end if

where [name ] is a field contains various names 
the above password do work but the problem is when i put the password like 
"gul" it is visible though i want it to be hiden like asteriks or other 
characters that nobody around can see it 
thankx in advance

Check my article in Database Journal
http://www.databasejournal.com/features/msaccess/article.php/3848121/Extending-the-InputBox-function-for-MS-Access-Forms.htm

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Naveed Pathan" <NaveedPathan@discussions.microsoft.com> wrote in message 
news:106666D0-CB42-4D8A-9F12-35938E1A6EAB@microsoft.com...
> hii
>
> i want to do the follwing coding in the vba microsoft access 2003 to
> generate a user password such as
>
> form_load()
> dim a as string
> a="gul"
> if inputbox("enter your passoword") =a  then
>
> [Name].enable = true
> end if
>
> where [name ] is a field contains various names
> the above password do work but the problem is when i put the password like
> "gul" it is visible though i want it to be hiden like asteriks or other
> characters that nobody around can see it
> thankx in advance
> 

On Mon, 28 Dec 2009 16:47:02 -0800, Naveed Pathan
<NaveedPathan@discussions.microsoft.com> wrote:

>hii
>
>i want to do the follwing coding in the vba microsoft access 2003 to 
>generate a user password such as 
>
>form_load()
>dim a as string
>a="gul"
>if inputbox("enter your passoword") =a  then 
>
>[Name].enable = true
>end if
>
>where [name ] is a field contains various names 
>the above password do work but the problem is when i put the password like 
>"gul" it is visible though i want it to be hiden like asteriks or other 
>characters that nobody around can see it 
>thankx in advance

You cannot do this in an Inputbox, but what you can do is open a small unbound
form to collect the password. Use an Input Mask property of

password

on the textbox on the form, and open the form in dialog mode.
-- 

             John W. Vinson [MVP]

You can easily accomplish this by simply setting the input mask for the 
password control to 'password'.

See http://office.microsoft.com/en-us/access/HP051875501033.aspx for more 
information on input masks.
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Naveed Pathan" wrote:

> hii
> 
> i want to do the follwing coding in the vba microsoft access 2003 to 
> generate a user password such as 
> 
> form_load()
> dim a as string
> a="gul"
> if inputbox("enter your passoword") =a  then 
> 
> [Name].enable = true
> end if
> 
> where [name ] is a field contains various names 
> the above password do work but the problem is when i put the password like 
> "gul" it is visible though i want it to be hiden like asteriks or other 
> characters that nobody around can see it 
> thankx in advance
> 

thankx john though the rest of the people they don't try to understand the 
question they just like to give the comments or the useless links to waste 
the time. i am talking aobut the inputbox() and they telling me to use the 
inputmax i was wondering how to get it but you made it clear it for me as 
your answer is concise thankx  .

"John W. Vinson" wrote:

> On Mon, 28 Dec 2009 16:47:02 -0800, Naveed Pathan
> <NaveedPathan@discussions.microsoft.com> wrote:
> 
> >hii
> >
> >i want to do the follwing coding in the vba microsoft access 2003 to 
> >generate a user password such as 
> >
> >form_load()
> >dim a as string
> >a="gul"
> >if inputbox("enter your passoword") =a  then 
> >
> >[Name].enable = true
> >end if
> >
> >where [name ] is a field contains various names 
> >the above password do work but the problem is when i put the password like 
> >"gul" it is visible though i want it to be hiden like asteriks or other 
> >characters that nobody around can see it 
> >thankx in advance
> 
> You cannot do this in an Inputbox, but what you can do is open a small unbound
> form to collect the password. Use an Input Mask property of
> 
> password
> 
> on the textbox on the form, and open the form in dialog mode.
> -- 
> 
>              John W. Vinson [MVP]
> .
> 

Did you follow the "useless link" I posted? I showed two different ways to 
write your own form to accomplish what you're trying to do.

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Naveed Pathan" <NaveedPathan@discussions.microsoft.com> wrote in message 
news:577E7EEE-9520-4AD0-BC70-82F11DB59A35@microsoft.com...
> thankx john though the rest of the people they don't try to understand the
> question they just like to give the comments or the useless links to waste
> the time. i am talking aobut the inputbox() and they telling me to use the
> inputmax i was wondering how to get it but you made it clear it for me as
> your answer is concise thankx  .
>
> "John W. Vinson" wrote:
>
>> On Mon, 28 Dec 2009 16:47:02 -0800, Naveed Pathan
>> <NaveedPathan@discussions.microsoft.com> wrote:
>>
>> >hii
>> >
>> >i want to do the follwing coding in the vba microsoft access 2003 to
>> >generate a user password such as
>> >
>> >form_load()
>> >dim a as string
>> >a="gul"
>> >if inputbox("enter your passoword") =a  then
>> >
>> >[Name].enable = true
>> >end if
>> >
>> >where [name ] is a field contains various names
>> >the above password do work but the problem is when i put the password 
>> >like
>> >"gul" it is visible though i want it to be hiden like asteriks or other
>> >characters that nobody around can see it
>> >thankx in advance
>>
>> You cannot do this in an Inputbox, but what you can do is open a small 
>> unbound
>> form to collect the password. Use an Input Mask property of
>>
>> password
>>
>> on the textbox on the form, and open the form in dialog mode.
>> -- 
>>
>>              John W. Vinson [MVP]
>> .
>> 

Nice way to insult people trying to help you out!  Had you checked out the 
useless link you would had seen that for yourself.

As douglas, John and I all pointed out, input mask on a textbox control is 
the way to do this.  So create a simple form to collect the password and call 
it instead if your inputbox.  Not very hard.   A simple google search would 
have answered answered this question.
-- 
Daniel Pineault




"Naveed Pathan" wrote:

> thankx john though the rest of the people they don't try to understand the 
> question they just like to give the comments or the useless links to waste 
> the time. i am talking aobut the inputbox() and they telling me to use the 
> inputmax i was wondering how to get it but you made it clear it for me as 
> your answer is concise thankx  .
> 
> "John W. Vinson" wrote:
> 
> > On Mon, 28 Dec 2009 16:47:02 -0800, Naveed Pathan
> > <NaveedPathan@discussions.microsoft.com> wrote:
> > 
> > >hii
> > >
> > >i want to do the follwing coding in the vba microsoft access 2003 to 
> > >generate a user password such as 
> > >
> > >form_load()
> > >dim a as string
> > >a="gul"
> > >if inputbox("enter your passoword") =a  then 
> > >
> > >[Name].enable = true
> > >end if
> > >
> > >where [name ] is a field contains various names 
> > >the above password do work but the problem is when i put the password like 
> > >"gul" it is visible though i want it to be hiden like asteriks or other 
> > >characters that nobody around can see it 
> > >thankx in advance
> > 
> > You cannot do this in an Inputbox, but what you can do is open a small unbound
> > form to collect the password. Use an Input Mask property of
> > 
> > password
> > 
> > on the textbox on the form, and open the form in dialog mode.
> > -- 
> > 
> >              John W. Vinson [MVP]
> > .
> > 

On Tue, 29 Dec 2009 01:41:01 -0800, Naveed Pathan
<NaveedPathan@discussions.microsoft.com> wrote:

>thankx john though the rest of the people they don't try to understand the 
>question they just like to give the comments or the useless links to waste 
>the time. i am talking aobut the inputbox() and they telling me to use the 
>inputmax i was wondering how to get it but you made it clear it for me as 
>your answer is concise thankx  .

You're welcome... but do note that both Douglas and Daniel gave you exactly
the same suggestion, and if you had followed (and understood) the links you
would have gotten more complete and thorough help. Insulting folks who are
trying to help is impolite.
-- 

             John W. Vinson [MVP]

Excellent article by the way!  Once again, thank you for all your hard work 
and efforts educating and helping us all!
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Douglas J. Steele" wrote:

> Check my article in Database Journal
> http://www.databasejournal.com/features/msaccess/article.php/3848121/Extending-the-InputBox-function-for-MS-Access-Forms.htm
> 
> -- 
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no e-mails, please!)
> 
> 
> 
> "Naveed Pathan" <NaveedPathan@discussions.microsoft.com> wrote in message 
> news:106666D0-CB42-4D8A-9F12-35938E1A6EAB@microsoft.com...
> > hii
> >
> > i want to do the follwing coding in the vba microsoft access 2003 to
> > generate a user password such as
> >
> > form_load()
> > dim a as string
> > a="gul"
> > if inputbox("enter your passoword") =a  then
> >
> > [Name].enable = true
> > end if
> >
> > where [name ] is a field contains various names
> > the above password do work but the problem is when i put the password like
> > "gul" it is visible though i want it to be hiden like asteriks or other
> > characters that nobody around can see it
> > thankx in advance
> > 
> 
> .
>