Table with only 1 Row?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MT DOJ Help Desk - 07 Feb 2004 05:53 GMT

Access 97

I have a table that has only one row. I have a form that allows the user to
edit the values in the table. However, I also want to prevent the user from
adding additional rows. Is there any way to do that?

--Tom

Reply to this Message

John Vinson - 07 Feb 2004 06:34 GMT

>Access 97
>
[quoted text clipped - 3 lines]
>
>--Tom

Set some field (any field, doesn't matter) as the Primary Key, and put
a validation rule that it must be equal to its current value. If you
want to be able to change any of the fields, just add an Integer field
Primary Key, set it to 1, and set its validation rule to

=1

The Validation Rule will prevent any value other than 1; the Primary
Key will prevent adding two records both equal to 1.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

MT DOJ Help Desk - 10 Feb 2004 08:21 GMT

Access 97

That's a good trick. It works for preventing the user from adding another
row to the table. However, the form that is used to update the values in
the table has a control at the bottom that allows the user to click forward
to the next record. This is a built-in Access control and is not a control
that I expressly added to the form. This control allows the user to attempt
to input another row of data, although the table won't save because of the
validation rule on the primary key. Ideally, I'd like to prevent the user
from even trying to add more rows. Is there a way to disable the control at
the bottom of the form that allows a user to click forward to the next
record?

> >Access 97
> >
[quoted text clipped - 17 lines]
> Come for live chats every Tuesday and Thursday
> http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

RSGinCA - 10 Feb 2004 08:59 GMT

I don't know about Access 97, but on the properties for the form check for
"Allow Additions"... set it to 'No'. That will disable the 'addition'
capability of that built-in control. Another property "Navigation Button" (set
to 'No") will allow you to remove that control entirely.

Rick

>Access 97
>
[quoted text clipped - 8 lines]
>the bottom of the form that allows a user to click forward to the next
>record?

Reply to this Message

MT DOJ Help Desk - 12 Feb 2004 05:11 GMT

Thanks for the response. Unfortunately, I don't see either of the form
properties that you mentioned, so it appears that Access 97 lacks this
ability.

--Tom

> I don't know about Access 97, but on the properties for the form check for
> "Allow Additions"... set it to 'No'. That will disable the 'addition'
[quoted text clipped - 15 lines]
> >the bottom of the form that allows a user to click forward to the next
> >record?

Reply to this Message

Douglas J. Steele - 12 Feb 2004 23:04 GMT

Access 97 has both properties. The Allow Additions property is on the Data
tab, while the Navigation Buttons property is on the Format tab (of course,
both of them are also available on the All tab)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> Thanks for the response. Unfortunately, I don't see either of the form
> properties that you mentioned, so it appears that Access 97 lacks this
[quoted text clipped - 29 lines]
> > >the bottom of the form that allows a user to click forward to the next
> > >record?

Reply to this Message

MT DOJ Help Desk - 17 Feb 2004 01:54 GMT

The Data tab is blank, and the Format Tab lists only 10 properties, and the
Navigate Button property is not among them.

Maybe I'm looking at the wrong properties sheet. I'm going into the form
design, right-clicking the form without selecting an object on the form, and
then going to Properties. The resulting dialog box says, "Section: Detail"
at the top. Is that the right set of properties?

Could it be that these properties require the installation of an add-in?

--Tom

> Access 97 has both properties. The Allow Additions property is on the Data
> tab, while the Navigation Buttons property is on the Format tab (of course,
[quoted text clipped - 42 lines]
> > > >the bottom of the form that allows a user to click forward to the next
> > > >record?

Reply to this Message

John Vinson - 17 Feb 2004 02:32 GMT

>Maybe I'm looking at the wrong properties sheet. I'm going into the form
>design, right-clicking the form without selecting an object on the form, and
>then going to Properties. The resulting dialog box says, "Section: Detail"
>at the top. Is that the right set of properties?

Hah! You're indeed looking at the wrong set of properties: that's the
properties *of the Detail section* of the form.

The properties of the Form itself can be found by opening the form in
design view and selecting View... Properties, or right mouseclicking
the little square at the upper left intersection of the rulers and
selecting Properties.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message

MT DOJ Help Desk - 19 Feb 2004 04:00 GMT

OK, now I see those properties. I knew that I was looking at the properties
for the detail section of the form, but I couldn't figure out how to get to
the properties for the form itself. I could swear that I tried going to the
View menu and selecting properties from there, but I guess I didn't, because
if I had I wouldn't have had to post the question here! Thanks for the
help.

--Tom

> >Maybe I'm looking at the wrong properties sheet. I'm going into the form
> >design, right-clicking the form without selecting an object on the form, and
[quoted text clipped - 12 lines]
> Come for live chats every Tuesday and Thursday
> http://go.compuserve.com/msdevapps?loc=us&access=public

Reply to this Message