Create Login Form Access Database Part 1

Create Login Form Access Database Part 1
Download sample Access file at :
http://www.iaccessworld.com/?p=1304

==========Attention!! Please==================
There was an error on some code. you can fix it by combining criteria LoginID and Password in one criteria under one DLookup. The fixed code is "If (IsNull(DLookup("[UserLogin]", "tblUser", "[Userlogin] ='" & Me.txtLoginID.Value & "' And password = '" & Me.txtPassword.Value & "'"))) Then
msgbox "............"
else
......

end if
==================================
user " and ' infront of And. Sorry for confusion.

Part 2 link here :http://youtu.be/cUjoaxsz92s

---

Closed Caption:

how many mature one in this video we
show you how to create it a lot in form
a login form we use when you open a
microsoft access and then rolling fun
with pop and then you need to end the
user ID and password in order to that
log in a form before that you have to
have with some kind of got cable like a
employee table or use a table in here
I already have the use of table of you
at this table to verify the law in
information on the login form under the
table use of i have the username
well in ID and password
first we can create form by using the
pop-up dialog model final form in the
law in form but we need to take box
this first one fall
well in ID and then the second one and
four class for now formatted may get
organized
this arrange that
ok now we get cancel button and ok
button and click on this button and
it'll create and when the name format
caption and name the form is log in form
under the first ball login box o wind
and that the auto TAF the name
we can to pics
login 90 and a sick and take strong name
take ta ki pass work
hee hee login ID and a password and the
cancel the system or reporter
you know English Michael we can change
that
of course form we leave this one we can
put down quick access this mean close to
you know program when you can so that
and then this we you say even procedure
we put the court under ok bottom
and ok but then and the kick away in
procedure
open it on the book ticket now we see in
the poor man cake
ok but them and we need to put some cold
in here
first we want to worry fine when every
five to take Mark's to takes walk here
it is nor nothing in there we can get a
message like god no peace in the
password or login ID we started know it
is no need not take
takes love Heidi it is no all take long
in 90 and then we leave a message and is
a waltz keep the use of the massive
trees and the wall in right
d we be information useful information
and the title under from massive for
myself in my dear it's fine LOL hips
if you ended long an ID but you forgot
to push hospital in there
we want to test we want to tip is not
simply it is no
then don't take password and then
not be the message box is here and it is
take password to take my password is
empty
it is no or may not take class 1 and
then message hobbies and the hospital us
will require the next statement if else
if you use of high in a long long an ID
and password and then we do something
ok we can add some here to either of the
user for gotta log in ID we can go back
and put some like a bringing closer to
that box . takes ID . set foot
same thing here then possible
the next
it is you want to test is the correct
this along in all the quarry password or
are the boat is not empty but make sure
that the end of the correct along and
create password in order to go to the
next step
open the application we use legal Gump
when I look up information look at this
you belong in that is correct or not
roll up absolutely , cannot form the I
user table we have a mommy user long in
ever use along in and then password in
from table TBL user and we sit down
chua is use them all in equal to that
takes long in ID
not following three close paranthesis
this one we taste it is new or home use
along in from the table user and wears
long in equal to it takes 1990 and then
we can do something else and we want to
do both put we on a test ball
login ID and password is coming are not
from the user
I in and got me this thing we do one and
making change
they all now we test the password
we have here - password field
full takes pause for and we get the
message
if the password and user login
incoming when a massive marks in curry
well any ID or password
it is corey we opened the program
ok now we we feed the wire radiation
function for the login ID and password
you want to taste this function
save it from as lame longing romantic
from and now we want to test the form
that we created some variation function
now we kicking it is us to enter the
login ID
this involved in 90 long an idea quiet
on the title and this one is maybe
information now set for us on the web
John and click OK and now its six
press into possible opening for
possible in also one two three and then
get okay and is in curry plumbing ideal
password for this one for now let's see
the user table information i put k 1 and
it was one two three four
password ok and we will learn a lot in
forum or pay one long in adp and pi 1 2
3 4 freak okay
its meaning is to do something
ok left on we will design the role in
the code again it is correct else we do
you can put massive code here of
log in ID and password koi try an A one
one of your full
come on in and password only need advice
will call it next step we do something
it is calling
we open the phone that we want to go
you know when is currently mean if we
can go next day open forum and do
something we use a open forum open some
form will see in the dark
well then I'm navigating the application
form and we put this as comment we want
to see this
he called this fall implication
fig ok they go