Deletes not available

[LAS]

Sorry 'bout that. Here it is.

http://dl.dropbox.com/u/10947693/DeleteProblem.mdb_file

 

[David W. Fenton]

Sorry 'bout that. Here it is.

http://dl.dropbox.com/u/10947693/DeleteProblem.mdb_file

You left one of the fields out of your table, but it doesn't exhibit
a problem for me. I can delete records, and in datasheet view, the
shortcut menu includes DELETE enabled as one of the choices.

So, the test database works as expected. Does it not for you?

 

[LAS]

Here's a screen shot of my experience with the same database. I'm running
Access 2007 in 2003 compatibility mode. Windows XP. I'm arranging to find
out how it behaves in Windows 7, same Access.

http://dl.dropbox.com/u/10947693/LASs experieince with DeleteProblem.doc

 

[LAS]

Could you explain about "you left one of the fields out of your table?" I
just imported the table from the back end. What are the symptoms that cause
you to say that?

 

[LAS]

Hi, David,

Why don't you reply to this post the next time you have something, just
so our conversation doesn't slide off into the ether on the right side.

Our current status is that you don't experience a disabled Delete. I
have put screen shots of my experience on DropBox and I have asked you what
you meant when you said I had left out a field in the table. I had just
imported the whole table. What were your symptoms?

Thanks,
Laurel

 

[LAS]

Thanks so much!!! For confirming that this is a 2007 bug, and for pointing
out that there are other ways to delete. I never though outside the box on
that one!

 

[LAS]

Aha! Thanks for noticing. I'd forgotten to update this form when I removed
that column from the table.

 

[David W. Fenton]

Here's a screen shot of my experience with the same database. I'm
running Access 2007 in 2003 compatibility mode. Windows XP. I'm
arranging to find out how it behaves in Windows 7, same Access.

http://dl.dropbox.com/u/10947693/LASs experieince with Delete
Problem.doc

OK, I had a brain fart when I tested, and ran it only in A2003.

In A2007, I get the same shortcut menu, with DELETE disabled, but
I'm still able to delete the record. I can do it with the DELETE key
or via the DELETE command on the ribbon.

I just tested with a brand-new A2007 database, created a table like
yours and a default form, and when I went into datasheet view, I saw
exactly the same thing -- the DELETE command was disabled in the
shortcut menu, even though you could still delete records with the
delete key and the ribbon.

Looks like a bug in A2007!

 

[David W. Fenton]

Could you explain about "you left one of the fields out of your
table?" I just imported the table from the back end. What are
the symptoms that cause you to say that?

The 3rd Boolean field is not in the table.

 

[David W. Fenton]

Our current status is that you don't experience a disabled
Delete. I
have put screen shots of my experience on DropBox and I have asked
you what you meant when you said I had left out a field in the
table. I had just imported the whole table. What were your
symptoms?

I just posted answers to these elsewhere.

I was mistakenly failing to test in A2007. I see what you see there,
but I can still delete. I also created a new A2007 database and
replicated your table/form from scratch, and the default shortcut
menu also disabled the delete command even though it was actually
available. I think it's an actual bug in A2007. I don't have time to
test in A2010 right now, though.

As to the missing field, your screenshot shows the same thing -- the
third Boolean field is not in the table, so the third checkbox comes
up Null, as it's bound to a field that isn't there. Removing the
third checkbox does not change the behavior of the shortcut menu,
though.

 

[David W. Fenton]

Thanks so much!!! For confirming that this is a 2007 bug, and for
pointing out that there are other ways to delete. I never though
outside the box on that one!

I'm wondering if you recreated the default shortcut menu if the
DELETE RECORD button would be enabled in the replacement shortcut
menu? I don't know if that's done the same way in A2007 as before,
though.

 

[LAS]

How does one "recreate the default shortcut menu?"

 

[David W. Fenton]

How does one "recreate the default shortcut menu?"

To learn how, in the properties sheet of your form, look at the
Shortcut Menu Bar property (on the OTHER tab) and hit F1 to get the
help instructions for it. That will guide you through creating
shortcut menus. You would then create a custom shortcut menu that
has the same commands as the default one you expect, then assign it
to the detail area of the form.

However, I haven't checked if this has changed in A2007, so it may
all be different.