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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
William said:
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.
Click to expand...

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.
 
Back
Top