Locking form

I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each
session that they can choose, there is a limit to the number of people who
can sign up. Apparently, they cannot follow directions because they always
sign up more people than are allowed in each session. Is there a way to lock
the form for the sessions that are full? If I am not explaining myself very
well, please let me know.

Thanks!

Your question doesn't include any information on how you determine how many
people can be signed up for a session or how you know how many people have
signed up, but basically, you can use the Form's Current event to test for a
full session and set the form's Allow Edits property to false when the limit
is reached.
--
Dave Hargis, Microsoft Access MVP


"MMacPherson" wrote:

I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each
session that they can choose, there is a limit to the number of people who
can sign up. Apparently, they cannot follow directions because they always
sign up more people than are allowed in each session. Is there a way to lock
the form for the sessions that are full? If I am not explaining myself very
well, please let me know.

Thanks!

I determine how many people can be signed up for a session and I inform the
employees by email and by noting it on the form. So, when they open the sign
up, it is at the top of the sign up. I know how may people have signup up by
opening the dt table. Does that help? What happens is I will go into the dt
table to check on how many people have signed up and I will find there are
more than I have allowed openings for. I want to figure out a way to lock
the form, so say when I tell them 10 people are allowed to sign up, that
after 10 have been signed up it will no longer let them submit a sign up form.

"Klatuu" wrote:

Your question doesn't include any information on how you determine how many
people can be signed up for a session or how you know how many people have
signed up, but basically, you can use the Form's Current event to test for a
full session and set the form's Allow Edits property to false when the limit
is reached.
--
Dave Hargis, Microsoft Access MVP


"MMacPherson" wrote:

I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each
session that they can choose, there is a limit to the number of people who
can sign up. Apparently, they cannot follow directions because they always
sign up more people than are allowed in each session. Is there a way to lock
the form for the sessions that are full? If I am not explaining myself very
well, please let me know.

Thanks!

OK, my original post will do what you want. You just need to make the
determination and if the maximum number of people have signed up, set the
Allow Edits to False; otherwise, set it to True.
--
Dave Hargis, Microsoft Access MVP


"MMacPherson" wrote:

I determine how many people can be signed up for a session and I inform the
employees by email and by noting it on the form. So, when they open the sign
up, it is at the top of the sign up. I know how may people have signup up by
opening the dt table. Does that help? What happens is I will go into the dt
table to check on how many people have signed up and I will find there are
more than I have allowed openings for. I want to figure out a way to lock
the form, so say when I tell them 10 people are allowed to sign up, that
after 10 have been signed up it will no longer let them submit a sign up form.

"Klatuu" wrote:

Your question doesn't include any information on how you determine how many
people can be signed up for a session or how you know how many people have
signed up, but basically, you can use the Form's Current event to test for a
full session and set the form's Allow Edits property to false when the limit
is reached.
--
Dave Hargis, Microsoft Access MVP


"MMacPherson" wrote:

I need help! The company I work for has designed a database with a form that
you fill out and submit. The form is open to all employees, but for each
session that they can choose, there is a limit to the number of people who
can sign up. Apparently, they cannot follow directions because they always
sign up more people than are allowed in each session. Is there a way to lock
the form for the sessions that are full? If I am not explaining myself very
well, please let me know.

Thanks!