Solved

Login form in VB 2010 express

Posted on 2011-03-19
2
858 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
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:
alphaau earned 500 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now