Onda uz pomoc recordseta...ovako...
Code:
Dim qdf As QueryDef
Dim rst As Recordset
Dim dbs As Database
Dim asd As String
Set dbs = CurrentDb
Set qdf = dbs.CreateQueryDef("tmpQ", "SELECT * FROM TXT_01")
Set qdf = dbs.QueryDefs("tmpQ")
Set rst = qdf.OpenRecordset(dbOpenDynaset)
rst.MoveFirst
rst.MoveNext
rst.MoveNext
rst.MoveNext
rst.MoveNext
rst.MoveNext
rst.MoveNext
asd = rst!TEKST
Debug.Print asd
dbs.QueryDefs.Delete "tmpQ"
I dobijas taj string...
Samo, umesto onih 50 MoveNext, trebalo bi da stavis nekakvu petlju koja ce ga pomeriti neki broj puta...
Sedam sutlijasa,
za sedam samuraja,
za sedam tramvaja.