hak66
asked on
EOF Formate
"Data1.Recordset.MoveNext or MovePrevious" When I type this code and hit the command button, I get error message. I know that I need to Type EOF or BOF for each data control but I don't know how, can you please email me the code for EOF and BOF to dispaly my database within VB without getting an error message. Thanks
my email is Hadorth11@aol.com
Thanks
my email is Hadorth11@aol.com
Thanks
You may have to open the record first, can tell me what are you exactly trying to achieve, may be I can help.
I goes something like this ...
IF EOF(#filenumber) then exit do
IF EOF(#filenumber) then exit do
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try placing this code in your command button's click event:
If Data1.Recordset.EOF = True or Data1.Recordset.BOF = True Then
Exit Sub
End If
Data1.Recordset.MoveNext
or
Data1.Recordset.MovePrevio us
If Data1.Recordset.EOF = True or Data1.Recordset.BOF = True Then
Exit Sub
End If
Data1.Recordset.MoveNext
or
Data1.Recordset.MovePrevio
ASKER
Thanks, I will be contacting you after I try it. I appreciate your time and consideration!!!!