Code Examples

Move To First Record

acCmdRecordsGoToFirst

This code moves the cursor to the first record. It is designed to be put behind a button called cmdFirst.

'***************** Code Start *******************
' This code was originally written by Terry Wickenden.
' It is not to be altered or distributed,
' except as part of an application.
' You are free to use it in any application,
' provided the copyright notice is left unchanged.

Private Sub cmdFirst_Click()
On Error GoTo ErrFirst

DoCmd.RunCommand acCmdRecordsGoToFirst
Exit Sub

ErrFirst:

Select Case Err
    Case 2046
      'Command not available
      MsgBox "You are already on the first record." , vbInformation, "Not Available"
    Case Else
      MsgBox Err.Number & ":-" & vbCrLf & Err.Description
End Select

End Sub

'****************** Code End ********************

© 1998 - 2011 Terry Wickenden TKW Design Site developed maintained and hosted by TKW Design. This site is best viewed at 1024 x 768. Optimised for Firefox.