Record Navigation bar

[sabre1]

Is there anyway that i can disable certain aspects of the record navigation bar. I would like to keep the fact that they can click forward and backwards on records but i would like to disable the ability to search and to apply filters.



Any help would be greatly appreciated.

[khalid]

Hi,
Yes there is a way,, the form is the best way to show your data to the users, where you have more control over your data to show...

You can create record navigation buttons instead to use the table default navigation buttons...

Hope this help.

[sabre1]

Thanks for your reply Khalid, i did think about doing that however, i like them being able to see what record they are on i.e 5 of 12. Is there anyway of being able to show this?

[khalid]

Thanks for your reply Khalid, i did think about doing that however, i like them being able to see what record they are on i.e 5 of 12. Is there anyway of being able to show this?

Hi sabre,

Record X of Y would solve your problem.

Private Sub Form_Current()

' Provide a record counter for using with
' custom navigation buttons (when not using
' Access built in navigation)

Dim rst As DAO.Recordset
Dim lngCount As Long

Set rst = Me.RecordsetClone

With rst
.MoveFirst
.MoveLast
lngCount = .RecordCount
End With

'Show the result of the record count in the text box (txtRecordNo)

Me.txtRecordNo = "Record " & Me.CurrentRecord & " of " & lngCount

End Sub

This would help.

[sabre1]

Thank you so much for this it worked perfectly.

[khalid]

Thank you so much for this it worked perfectly.

Glad that it worked for you

So are you ready to make this thread as solved? and also the scalling icon and Rate Thread with stars (right top of the post).

Cheers!