Re: EOF question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Daniel,

Try to trap the error, see if this work for you.

err_handler_Exit:
Exit Sub
err_handler:
If Err.Number = 2105 Then 'trap the error code here
KeyCode = 0
Resume err_handler_Exit
Else
MsgBox Err.Number & "-" & Err.Description
End If

daniel wrote:
in a form, I don't want the user to go to a new record when he is on the
last record..
if I use OnKeyDown or Press and set downkey to 0, that works but then it
will not let me add a new record
even with a 'Add new record' button.
what is the correct solution for that?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200703/1

.

Relevant Pages

  • Resolving Write Conflict in a form
    ... In multi-user database, how can I trap the error code that ... Copy to Clipboard; Drop Changes. ...
    (microsoft.public.access.forms)
  • trapping errors in DLL
    ... errors that might occur and return them to the VBA caller, ... exception being thrown. ... I know I can't trap the exception in the VBA, ... was thinking I might trap with a try/catch in VC++ and return an error code ...
    (microsoft.public.vc.language)
  • Re: Trap d in OS2KRNL
    ... Barry Landy wrote: ... :>> I am getting a consistent trap d in OS2KRNL when trying to access the Help ... Apart from it crashing spectacularly just after resetting the workplace (same code d in os2krnl, apparently at the same place) the INI files now seem pretty clean and the effect is still present. ... FWIW the error code d is at location fff1da1f = ca1f relative ...
    (comp.os.os2.bugs)
  • Re: Page Up and Down Keys
    ... Try to use the error handling to trap the error.Like.... ... Select Case KeyCode ... If Err.Number = 2105 Then 'trap the error code here ... specified record. ...
    (microsoft.public.access.formscoding)
  • Re: to run code when user click on CTRL-F
    ... which will let you trap keystrokes on a form. ... If KeyCode = vbKeyF Then ... If (Shift And vbCtrlMask) = vbCtrlMask Then ...
    (microsoft.public.access.formscoding)