Can't delete a record from a form


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
 
Ad

Advertisements

J

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
 
A

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

LAS

See below
Access Developer said:
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
 
Ad

Advertisements

D

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top