how do you disable the navigation buttons at the bottom of a form.

[Guest]

I have a program that is a timesheet program. You clock in and out and tell
where you are going. The problem comes when if a person uses the scroll
option on the mouse it lets them go to other people records. How do you stop
a person from scrolling through the records? Is there a way to stop the next
record button? Please Help.

 

[Wayne Morgan]

The navigation buttons at the bottom can be removed by setting the
"Navigation Buttons" option on the Format tab of the form's Properties sheet
to No. The mouse wheel though is something else. See if this link to Stephen
Lebans's site will help.

http://www.lebans.com/mousewheelonoff.htm

 

[Brian]

I have a program that is a timesheet program. You clock in and out and tell
where you are going. The problem comes when if a person uses the scroll
option on the mouse it lets them go to other people records. How do you stop
a person from scrolling through the records? Is there a way to stop the next
record button? Please Help.

There are various ways a user can move from one record to another, it's not
really practical to disable them all. A far better solution would be to get
the user to log on or somehow identify themselves, and then set the record
source of the form to show only their record. For example, if your table is
called "timesheets", then you want a record source for the form that is
something like SELECT * FROM timesheets WHERE employee_id = 75

Then, if you set the form's AllowAdditions property to No, the user can only
see that record, and can't get out of it, not even to a new record.