?
Solved

Login form in VB 2010 express

Posted on 2011-03-19
2
Medium Priority
?
872 Views
Last Modified: 2012-08-13
Hello there...
I have been developing in MS Access for the last 10 year and frankly I don't understand VB...
I have an MDF File (MyMDFFile.mdf) and have a login form with two text boxes usernametxt and passwordtxt. I also have a an OKbtn and a Cancelbtn. within the MyMdfFile i have an accounts table, which stores all usernames, passwords and access levels.
What I want is the user to enter its username and password and then click the Okbtn. the OKbtn runs some type of code where it goes and check the username and password in the accounts table. and if ot maches it opens up the Mainform(Mainfrm).
Frankly, I have read a whole bunch of examples but nothing really walks me thru the process. I know how to do it in access but no clue in VBA.
Any help there???
0
Comment
Question by:raleon18
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 35173701
It might be a good idea to change the zone, or at least add the correct development zones (for VB) to your inquiry.  
0
 
LVL 7

Accepted Solution

by:
Alpha Au earned 2000 total points
ID: 35186148
As You Mention a MDF file, are you using SQL Server, or Access(MDB)??

if you are using SQL Server, you'll need to attach the MDF file to SQL Server and let the program (VB.net) connect to SQL Server.

and i think the following tutorial can help you
http://www.google.com.hk/search?q=vb.net+login+form+tutorial&hl=zh-TW&client=firefox-a&hs=jvC&rls=org.mozilla:en-US:official&prmd=ivns&source=univ&tbm=vid&tbo=u&sa=X&ei=bAqITZ2OGYyHcfys3bQM&ved=0CG0QqwQ
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question