please give time to answer this, i really need this for my thesis...tnx
this is my code:
Public Sub PRINTTORGRADES()
Data.con = New OleDbConnection
Dim cmd As New OleDbCommand(Data.PrintTORGrades(CurrentStudent), Data.con)
Data.OpenConn()
Dim dr As OleDbDataReader
dr = cmd.ExecuteReader()
If dr.HasRows Then
dr.Read()
Dim Grades As String
Grades = dr("Name")
oDoc.Bookmarks.Item("FirstYear1").Range.Text = Grades
End If
dr.Close()
End Sub
this only gives the bookmark the first record not the entire column.