-
December 3rd, 2001, 08:47 PM
#1
database BOF and EOF
okay here it is... i have a database form and the database is connected thru dao and not hard coded in.....but i am having problems with EOF and BOF.....
private sub command1_click()
data2.recordset.movenext
end sub
where and how would i put in the BOF and EOF code
to stop the move at the EOF and BOF
thanx in advance
midnightservice
-
December 3rd, 2001, 09:44 PM
#2
Re: database BOF and EOF
Do While rs.EOF = false And rs.BOF = false
List1.AddItem rs!f2
rs.MoveNext
Loop
Srinika
If u don't know how to Rate an answer, then Rate my answer to learn, If u know, then practice it
-
December 4th, 2001, 02:18 AM
#3
Re: database BOF and EOF
private sub command1_click()
if not data2.recordset.Eof then
data2.recordset.movenext
end if
end sub
RK
-
December 5th, 2001, 06:30 AM
#4
Re: adding to others...
private sub command1_click() 'to scroll forward
if not data2.recordset.Eof = true then
data2.recordset.MoveNext
end if
end sub
private sub command2_click() 'to scroll backward
if not data2.recordset.bof = true then
data2.recordset.MovePrevious
end if
end sub
Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Michael
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
The Rater
...at present time, using mainly Net 4.0, Vs 2010
Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|