Visual Basic Login Form Using Access Database Part 1

IF YOU DONT HAVE ANYTHING CONSTRUCTIVE TO SAY THEN DON'T SAY IT!!

For Part 2 got to
http://www.youtube.com/watch?v=sDdTOy...

Text file to follow:
http://www.mediafire.com/view/?3acbg3...

Final Project:
DO NOT JUST COPY AND PASTE
http://www.mediafire.com/download.php...

---

Closed Caption:

I guess today i will be showing you how
to create a visual basic login form
using the AVO DB connection method i'm
attaching to a access database
ok so we want to create a new for
mongolian login DB you're looking for
mother and and we're going to add a
button to text boxes and a label and
into label sorry and we will eventually
remain them as texts user flow the first
text box text pass for the second text
box command login for the bottom and
we're going to rename the label texts as
user name and password just tell the
user or us even that that's what these
fields
yeah
ok so after this we're going to save our
database and remove your location
because we'll be saving so we're going
to say that project remember the
location because of databases going to
put in there
alright so just leaving this because I
tried multiple times to get it right now
let's create on your database
ok i will call mine login DB right and
once where we're going to go into our
design view save out table as user table
and we're going to had training fields
calls username and password both hands .
attack text
ok so here we go to design view table
right no use a username password
remember your table name and fields
because we're going to use the actual
names in the logical in the project
ok so this new records and we need to
save our databases 2002-2003 which is
IMDb format just because we do don't
argue
ok now we need to go to our project
location
ok and it's going to be under your
project your project in debug and say to
their for 64-bit computers right we need
to go your project name the project name
and then Ben x86 and then debug just
because this you like to be difficult
and builds from two different locations
you'll see why the end of this video ok
so now we're going to add a reference
ok so right bring your solution Explorer
you need to right click on your project
name fine and reference now we're going
to go into com tab find microsoft active
x data objects 2.5 life
re just 2.5 and actually tested it with
any of the other versions so yeah now
you can read the comments to understand
what's going on i will try to keep up
with me be typing so do not define a
login error as a string so that we can
tell the user what their login problem
is when they actually try login
okay after this we're going to create a
public function we're going to name it
login you can name anything really
doesn't really matter and inside this
function will put actual hard code and
on the button
we're simply going to call this function
just keep things neat or lets you access
this function in different forms etc I
won't explain how okay now remember we
down reference the Microsoft Active
external object library we're going to
define some stuff you going to define DB
con-con as adodb.connection as a new
adodb.connection at that and says
they're this tells visual studio and
where or how to connect to a database
using the provider and our database
location etc now we need for login form
you need our connection and we need a
recordset which is what we pass all-out
arguments through basically not very how
many arguments in login form except this
method is not just for login forms
ok so this is these two variables are
our only true really complicated
variables with all adodb.connection la
la you're going to find user name as
string and we will put out query or
query in quotation marks in like into
the string so that we can send it to our
records set going to find user DB string
as well and this will get set through
the field user name of our database and
same thing with dim past DB except for
the password field in a database
ok and after this we're going to open
our connections is important that you
pay attention to what i am typing
because you cannot miss a single thing
including semicolons in quotes or
anything in quotes for example our
provider when i get to it