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

"LAS" <(E-Mail Removed)> wrote in
news:i53foc$vts$(E-Mail Removed):

> 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?

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

Yes, edits and adds.

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9DDF9969FE4Cf99a49ed1d0c49c5bbb2@74.209.136.82...
> "LAS" <(E-Mail Removed)> wrote in
> news:i53foc$vts$(E-Mail Removed):
>
>> 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?
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/

"LAS" <(E-Mail Removed)> wrote in
news:i55ucg$uu2$(E-Mail Removed):

> "David W. Fenton" <(E-Mail Removed)> wrote in message
> news:Xns9DDF9969FE4Cf99a49ed1d0c49c5bbb2@74.209.136.82...
>> "LAS" <(E-Mail Removed)> wrote in
>> news:i53foc$vts$(E-Mail Removed):
>>
>>> 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?
>
> 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?

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

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" <(E-Mail Removed)> wrote in message
news:Xns9DE0B22FE9877f99a49ed1d0c49c5bbb2@74.209.136.90...
> "LAS" <(E-Mail Removed)> wrote in
> news:i55ucg$uu2$(E-Mail Removed):
>
>> "David W. Fenton" <(E-Mail Removed)> wrote in message
>> news:Xns9DDF9969FE4Cf99a49ed1d0c49c5bbb2@74.209.136.82...
>>> "LAS" <(E-Mail Removed)> wrote in
>>> news:i53foc$vts$(E-Mail Removed):
>>>
>>>> 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?
>>
>> 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?
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/

"LAS" <(E-Mail Removed)> wrote in
news:i574ge$fov$(E-Mail Removed):

> 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?

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

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.

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9DE19A7E0821f99a49ed1d0c49c5bbb2@74.209.136.93...
> "LAS" <(E-Mail Removed)> wrote in
> news:i574ge$fov$(E-Mail Removed):
>
>> 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?
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/

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?

"David W. Fenton" <(E-Mail Removed)> wrote in message
news:Xns9DE19A7E0821f99a49ed1d0c49c5bbb2@74.209.136.93...
> "LAS" <(E-Mail Removed)> wrote in
> news:i574ge$fov$(E-Mail Removed):
>
>> 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?
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/

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" <(E-Mail Removed)> wrote in message
news:Xns9DE19A7E0821f99a49ed1d0c49c5bbb2@74.209.136.93...
> "LAS" <(E-Mail Removed)> wrote in
> news:i574ge$fov$(E-Mail Removed):
>
>> 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?
>
> --
> David W. Fenton http://www.dfenton.com/
> contact via website only http://www.dfenton.com/DFA/

"LAS" <(E-Mail Removed)> wrote in
news:i5m4bd$e59$(E-Mail Removed):

> 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?

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