error 2489


Y

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

runtime error 2489 4

Top