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

On Sat, 3 Sep 2011 17:33:23 -0400, "LAS" <(E-Mail Removed)> wrote:

>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/For...-US/accessdev/
http://social.answers.microsoft.com/.../en-US/addbuz/
and see also http://www.utteraccess.com

It's based on a table.

"John W. Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
news:(E-Mail Removed)...
> On Sat, 3 Sep 2011 17:33:23 -0400, "LAS" <(E-Mail Removed)> wrote:
>
>>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/For...-US/accessdev/
> http://social.answers.microsoft.com/.../en-US/addbuz/
> and see also http://www.utteraccess.com

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


"LAS" <(E-Mail Removed)> wrote in message
news:j3u6kq$fn9$(E-Mail Removed)...
>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
>

See below
"Access Developer" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

>
> --
> 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
>
>
> "LAS" <(E-Mail Removed)> wrote in message
> news:j3u6kq$fn9$(E-Mail Removed)...
>>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
>>
>
>

"Access Developer" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

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

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/