error mapping

Question

Hi

Is there a friendly way of error mapping

basically if the database runs out of data I get message 2105 cannot go to the specified record

I want to change that just to read something like" No records available"

Is there any free code that can help with this please

thanksyou

Answer 1

perfect

thank you so much, great help

is there also a way I can either remove or rename the box to not show ms access in the title box

Answer 2

Hi Mark,

The On Error Goto goes at the top of the sub. The Exit and what follows goes at the bottom. Your code goes in between.

Answer 3

Your code is supposed to go between

On Error Goto Err_Form

and

Exit_Form:

Answer 4

hi scott

thanks for your help

I have a command button,(cmdClick) that simply moves to the next record

I have tried to put this code in after DoCmd.GoToRecord , , acNext and nothing happened 

any ideas most appreciated

Answer 5

Hi Mark, I'm an independent adviser and will try to help.

Access has error trapping. The error you refer to is a Form error which means it occurs when you try to move from record to record. So, I believe, you would need to put your error trapping code in the Form's On Error event.

The code would look like this:

On Error Goto Err_Form

Exit_Form:

 Exit Sub

Err_Form:

 Select Case Err.Number

      Case 2105

           MsgBox "No Records Available"

      Case Else

            MsgBox Err.Number & "-" & Err.Description

 End Select

However, if you are using other than the Navigation button to move to another record, you might have to put that code in the method you are using to change records.

I would do a search on 'MS Access error trapping" to find several articles on how to do error trapping in Access.

If you need any further clarification on this please feel free to ask.