I am using Access 2007 and I just can't figure out how to create a one
record table. Could someone help me out?

Thank you.

JackonLI wrote:

This is untested....
If I were using a form to enter data, I might have something like
Me.AllowAdditions = (Me.Recordsetclone.RecordCount = 0)
in the OnCurrent event. Maybe
Me.AllowAdditions = False
in the AfterUpdate event of the form.

If you are entering data directly from a table or query, I see nothing
to stop a user from entering more than one record. There's no checks,
not validation, nothing.

On Mar 31, 8:08*pm, JackonLI wrote:
Just a clarification: Do you mean that you want the table to have
ONLY ONE record? Someone smarter than me has to answer how to limit a
table to one record. I pose this clarification because I can't
imagine why you're having trouble putting one record in a table.

<JackonLI> schreef in bericht
news:fkb5t4pu17i6cm9ld2qoqi2pmk209i41qd (AT) 4ax (DOT) com...
Create an indexed Field called ID or even make this field the prime key.
Create the record and set the value to 1.
Set as the validation rule for the field =1

==> No more records are possible.


HTH
Arno R

Create a Boolean Yes/No field with a unique index. (It could be the primary
key field.) Set the field Validation Rule so that it must be True, or it is
not accepted. Normally you would not display this special field to the user
form, and you would pre-create the single record. Your form would allow the
user to edit the other fields but not delete the record.

You can also enforce non-deletion in the database by adding an enforced
relationship to a hidden child table (or to itself) with no cascading
deletes permitted. But it is easier to just do it in the form, if you are
not worried about external user queries deleting the record.

- Steve

<JackonLI> wrote

On 1 Apr., 02:08, JackonLI wrote:
Make it a query:

select val1 as fname1, val2 as fname2,.....

If you need the change values in running code, you could make a sub
that alters through querydef object.
--
Benny

Thank you all for your responses. I wound up creating a sub form set
to only allow edits. Then referenced to sub form to get the value.

Thanks again