By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 1,120 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

New record button greyed out

P: n/a
[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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.