data entry only- no more new records

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

Guest

I am using a form as an evaluation and do not want them to be able to create
more than one without closing the form and reopening it.

My form automatically chooses a new record when the scroll button on my
mouse moves down. I only want 1 NEW record to come up everytime. please help!
 
My form automatically chooses a new record when the scroll button on my
mouse moves down. I only want 1 NEW record to come up everytime.
Click to expand...

Use Stephen Lebans's Mousehook.DLL to disable the scroll wheel. Please see
the following Web page:

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

Also ensure that the form's Data Entry Property is Yes.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
 
Depending on how you setup your form, then this solution might help you

Basically if your form was design to be a single form for submitting, you
can do the following:

1.Design you form in the form header of a form set to continuous form:
2.Shrink the detail section down to zero and disable the grow property:
3.Everything from text boxes to command button can go in the form header as
well
-they will still work as if you were designing a single form

The scroll on a mouse not have an affect at all now

This solution only work for form that were intended to be single form. You
will not be able to add a subform when using this method
 
Forgot to mention this: Why use my method in the first place when you got a
code that works perfectly by Stephen Lebans's .

Only reason is you might want to use my method is to create a access
application without using code.
 
Back
Top