login validation -
Good day to all!
I am having a problem regarding on login validation using VB 6.0 and SQL Server 2000.
The validations are:
1.if the user doesn't input anything in txtUserName and txtPassword
then a messagebox will appear with message "Either username or password contains nothing. Please retry."
2.if the user doesn't have any account then he tried to login
then a messagebox will appear with message "The User is not yet registered. Please register first before you login."
3.(here is my problem) if the user input an incorrect username or password
then a messagebox will appear and a message should be "Invalid username or password. Please retry."
i just want to know what's wrong with my program, because whenever i try to login with incorrect username and password, the messagebox "The User is not yet registered. Please register first before you login." always show instead of the messagebox "Invalid username or password. Please retry." ...
can you please help me with this problem. i would really appreciate if you do.
here is my program:
Private Sub cmdOK_Click()
Dim strName As String
Dim strPass As String
Dim strSql As String
Dim blnName As Boolean
blnName = False
Connect
strName = txtUserName.Text
strPass = txtPassword.Text
strSql = "select * from emp_admin where uname = '" & Trim(strName) & "' and pass = '" & Trim(strPass) & "'"
com.CommandText = strSql
com.CommandType = adCmdText
Set recset = com.Execute
If txtPassword = "" And txtUserName = "" Then
If MsgBox("Either username or password contains nothing. Please retry.", vbOKOnly, "login failed") = vbOK Then
frmLogAdmin.Show
End If
txtUserName.Text = ""
txtPassword.Text = ""
txtUserName.SetFocus
Else
With recset
If .EOF Then
If MsgBox("The User is not yet registered. Please register first before you login.", vbOKOnly, "login failed") = vbOK Then
frmLogAdmin.Show
End If
txtUserName.Text = ""
txtPassword.Text = ""
txtUserName.SetFocus
ElseIf Not .Fields("uname") = strName And .Fields("pass") = strPass Then
If MsgBox("Invalid username or password. Please retry.") = vbOK Then
frmLogAdmin.Show
End If
txtUserName.Text = ""
txtPassword.Text = ""
txtUserName.SetFocus
Else
Me.Hide
Call Shell("C:\Documents and Settings\jsarmiento\Desktop\newProjectCRM\CRM\CRM_Admin\CRM_Admin.Exe ", vbNormalFocus)
End If
End With
End If
Disconnect
End Sub
Remote Login Validation -
Hi there!
Any of u have an idea,how to establish a connection from a remote server to the main server(IIS) using VB COM for a login validation in our admin Database.
We have developed our product in ASP,and we would like to do remote login validation through VB COM.If t
Starting off with login/registration -
I have made a very basic registration page whereby hitting 'submit' will add the details into my Users table with no validation or anything.
What I want to do now is start setting the login/registration side of my site up so just a few questions I hope you can answer:
1. When I
Question on validation controls. -
Hi,
I have a textbox control, and below two validation controls.
Textbox
validation control1
validation control2
One validation control requires text and the other uses a reg expresion.
The thing is that, if it´s only the second validation control that fires off, a space
NDS validation -
I posted before about domain validation but now
they tell me that I will need NDS validation instead.
Does anyone know of APIs that will perform NDS
validation of a Username and Password?
please help me in login validation -
i have two txtuser and txtpassword and a command button with a caption of login this is my problem how to validate the user name and the password from msaccess database to vb login form. can you show me the command im, using the ado database and another one how to connect the database
Simultaneous user login problem -
Im using VB.Net 2003 and MySQL for my program. I have a login form that is connecting to an online database for validation of the users. When testing the program on a single PC, the log in works ok. Right now, I'm testing it using 2 PC's.
The design of my login is that it sets my u
Login with Database validation -
Hi all, how do I make a login screen which validates the username with a database, preferably with a MS Access database.
thanks
dimava
Best way to... -
connect to a windows 2000 server. Instead of having IIS running on the server, I would like to login to the server remotely and view the contents of a directory for ftp validation. I would need to provide the server with a username/password to login. Best way to go about this?
Password Validation -
Hey
Doing a computing A-Level project, need some help with ADODC and validation.
Basically, I have a screen to login to a system, which i intened to code so that the username and password are validated against a MS access database, to check for corresponding username and password.
A
Validating Access [Resolved by Rob] -
Hi,
I am helping my sister with one of her college project and try to stay away from VBA. Anyhow just need some information regarding VBA in access. I have put validation in the Datbase Itself using validation rules. Now the validation works fine if I input the data directly into tabl
[02/03] User controls problem -
Hello everybody,
In my .aspx page, there are two user controls, one is for login and the other is for signup. When the user types something in the data fields for the signup control and hits Enter key, the form is posted and do validation and insert etc. But when someone types in
Stopping validation temporarily -
I have a question on how to stop field validation from occuring temporarily.
I have a form with textboxes, listboxes, comboboxes etc etc.
a) When I load a form I general preload values into a control inside the form load.
b) Or when a certain controls has data entered I will upd
A different type of validation system -
http://www.drpaulcarter.com/personal/login.php
Validation Help! -
I have a textbox with 2 validation controls assigned to it. A regular expression validator and a custom validator. Is there a way to not allow the custom validator to fire unless the reg exp val passes? I dont want to do the reg exp validation in the custom validater either.
Furt
SQL-Server Validation Text -
Hello Everybody,
How (if it is possible) can i write a validation text like in Access?
I know that i can use constraint expression but i also want to send error message if there was no validation.
Thank you in advance,
ERAN
How can you secure non-ASP files using IIS -
Hi, there.
I have a Website that includes links to files (e.g. PDFs, Excel Workbooks, etc.). Users must login in order to gain access to the Web pages that have the links to these files. However, once they get the files, they have the file URL. After that, they can pass the URL a
[2005] Validation of Viewstate MAC failed -
I got this error and i wonder why?i did a compilation of my asp.net application and deployed it with web setup & i got this below
Validation of Viewstate MAC failed. If this application is hosted by a Web farm or cluster,ensure that <machineKey> configuration specifies the
Proper way to make a login -
I am new to VB.net and have a question about the proper method to startup an application.
I have a user login dialog to load called: frmLogin
If the user submits the correct user name and password I want it to close the login (frmLogin) and open the main MDI form (frmMain).
Cause Validation Problem -
I have created an application where there are many frames. I have created a textbox with the some code in the Validation event to check whether it's blank.
The problem I face is this.
If i create a validation error it will show a message box. Then when I switch to another frame in
Login For Program -
I'd like to make a login screen for a network admin program. Can anyone tell me how to place a login screen where you normally login for windows?
I would like it so that they can login to windows normally but instead of going to windows, it will load up my login screen and then it w
validation in javascript -
i am new in programming
i am having 10 asp forms i want to do validation i create separate file commonfunctions.js where i will keep all common functions in my project
now pl tell me how to write validation code
which will check all textboxes should not be blank how to refer all
sstab and textbox validation -
I have a sstab with 6 tabs. I have a few textboxes on one of the tabs with range checking. When I go from textbox to textbox, validation event executes. But when I am in a textbox and click a tab, validation doesn't execute. Sstab causesvalidation property is set to true. How can I mak
Validation Control Help -
Hi,
Im looking for a way to use a validation control....
what i need to to do, if a particular radio button is selected, and a textbox is empty, display a message, so far i cant think of a validation control...
and i would to be able to do it without having to worry about pos
Validation Control Question -
I am using a Validation control to check if a user has entered in a date in a textbox.
the issue I am having is that when I click the edit button the validation control fires before the user gets a chance to see the data. Is there a way to make the validation control not fire again
Logout error -
I have a login and log out link on my webform. I'm able to login just fine. But when I hit the log out link, I get the error below.
Exception Details: System.ArgumentException: Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation
Validation Expression -
Hi My friends
Could any one tell me what is validation expression which enable user to type alphabetical characters in the textbox from a to z
I have put this validation expression \w[a-z] but it is not working.
Conditional validation lists (Resolved) -
Excel 2003
I have column A which has a validation list. Options are Branch; Staff.
Column B also needs to be a validation list but based on value in column A. If Col A displays Branch then Col B needs to show the BranchList validation dropdown.
If Col A displays Staff, then
Server Side Validation -
Hello,
I have made a custom control for a text field. I have to do server side validation for it. I just want it to see if a password equals a given value, if not validation should fail.
Can someone provide me with some pseudo script as I am new to ASP.NET.
Thanks.
forms validation -
when I am doing validation with the .net validation controls. What if a control needs to be 'required' , and a valid email address? Do I need to add both a custom validator, and a required field validator?
EXCEL: Force User Entry to Modulo - Validation or Macro -
Esteemed Forum Participants and Lurkers:
===============================
Excel 2003
I have a range of cells where the user entered value must be coerced to an even multiple of 0.5.
I'm trying to figure out if I can use the Excel Validation command in the Data menu, or if I hav
email validation -
please any body give validation function or sub for email validation
the email must seperated by camma,
Validation in LostFocus routine -
Hello folks... I am new to VB esp. with database programming so please bear with me..
Involved in a project for the Ambulance Corps. I work for and am doing a simple database front end.
My question to everyone is if it's a good or bad practice to do some validation during the Lo
Help with validation controls -
ASP.NET 2.0, VB.NET 2005
I have a form with multiple views, each being loaded only when called. Each view contains text fields with matching validation controls. By default, these validation controls are disabled, and are only enabled when that particular view is loaded.
So far
Control to validate -
I have a check box which I want users to tick before moving to next page, but the validation control, requiredfieldvalidator, will not pick up the tick box, even if I set the causes validation to true!!
can you use validation on tick boxes and drop downs????
Thanks
Check Login Status -
what i am trying to do here is that when the user enter my site i will check whether they are login or not.. if they are not login i will redirect them to the login page and prompt them that they are not login.. i am using VS 2005..
Login Box Imagery Validation Issue -
Hi there,
Imagine this -
I have a login box which consists of a transparent form. On top of this transparent form I have put a picture box containing, in essence, all the imagery that will be on the form - in a sense, it is the form.
Okay, the username and password boxes were
prevent login twice -
Hi,
Is there a way to prevent login twice?
Let say A login once, and then he starts another browser and login again.
The second time login should not be allowed
Any Idea?
Code would be better
Thanks!
LogIn Attempts -
I have a Screen for User to login with Username and Password. The maximum allowed try is 3 after which the password gets locked. So as soon as the user enter wrong password for the 2nd time, I am expecting to throw a Warning Message.
How can I do this? I am looking for a way to keep
What is an input validation loop -
Can someone tell me what an input validation loop is?
I am doing exercises at the end of a book I am reading, but one tells me to use an input validation loop. The problem is, the book never explains what an input validation loop is. Can someone please explain?
Thanks.
when validation controls work -
I have a form with some textboxes. Each textbox has associated with a validation controls. It seems whenever user pushes a button, ie.'submit', validation controls will validate the input. Now, I want to do sth. like this:
1) user pushes 'submit'
2) check certain textboxes' text. if