Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Is that possible to search within column
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Is that possible to search within column

 Post Reply Post Reply
Author
Message
debehs View Drop Down
Newbie
Newbie


Joined: 30 December 2005
Location: Malaysia
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote debehs Quote  Post ReplyReply Direct Link To This Post Topic: Is that possible to search within column
    Posted: 17 January 2006 at 3:32am

Hi,

in the ReportView, let say, I would like to search for a keyword call "cybeh", within column 1 in my Report view, and the search return a row number. Is that possible to make it?

Please advice. Thanks.

Back to Top
sserge View Drop Down
Moderator Group
Moderator Group


Joined: 01 December 2004
Status: Offline
Points: 1297
Post Options Post Options   Thanks (0) Thanks(0)   Quote sserge Quote  Post ReplyReply Direct Link To This Post Posted: 18 January 2006 at 2:53pm
Hi,

Iterate all rows and find your one. Something like the following:

    Dim Row As ReportRow
    For Each Row In wndReportControl.Rows
      If Not Row.Record Is Nothing Then
        If InStr(1, Row.Record.Item(COLUMN_SUBJECT).Value, "cybeh", vbTextCompare) > 0 Then
             MsgBox Row.Index
        End If
      End If
    Next


--
WBR,
Serge
Back to Top
debehs View Drop Down
Newbie
Newbie


Joined: 30 December 2005
Location: Malaysia
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote debehs Quote  Post ReplyReply Direct Link To This Post Posted: 18 January 2006 at 10:05pm
Thanks.
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.059 seconds.