Error on Next record

[duvenhlc]

I need help again,

How can I prevent the error "can't go to next record" I have a DB where one can scan through the records with command buttons. I do not use the "standard" record selectors of the form.

Any suggestions

Lance

 

[wazz]

there may not be a next record. check for the end of the recordset first (and the beginning).

 

[duvenhlc]

Hi, Wazz

You are right, it is at the end of the recordsets. Is there code to check for the end of the recordset to prevent the error mesage.

Thanks

 

[wazz]

search these forums and help files for recordsets and BOF (beginning of file) and EOF (end of file). in vba help just type bof and you'll get 'BOF, EOF Properties'.

 

[duvenhlc]

Do you maybe have an example, I attached a sample database what I tried. Can't get it to work.

Regards

Lance

 

[boblarson]

Just change your error handlers to this:

Err_next_Click:
    If Err.Number <> 2105 Then
        MsgBox Err.Description
        Resume Exit_next_Click
    End If

 

[duvenhlc]

Bob, I cant get it to work. It still giving me the error.

Thanks

Lance

 

[boblarson]

Bob, I cant get it to work. It still giving me the error.

Thanks

Lance

My goodness, all you had to do was add the

If Err.Number <> 2105 Then
...the other stuff

End If

into each of the error handlers. See the attached, revised sample.

 

[duvenhlc]

Bob, I used the sample on the PC at work with Access 2003 and it works fine. I am on 2007, and it is not working. Is there differance between the coding?

Lance

 

[boblarson]

Bob, I used the sample on the PC at work with Access 2003 and it works fine. I am on 2007, and it is not working. Is there differance between the coding?

Lance

Nope I actually did it on Access 2007 too at home and it was fine. Are you sure you've set the database location as a trusted location?

 

[duvenhlc]

Thanks,

I will try it tonight, wish me luck.

Lance