Codejock Developer Community : how find row? http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 15:27:56 +0000 Thu, 10 Jul 2008 07:52:39 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=11144 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[how find row? : It&#039;s very simple: dim...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=38124&title=how-find-row#38124 Author: Baldur
Subject: 11144
Posted: 10 July 2008 at 7:52am

It's very simple:
 
dim xReportRow as ReportRow
dim xMyTag as variant
 
for each xReportRow in ReportControl.rows
  if xReportRow.Record.Tag = xMytag then
     ReportControl.FocusedRow = xReportRow
     exit for
  end if
next
 
The same can do with each property.
]]> Thu, 10 Jul 2008 07:52:39 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=38124&title=how-find-row#38124 <![CDATA[how find row? : Hi, Here&#039;s s test project....]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37243&title=how-find-row#37243 Author: Aaron
Subject: 11144
Posted: 23 June 2008 at 8:51am

Hi,
 
Here's s test project. Copy your database in the same directory as the project and change the database and table name in the form load event. Data will be loaded and you can change the items as you wish and are updated in the database!!! So don't use your original database
 
 
 
uploads/20080623_085013_TestReportContr.zip
 
 
Good luck !
 
 
]]> Mon, 23 Jun 2008 08:51:58 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37243&title=how-find-row#37243 <![CDATA[how find row? : hi example , i want add this...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37234&title=how-find-row#37234 Author: mozaheb
Subject: 11144
Posted: 23 June 2008 at 7:47am

hi

example , i want add this option for user to select checkmark for show number o same name for each contact if find name in database...

now if found number replace number with contact name, and i want replace record in RC in a few second.

my data base : access (MDB)


example source :

Sub Refresh_Inbox()
    Dim DataInbox As ClsDataBase

    Set DataInbox = New ClsDataBase

    LstInbox.Records.DeleteAll
    LstInbox.Populate

    Call DataInbox.Get_AllRecivedSMS(SMSReciveRecords, PCon)


    While Not ContactsRecords.EOF

        Call AddRecordList(ContactsRecords!ID, ContactsRecords!Active, ContactsRecords!Name, ContactsRecords!MobileNum, ContactsRecords!GroupName, ContactsRecords!Field1, ContactsRecords!Field2, ContactsRecords!Field3, ContactsRecords!Field4, ContactsRecords!LastSend, ContactsRecords!SmsCount)

        ContactsRecords.MoveNext

    Wend

    'Updates the Report
    LstInbox.Populate
    LstInbox.FocusSubItems = False


End Sub

thank you
]]> Mon, 23 Jun 2008 07:47:25 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37234&title=how-find-row#37234 <![CDATA[how find row? : Hi, Virtual mode is like you...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37231&title=how-find-row#37231 Author: Aaron
Subject: 11144
Posted: 23 June 2008 at 7:27am

Hi,
 
Virtual mode is like you would open your table (in my case MS Access). The recordset is loaded into ReportControl using the BeforeDrawRow event
 
first row will be the first row in ReportControl
second row will be the second row in ReportControl and so on
 
If you load the recordset of database as records you will have the same as with virtual records (my sample)
 
Show me how you load the records from the database? I want to help you but I don't know: what database you use? how you load records? As I said before upload a sample project and I will help you. If you don't want me to see the data in the database make a sample with some dummy data. As long the columns are the same as yours so it isn't to difficult to change it for your needs.
 
 
]]> Mon, 23 Jun 2008 07:27:54 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37231&title=how-find-row#37231 <![CDATA[how find row? : hi again, thank you buti dont...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37214&title=how-find-row#37214 Author: mozaheb
Subject: 11144
Posted: 23 June 2008 at 5:42am

hi again, thank you

but

i dont use virtual mode...

please guide me
]]> Mon, 23 Jun 2008 05:42:12 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37214&title=how-find-row#37214 <![CDATA[how find row? : Hi, Ok, There are other...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37210&title=how-find-row#37210 Author: Aaron
Subject: 11144
Posted: 23 June 2008 at 5:33am

Hi,
 
Ok,
 
There are other ways of doing this but than I have to know how you load the database records and how your table looks.
 
Maybe you could check this post:
 
http://forum.codejock.com/forum_posts.asp?TID=10814
 
and look for sample:
 
uploads/20080602_072905_ReportVirtualDa.zip
 
 
This will load a recordset into a RC in virtual list mode and you can edit items and will be immediately updated in database.
 
 
 
 
]]> Mon, 23 Jun 2008 05:33:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37210&title=how-find-row#37210 <![CDATA[how find row? : i want use tag for set Record...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37206&title=how-find-row#37206 Author: mozaheb
Subject: 11144
Posted: 23 June 2008 at 4:52am

i want use tag for set Record ID and when update database update Record id, for this problem use tag to find record id and update items of record.


]]> Mon, 23 Jun 2008 04:52:11 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37206&title=how-find-row#37206 <![CDATA[how find row? : Hi, I have been experimenting...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37205&title=how-find-row#37205 Author: Aaron
Subject: 11144
Posted: 23 June 2008 at 4:43am

Hi,
 
I have been experimenting a lot with the ReportControl but I never needed to use the .Tag before. That's why I asked you: Why do you need this anyway? Maybe I can help you and don't have to use the .Tag property at all
 
Here's a function to iterate the RC records
 
Private Function FindTag(strTag As String)
    Dim record As XtremeReportControl.ReportRecord
   
    For Each record In wndReportControl.Records
        If record.Tag = strTag Then MsgBox "Record found... Index = " & record.Index
    Next record
   
End Function
 
 
]]> Mon, 23 Jun 2008 04:43:37 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37205&title=how-find-row#37205 <![CDATA[how find row? : yes yes, please guide me, thank...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37204&title=how-find-row#37204 Author: mozaheb
Subject: 11144
Posted: 23 June 2008 at 4:23am

yes yes, please guide me, thank you]]> Mon, 23 Jun 2008 04:23:59 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37204&title=how-find-row#37204 <![CDATA[how find row? : Hi, You assigned a value to...]]> http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37202&title=how-find-row#37202 Author: Aaron
Subject: 11144
Posted: 23 June 2008 at 4:11am

Hi,
 
You assigned a value to a tag? And you want to find the value (tag) in all records?
 
May I ask why you want to this?
 
 
]]> Mon, 23 Jun 2008 04:11:07 +0000 http://forum.codejock.com/forum_posts.asp?TID=11144&PID=37202&title=how-find-row#37202