468,457 Members | 1,601 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,457 developers. It's quick & easy.

New record button greyed out

[This followup was posted to comp.databases.ms-access and a copy was sent to the cited author.]

I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J
Nov 13 '05 #1
2 9209
The form property that you need is "Allow Additions" set to yes. This will
allow adding new records. This property is different from the "Data Entry"
property, that does not show any existing records, but blanks the form for
adding a new record.
-Ed

"Jacko" <bl*******@hotmail.com> wrote in message
news:MP************************@news.ntlworld.com. ..
[This followup was posted to comp.databases.ms-access and a copy was sent
to the cited author.]

I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J

Nov 13 '05 #2
What do you mean by "supposed to be updateable"? If the recordsource of your
form is a query, maybe the query is not updateable. In this case you can add
records at the table level but not via the form. Also check the Allow
Additions property under the Data tba of properties.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Jacko" <bl*******@hotmail.com> wrote in message
news:MP************************@news.ntlworld.com. ..
[This followup was posted to comp.databases.ms-access and a copy was sent to the cited author.]
I have a jazz records archive database which is supposed to be
updatable via an input form.

Despite setting the form's properties so that it will accept edits,
deletes etc the new record button on the record navigation thingy
stalwartly remains greyed out.

I can add one record at a time by editing the underlying table but
still the form remains "read only".

I am working in admin/owner role and all permissions look ok.

Any clues?

Dave J

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Michelle Collier-Moore | last post: by
4 posts views Thread by Patrick Flaherty | last post: by
3 posts views Thread by paulquinlan100 | last post: by
3 posts views Thread by devnew | last post: by
1 post views Thread by subhajit12345 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.