If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
restrict data
Is there a way to restrict data entry into a table via a form to one entry.
I want user to be able to change a date and amount monthly, but not allow the table to have more than one entry. Thanks |
#2
|
|||
|
|||
restrict data
Donno about table but you can use unbound form with unbound text boxes and
have event or macro to Set Value default from the entry. In other words when an entry is made in the text box the event/macro sets that value as default for the text box. When form is opened next time it display the default. Then use the value from the form-textbox as you would table-field. -- KARL DEWEY Build a little - Test a little "Christina" wrote: Is there a way to restrict data entry into a table via a form to one entry. I want user to be able to change a date and amount monthly, but not allow the table to have more than one entry. Thanks |
#3
|
|||
|
|||
restrict data
On Thu, 26 Feb 2009 10:08:01 -0800, Christina
wrote: Is there a way to restrict data entry into a table via a form to one entry. I want user to be able to change a date and amount monthly, but not allow the table to have more than one entry. Thanks Add a Number field to the table; make it the Primary Key (so each value can occur only once), and give the field a Validation Rule =1 so that 1 is the only value that can occur. Of course you need to fill this with 1 when you first open the table! -- John W. Vinson [MVP] |
#4
|
|||
|
|||
restrict data
Thanks very much.
"John W. Vinson" wrote: On Thu, 26 Feb 2009 10:08:01 -0800, Christina wrote: Is there a way to restrict data entry into a table via a form to one entry. I want user to be able to change a date and amount monthly, but not allow the table to have more than one entry. Thanks Add a Number field to the table; make it the Primary Key (so each value can occur only once), and give the field a Validation Rule =1 so that 1 is the only value that can occur. Of course you need to fill this with 1 when you first open the table! -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|