Disable Record Scrolling

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

Guest

I've got forms for entering data into my database. Just now the operators
can browse through all the records using the mouse wheel or the buttons at
the bottom of the form, is there any way to disable these features?

Thanks for the help

Tommy
 
There's a property under the "other" tab on the property sheet. If you set it
to cycle current record, then the user can only see the record you select for
him/her.
 
It depends on the exact limitations you wish to have. If you set the form's
Data Entry property to Yes, users will be able to add records, and edit
records created during the current Access session. If Allow Edits is set to
No (along with Data Entry to Yes), users will be able to add records only,
and will be able to see only records from the current Access session. If
Allow Edits is set to No and Data Entry to No, users will be able to add
records only, but will be able to see all records. If Allow Additions and
Allow Edits are set to No, users will be able to view records only. Or you
can do away with the built-in navigation buttons, and add a custom button
that will add a new record only. You can combine any of the above with the
MouseWheel suggestion in this thread. It all depends on the details of what
you need to do.
 
The way my database is set up there is a front end on seven PC's, each stored
on the computers C drive, and a back end stored on a server. Will the
mousehookdll go into the C drive of each machine next to the fe's or on the
server next to the be? Also will this stop the mouse wheel working
altogether or would it just switcch it off in access?

Thanks for the help

Tommy
 
Put the dll on the C drive of each machine next to the front-ends.

Note that it's not simply a case of copying the dll, though. There's a class
in the sample database that you need to import into your front-ends, and
there's code that you have to add to the Open and Close events (or is it the
Load and Unload events?) of the each form where you need the mouse disabled.
(In other words, it only works with Access, not generically)
 
Back
Top