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]

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]
Microsoft's replacements for these newsgroups:
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

 

[LAS]

It's based on a table.

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]
Microsoft's replacements for these newsgroups:
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.

 

[LAS]

See below

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.

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


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

 

[David-W-Fenton]

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).