Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - Report control instead of listview
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Report control instead of listview

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


Joined: 14 January 2009
Location: Philippines
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote cjzer Quote  Post ReplyReply Direct Link To This Post Topic: Report control instead of listview
    Posted: 07 February 2009 at 9:28am


Public Sub Populate()
Dim i As Integer
    Set rs = New ADODB.Recordset
    'If rs.State = 1 Then rs.Close
    rs.Open "SELECT DISTINCT studentno, fname FROM studentinfo;", db, adOpenDynamic, adLockPessimistic
    lstSubject.ListItems.Clear
    i = 1
    While rs.EOF = False
        lstSubject.ListItems.Add
        lstSubject.ListItems(i).Text = rs(0)
        lstSubject.ListItems(i).SubItems(1) = rs(1)
        i = i + 1
        rs.MoveNext
    Wend
    rs.Close
    Set rs = Nothing
    
End Sub
'==================================================

I used the code above but it won't work when I use it to the report control...
I'm confused ... I can't understand the samples of report control please help

I want to use the report control using the recordset.

Please help for the codes...

thanks...
 

Back to Top
Aaron View Drop Down
Senior Member
Senior Member
Avatar

Joined: 29 January 2008
Status: Offline
Points: 2192
Post Options Post Options   Thanks (0) Thanks(0)   Quote Aaron Quote  Post ReplyReply Direct Link To This Post Posted: 10 February 2009 at 12:26pm
Hi,
 
There are samples in Sample forum: https://forum.codejock.com/forum_posts.asp?TID=11178
 
 
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2
Language: Visual Basic 6.0

Zero replies is not an option....
Back to Top
cjzer View Drop Down
Newbie
Newbie


Joined: 14 January 2009
Location: Philippines
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote cjzer Quote  Post ReplyReply Direct Link To This Post Posted: 11 February 2009 at 12:00am
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.047 seconds.