Solved

Listview Question

Posted on 2002-03-21
9
216 Views
Last Modified: 2010-05-02
Hello Experts:

I have a listview that contains a list of clients.  Column 1 contains the clientid and column 2 contains the client name.

I also have a janusys grid on the form which will display a filtered invoice listing based on the client that is selected in the client listview.

I have recently added a search button to allow the user to search for an invoice, which works correctly, by displaying the invoice that was searched for in the janus grid.  However, I also want to highlight the client in the client list that the invoice corresponds to, I've tried several things with no results.

Here is what I am trying

ClientList is the Listview displaying the clients
strReturnCustomer is the clientid field Im trying to match up to column 1 in the listview

For Counter = 1 To ClientList.ListItems.Count
     If ClientList.ListItems(Counter) = strReturnCustomer Then
                ClientList.ListItems(Counter).selected= True
     End If
Next

Thanks

VB 6.0
0
Comment
Question by:escheider
  • 5
  • 3
9 Comments
 
LVL 1

Expert Comment

by:CodeWizrd
ID: 6886930

If you are checking on customer number, then change your if statement to:

If ClientList.ListItems(Counter).subitems(1) = strReturnCustomer Then

This way you are validating only the first column in your list box.
0
 
LVL 4

Author Comment

by:escheider
ID: 6887036
ClientList.ListItems(Counter).subitems(1) would reference the customer name, not the customer id.
0
 
LVL 1

Expert Comment

by:CodeWizrd
ID: 6887078

oops...I typed a 1, didnt I?  Problem with coding too many languages...

Did the subitem help you match your customer id and highlight the row you wanted?

0
 
LVL 4

Author Comment

by:escheider
ID: 6887104
no,

ClientList.ListItems(Counter) appears to be referencing the clientid column, but ClientList.ListItems(Counter).selected= True doesn't appear to be working.  The IF statement is triggered, but the client being referenced is not highlighted.
0
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 4

Author Comment

by:escheider
ID: 6887109
hmmm, i put a clientlist.setfocus above the clientlist.listitems(counter) line, and it appears to work now.
0
 
LVL 1

Expert Comment

by:CodeWizrd
ID: 6887114

Interesting...well, congrats on getting it working!
0
 
LVL 4

Author Comment

by:escheider
ID: 6887192
freaky...do you want the points or should I delete this question??
0
 
LVL 4

Author Comment

by:escheider
ID: 6889468
Since I answered the question myself, I decided to delete this question.  Thanks for your input though
0
 
LVL 5

Accepted Solution

by:
Netminder earned 0 total points
ID: 6909084
Per request, points refunded and question closed by
Netminder
CS Moderator
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

757 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

27 Experts available now in Live!

Get 1:1 Help Now