Access 2000 - empty records

Y

yan

Hello,

With some forms, I keep creating empty records. It seems that it happens
when the form is based only on one table; I usually use a query to be sure I
don't lock the table.
Any idea how I can protect the form to be sure it doesn't appear?

I tried to set-up one of the field as required, or to create a mandatory
field in the form, but this create an other issue: one of the user... I
don't know exactly how... always jump from one field to a new record, and is
stuck with the mandatory message... and can get out of the form without
creating a record.

Thank you in advance for your assistance.

Annick
[email protected]
 
T

Tom Wickerath

Hello Annick,

It sounds to me as if the user who somehow jumps to a new record is the one who is creating all
of your blank records....does this user has a mouse wheel? If so, encourage them to not spin it.
You can use Stephen Leban's mousewheelhook utility to disable a mouse wheel:
http://www.lebans.com/mousewheelonoff.htm
I usually use a query to be sure I don't lock the table.
Click to expand...
A bound form will cause a record being edited to be locked, whether the recordsource for the form
is a query or table. If you are editing an existing record, you may also be locking additional
records in the table, depending on the locking option set, "page" size, and other factors.

Are you at all comfortable using VBA code? You can use the form's Before_Update event procedure
to check that all required fields have been filled in and, if not, to cancel the event (ie. don't
add the record).

Tom
__________________________________________


Hello,

With some forms, I keep creating empty records. It seems that it happens
when the form is based only on one table; I usually use a query to be sure I
don't lock the table.
Any idea how I can protect the form to be sure it doesn't appear?

I tried to set-up one of the field as required, or to create a mandatory
field in the form, but this create an other issue: one of the user... I
don't know exactly how... always jump from one field to a new record, and is
stuck with the mandatory message... and can get out of the form without
creating a record.

Thank you in advance for your assistance.

Annick
[email protected]
 
Top