hello to every one! have a nice day! pls help me how to arrange data alphabetically in the data report which came from the data environment designer.. i want to keep records in ascending form such as last name. i am creating a students record and i want that their names be arranged in alphabetical order. is there way to do that! thanks all for you response!
Dim dbCn As String
Dim conn As ADODB.Connection
Dim rptCn As Connection
Dim rptRs As Recordset
Public Sub RptConnect()
Set rptCn = New Connection
rptCn.CursorLocation = adUseClient
rptCn.Open conn
End Sub
Private Sub cmdPrint_Click()
Call RptConnect
Set rptRs = New Recordset
rptRs.Open ("Select * From tbluserlog Oder By LastName"), conn
Set rptUserlogAll.DataSource = rptRs
rptUserlogAll.Show 1
End sub
if there anything wrong just tell me..
Reputation Points: 13
Solved Threads: 1
Junior Poster in Training
Offline 54 posts
since Sep 2006
Unsolved 
