Solved

What is the Not Equal sign for VBA?

Posted on 2006-06-27
13
4,117 Views
Last Modified: 2008-01-09
Just need to know the not equal to symbol for programming in VBA.

Refering to question - http://www.experts-exchange.com/Applications/Q_21899670.html

the next step is to add an else if statement saying if txtUserID and txt UserPW is not equal to .....

THEN

open formError
0
Comment
Question by:neelyjer
  • 8
  • 4
13 Comments
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995717
<>
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995728
neelyjer, you don't need to have ElseIf, instead, have Else

If(txtUserID = "Manager"...) Then
    ' Do something
ElseIf(txtUserID = "User"...) Then
    ' Do something else
Else
    ' Invalid username/password combination
End If
0
 

Author Comment

by:neelyjer
ID: 16995732
I'm a jack@$$....


I meant to ask for the unhide function.

I ALREADY HAVE THENOT EQUAL TO!!!!

RAISING POINTS TO 250
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 16995736
txtUserID <> value AND  txtPassword <> value

--- or ---

not ( txtUserID = value or  txtPassword = value )
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995768
txtUserID.Visible = True
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995778
Did I understand it properly ? What do you want to unhide ?

If you are asking to close the form after clicking Cancel,

Me.Hide  will do
0
 

Author Comment

by:neelyjer
ID: 16995787
Harish,

After entering an incorrect username and/or PW a the login for is hidden and a form opens displaying an error message.  After clicking OK on the error message, I am closing the error form - Unload Me - and unhiding the login form.
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995814
So, what is your problem ? :P
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995831
If you want to hide another form, put the name of that form instead of Me...

fromLogin.Hide
0
 

Author Comment

by:neelyjer
ID: 16995851
I need to unhide the form that I was hidden after incorrect userID.  How do I unhide the form?
0
 
LVL 37

Accepted Solution

by:
Harisha M G earned 300 total points
ID: 16995864
frmLogin.Show
0
 

Author Comment

by:neelyjer
ID: 16995884
Perfection.  I'm not a dentist but I think we could've pulled teeth quicker than that.
0
 
LVL 37

Expert Comment

by:Harisha M G
ID: 16995902
:)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
The viewer will learn common shortcuts with easy ways to remember them. The viewer will then learn where to find all of the keyboard shortcuts, how to create/change them, and how to speed up their workflow.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

809 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