error 2489

[yalda mostafazadeh]

I'm trying to make a username and password on a form for entrance
username should be email from a table named " customers" and password is zipcode from the table too
the macro i used for "enter" butten is:
search for record
object type: table
object name: customer
record:first
where condition: username=email
if username=email
if password=zipcode
open form
else
msgbox
end if
else
msgbox


but whatever i type,this password is shown and i'm going crazy,what should i do?

p.s: my form's data source is linked to customer table

 

[John W. Vinson]

I'm trying to make a username and password on a form for entrance
username should be email from a table named " customers" and password is zipcode from the table too
the macro i used for "enter" butten is:
search for record
object type: table
object name: customer
record:first
where condition: username=email
if username=email
if password=zipcode
open form
else
msgbox
end if
else
msgbox


but whatever i type,this password is shown and i'm going crazy,what should i do?

p.s: my form's data source is linked to customer table

Set the Input Mask property of the textbox bound to the password field to

Password

It will store the typed characters but they'll display as asterisks.

Of course you need to lock down the form, make the database a mde/accde to
hide your code and form properties, etc.; this security will keep out honest
people but it would be really easy to crack.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://answers.microsoft.com/en-us/office/forum/access?tab=question&status=all
http://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev
and see also http://www.utteraccess.com