Can't delete a record from a form

[LAS]

I have a form which is presented to the user in datasheet format. In the
Form properties, "Allow Deletes" is set to yes. But the right-mouse menu on
a row in the form has the Delete record de-emphasized (disabled). What
could be causing this?

TIA
LAS

[John W. Vinson]

Post by LAS
I have a form which is presented to the user in datasheet format. In the
Form properties, "Allow Deletes" is set to yes. But the right-mouse menu on
a row in the form has the Delete record de-emphasized (disabled). What
could be causing this?
TIA
LAS

It's likely that the Query upon which the form is based is not updateable. Try
opening it in query datasheet view - does it allow editing/deletion?

[LAS]

It's based on a table.

Post by John W. Vinson

Post by LAS
I have a form which is presented to the user in datasheet format. In the
Form properties, "Allow Deletes" is set to yes. But the right-mouse menu on
a row in the form has the Delete record de-emphasized (disabled). What
could be causing this?
TIA
LAS

It's likely that the Query upon which the form is based is not updateable. Try
opening it in query datasheet view - does it allow editing/deletion?
--
John W. Vinson [MVP]
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

[Access Developer]

If you present it in some view other than datasheet view, can records be
deleted?

If you simply open the table in datasheet view, can records be deleted?

Just FYI, most of the experienced Access developers do not use forms to
present datasheet view. That's mostly a matter of personal preference, but
partly because if you want datasheet view of a table you can just open it.
My own opinion is that datasheet view does not appear to be a
professionally-developed database application, but that's only my opinion
and you know about opinions.

What version of Access, and what Service Pack? You can find out from the
About option under Help.
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

Post by LAS
I have a form which is presented to the user in datasheet format. In the
Form properties, "Allow Deletes" is set to yes. But the right-mouse menu
on a row in the form has the Delete record de-emphasized (disabled). What
could be causing this?
TIA
LAS

[LAS]

See below

Post by Access Developer
If you present it in some view other than datasheet view, can records be
deleted?

No, because there are no icons for delete and add, etc. I don't use that
approach normally, so I'm not sure how to get them to show up. Right mouse
on a particular record just shows Cut, Copy, Paste and a disabled
properties.

Post by Access Developer
If you simply open the table in datasheet view, can records be deleted?

Yes

Post by Access Developer
Just FYI, most of the experienced Access developers do not use forms to
present datasheet view. That's mostly a matter of personal preference,
but partly because if you want datasheet view of a table you can just open
it. My own opinion is that datasheet view does not appear to be a
professionally-developed database application, but that's only my opinion
and you know about opinions.
What version of Access, and what Service Pack? You can find out from the
About option under Help.

Version 2007, using 2002-2003 file format

Post by Access Developer
--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

Post by LAS
I have a form which is presented to the user in datasheet format. In the
Form properties, "Allow Deletes" is set to yes. But the right-mouse menu
on a row in the form has the Delete record de-emphasized (disabled). What
could be causing this?
TIA
LAS

[David-W-Fenton]

Post by Access Developer
Just FYI, most of the experienced Access developers do not use
forms to present datasheet view. That's mostly a matter of
personal preference, but partly because if you want datasheet view
of a table you can just open it. My own opinion is that datasheet
view does not appear to be a professionally-developed database
application, but that's only my opinion and you know about
opinions.

Larry, you're just completely wrong on this. I use datasheet forms
all over the place, where appropriate, and so does every other
professional-level Access developer whose work I've seen (and
respect).