disable form record scrolling final solution

[antonyx]

ok.. i have searched many posts on this forum..

what i want to do is not allow my user to scroll through records using the mouse wheel..

whether the mouse wheel is locked or not... i just dont want the form to allow more than one record to be accessed at once..

when the form opens.. i want a new record to be created so at the moment i am using this..

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acNewRec
End Sub

now i have tried to disable the mouse wheel using this very helpful link..
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q278379

there are two ways to do it.. one using visual basic and one through ms access (middle of the page..)

i tried using the method within access but it slows my form down and makes access not respond.. which in fairness the site does say this may happen..

so.. what can i do.. will i have to purchase visual basic and make the dll myself and make sure that the dll is present on all the machines that the db will be opened on..?

is there not a simpler way to ensure that a form will open.. allow the user to enter a new record ONLY..

i know you can set the cycle to 'current record' and remove the navigation buttons.. etc.. but the mouse wheel problem still exists..

so please.. can someone suggest a better easier solution..

 

[Niniel]

I am using this method:

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

 

[antonyx]

thats is much better.. and easy.. thanks..

 

[Niniel]

Glad I was able to help.
That guy has a number of interesting things on his site, it's worth browsing around a bit.

 

[Niniel]

Oh, and by the way - "final solution" doesn't sound so good since that term acquired a certain notoriety about 60 years ago.

 

[antonyx]

yes.. it is a bit of a poor title..

 

[AlanS]

Depending on how the form's .Cycle property is set, the user may still be able to scroll through records using the keyboard. You can limit the user to only a single new record regardless of that setting, by making the following settings in the Form_Load event procedure:
.AllowAdditions = True
.AllowDeletions = False
.AllowEdits = False
.DataEntry = True

If you want to limit the user to editing only a single existing record, use these settings:
.AllowAdditions = False
.AllowDeletions = True
.AllowEdits = True
.DataEntry = False