Deletes not available

[LAS]

I have a very simple form, one table as recordsource. Deletes Allowed =
true (and all other such things are true). I open it in datasheet mode. I
can add records OK, but when I right click on the left "column" (don't know
technical term for that spot), the "Delete Row" in the right-mouse menu is
disabled. How can I get it enabled?

TIA
LAS

 

[David W. Fenton]

I have a very simple form, one table as recordsource. Deletes
Allowed = true (and all other such things are true). I open it in
datasheet mode. I can add records OK, but when I right click on
the left "column" (don't know technical term for that spot), the
"Delete Row" in the right-mouse menu is disabled. How can I get
it enabled?

Are edits available?

 

[LAS]

Yes, edits and adds.

Are edits available?

 

[David W. Fenton]

Yes, edits and adds.

Just to be sure, you can actually edit existing data and add new
records (just to distinguish from the settings for the AllowEdits
and AllowAdditions properties)?

Is there code running anywhere in the form when it opens?

 

[LAS]

Yes, I can add rows and change existing data. The right mouse menu shows
New Record, Delete Record, Cut, Copy, Paste, Row Height. Of those only
"Delete Record" is disabled (de-emphasized, faded font.)

 

[David W. Fenton]

Yes, I can add rows and change existing data. The right mouse
menu shows New Record, Delete Record, Cut, Copy, Paste, Row
Height. Of those only "Delete Record" is disabled (de-emphasized,
faded font.)

If you open the table datasheet directly, not the form based on that
table, can you delete records?

 

[LAS]

Yes, DELETE is available then.
I have several such forms, so the user can simply edit some tables
"directly." They all have the same problem. I made them all the same way,
by making a "garbage" form (just put all the columns on it any old place)
and opening it with

DoCmd.OpenForm rs![Argument], acFormDS, , , acFormReadOnly

I had to go look this up to answer your question, and I think I see where to
investigate. I got this from a "switchboard" form that I got from
someplace. Perhaps it came with Access??? Now the mystery is why I should
be able to add and edit if it has acFormReadOnly !!!!
I will read up on the OpenForm command.

 

[LAS]

DoCmd.OpenForm rs![Argument], acFormDS, , , acFormReadOnly

First I tried using another format that was available in the pre-existing
code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and something else.

So then I tried changing the acFormReadOnly to acFormEdit. Strangely enough
that left me with the same issue.... everything enabled excep DELETE. Any
ideas?

 

[LAS]

Does this help? When I don't use the command to open it, but choose "form"
or "design" or "datasheet" from the navigation pane, in datasheet view,
right mouse gives me "New record, delete record (DISABLED),cut, copy, paste,
row height." Form view gives me all those (delete disabled) except for New
Record, but that's taken care of by the empty record at the bottom.

So the problem is not found in the parameters supplied to DoCmd.OpenForm.

I've checked a jillion times to see that "Allow Deletes" is set to Yes.

 

[David W. Fenton]

DoCmd.OpenForm rs![Argument], acFormDS, , , acFormReadOnly

First I tried using another format that was available in the
pre-existing code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and
something else.

So then I tried changing the acFormReadOnly to acFormEdit.
Strangely enough that left me with the same issue.... everything
enabled excep DELETE. Any ideas?

What are the properties of the form itself set to?

 

[LAS]

see below

DoCmd.OpenForm rs![Argument], acFormDS, , , acFormReadOnly

First I tried using another format that was available in the
pre-existing code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and
something else.

So then I tried changing the acFormReadOnly to acFormEdit.
Strangely enough that left me with the same issue.... everything
enabled excep DELETE. Any ideas?

What are the properties of the form itself set to?

If you mean AllowDeletes , AllowAdds, etc., they are all set to YES. I've
checked it a jillion times.
You'll see from another response of mine that the DoCmd issue can be
ignored. It behaves this way in Datasheet View in the development
environment.

 

[David W. Fenton]

see below

DoCmd.OpenForm rs![Argument], acFormDS, , ,
acFormReadOnly

First I tried using another format that was available in the
pre-existing code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and
something else.

So then I tried changing the acFormReadOnly to acFormEdit.
Strangely enough that left me with the same issue.... everything
enabled excep DELETE. Any ideas?

What are the properties of the form itself set to?

If you mean AllowDeletes , AllowAdds, etc., they are all set to
YES. I've checked it a jillion times.

Is DataEntry OFF?

You'll see from another response of mine that the DoCmd issue can
be ignored. It behaves this way in Datasheet View in the
development environment.

I'm stumped.

Can you create a sample database that demonstrates the problem? A
few records from your main table and the form itself should be all
that's needed to see the problem. I'd be happy to look at it to see
if I can figure it out.

Of course, that works OK, it might help you identify the source of
the problem.

 

[LAS]

Yes, I will. How do I get it to you? Can put an attachment on a post?
I've never seen one.

see below

DoCmd.OpenForm rs![Argument], acFormDS, , ,
acFormReadOnly

First I tried using another format that was available in the
pre-existing code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and
something else.

So then I tried changing the acFormReadOnly to acFormEdit.
Strangely enough that left me with the same issue.... everything
enabled excep DELETE. Any ideas?

What are the properties of the form itself set to?

If you mean AllowDeletes , AllowAdds, etc., they are all set to
YES. I've checked it a jillion times.

Is DataEntry OFF?

You'll see from another response of mine that the DoCmd issue can
be ignored. It behaves this way in Datasheet View in the
development environment.

I'm stumped.

Can you create a sample database that demonstrates the problem? A
few records from your main table and the form itself should be all
that's needed to see the problem. I'd be happy to look at it to see
if I can figure it out.

Of course, that works OK, it might help you identify the source of
the problem.

 

[LAS]

When I try to post a response with DeleteProblem.mdb_file as attachment I
get this error. Outlook Express has been flakey in the last few weeks. Do
you know if it's worth continuing to try this way? Or might there be a
different way to get you the database? (Fortunately a barebones db
reproduces the problem. Open the only form. Choose datasheet view.

Outlook Express could not post your message. Subject 'Re: Deletes not
available', Account: 'news.eternal-september.org', Server:
'news.eternal-september.org', Protocol: NNTP, Server Response: '441 437
Binary: misplaced mdb_', Port: 119, Secure(SSL): No, Server Error: 441,
Error Number: 0x800CCCA9

see below

DoCmd.OpenForm rs![Argument], acFormDS, , ,
acFormReadOnly

First I tried using another format that was available in the
pre-existing code....

DoCmd.OpenForm rs![Argument], acFormDS

But that left me with everything disabled except Copy and
something else.

So then I tried changing the acFormReadOnly to acFormEdit.
Strangely enough that left me with the same issue.... everything
enabled excep DELETE. Any ideas?

What are the properties of the form itself set to?

If you mean AllowDeletes , AllowAdds, etc., they are all set to
YES. I've checked it a jillion times.

Is DataEntry OFF?

You'll see from another response of mine that the DoCmd issue can
be ignored. It behaves this way in Datasheet View in the
development environment.

I'm stumped.

Can you create a sample database that demonstrates the problem? A
few records from your main table and the form itself should be all
that's needed to see the problem. I'd be happy to look at it to see
if I can figure it out.

Of course, that works OK, it might help you identify the source of
the problem.

 

[David W. Fenton]

How do I get it to you?

Don't you have any webspace available to you anywhere? If not, you
could put it on YouSendit.com. You can go to me website to email me
the link.

 

[LAS]

I've just gotten an account on DropBox.com, which looks like it might do the
trick, but I'll have to study up on it. More later.

 

[LAS]

OK, this link will let you get it. Note that I made the extension mdb_file
to avoid possible security issues.

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

 

[David W. Fenton]

When I try to post a response with DeleteProblem.mdb_file as
attachment

This is a text newsgroup, not a binary one, so you can't post
attachments.

 

[David W. Fenton]

I've just gotten an account on DropBox.com, which looks like it
might do the trick, but I'll have to study up on it.

I thought that was for backups.

 

[David W. Fenton]

OK, this link will let you get it. Note that I made the extension
mdb_file to avoid possible security issues.

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

You didn't include the table. You need to delete the link and import
the table.