Can't delete a record from a form

  • Thread starter Thread starter LAS
  • Start date Start date
L

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
 
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
Click to expand...

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
 
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.
 
See below
Access Developer said:
If you present it in some view other than datasheet view, can records be
deleted?
Click to expand...

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.
Click to expand...

Version 2007, using 2002-2003 file format
 
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.
Click to expand...

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