Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

What is the Not Equal sign for VBA?

Posted on 2006-06-27
13
Medium Priority
?
4,133 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
[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
  • 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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
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 1200 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Developer portfolios can be a bit of an enigma—how do you present yourself to employers without burying them in lines of code?  A modern portfolio is more than just work samples, it’s also a statement of how you work.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
Video by: Tony
This video teaches viewers how to export a project from Adobe Premiere Pro and the various file types involved.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…

715 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