Can't Edit Table Through My Form - ADO DAO RDO RDS

On Thu, 16 Aug 2007 16:27:52 -0700, Coby <coby.gifford@selectbuild.com> wrote:

>I am trying to edit a table through a text box on a form instead of
>directly in the table, but cannot edit the data.
>
>1. The form is set up with its own query as a recordsource to a
>table.
>2. Control source for the text box on the form bound to a field in
>the table recordsource at the control source.
>
>3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
>Additions are all set to yes.

It's very likely that the Query itself is not updateable. Not all queries are!
Totals queries, Unique Values queries, UNION queries, etc. all block updating.

Try opening the query itself in datasheet view. Is there a *> new record row
at the bottom? If not, that's the problem. You could open it in SQL view and
post the SQL text here for help in making it into an updatable query.

John W. Vinson [MVP]

On Aug 16, 4:43 pm, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> On Thu, 16 Aug 2007 16:27:52 -0700, Coby <coby.giff...@selectbuild.com> wrote:
> >I am trying to edit a table through a text box on a form instead of
> >directly in the table, but cannot edit the data.
>
> >1. The form is set up with its own query as a recordsource to a
> >table.
> >2. Control source for the text box on the form bound to a field in
> >the table recordsource at the control source.
>
> >3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
> >Additions are all set to yes.
>
> It's very likely that the Query itself is not updateable. Not all queries are!
> Totals queries, Unique Values queries, UNION queries, etc. all block updating.
>
> Try opening the query itself in datasheet view. Is there a *> new record row
> at the bottom? If not, that's the problem. You could open it in SQL view and
> post the SQL text here for help in making it into an updatable query.
>
> John W. Vinson [MVP]

Thanks for your help! I appreciate if a lot. Here is the sql text:

SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU

FROM MaryLumTransDb

GROUP BY MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
[8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
MaryLumTransDb.NxTrendSKU, MaryLumTransDb.ThickActual,
MaryLumTransDb.WidthActual, MaryLumTransDb.Length

ORDER BY IIf(Me!Option8801.Value=True,MaryLumTransDb.
[8801_ActiveStatus],MaryLumTransDb.[8806_ActiveStatus]) DESC ,
MaryLumTransDb.ThickActual, MaryLumTransDb.WidthActual,
MaryLumTransDb.Length;


Coby.

"Coby" <coby.gifford@selectbuild.com> wrote in message
news:1187308434.034751.199100@z24g2000prh.googlegroups.com...
> On Aug 16, 4:43 pm, John W. Vinson
> <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
>> On Thu, 16 Aug 2007 16:27:52 -0700, Coby <coby.giff...@selectbuild.com>
>> wrote:
>> >I am trying to edit a table through a text box on a form instead of
>> >directly in the table, but cannot edit the data.
>>
>> >1. The form is set up with its own query as a recordsource to a
>> >table.
>> >2. Control source for the text box on the form bound to a field in
>> >the table recordsource at the control source.
>>
>> >3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
>> >Additions are all set to yes.
>>
>> It's very likely that the Query itself is not updateable. Not all queries
>> are!
>> Totals queries, Unique Values queries, UNION queries, etc. all block
>> updating.
>>
>> Try opening the query itself in datasheet view. Is there a *> new record row
>> at the bottom? If not, that's the problem. You could open it in SQL view and
>> post the SQL text here for help in making it into an updatable query.
>>
>> John W. Vinson [MVP]
>
> Thanks for your help! I appreciate if a lot. Here is the sql text:
>
> SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
> [8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
> MaryLumTransDb.NxTrendSKU
>
> FROM MaryLumTransDb
>
> GROUP BY [snip]

A query with GROUP BY is NEVER editable.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Aug 16, 4:58 pm, "Rick Brandt" <rickbran...@hotmail.com> wrote:
> "Coby" <coby.giff...@selectbuild.com> wrote in message
>
> news:1187308434.034751.199100@z24g2000prh.googlegroups.com...
>
>
>
>
>
> > On Aug 16, 4:43 pm, John W. Vinson
> > <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> >> On Thu, 16 Aug 2007 16:27:52 -0700, Coby <coby.giff...@selectbuild.com>
> >> wrote:
> >> >I am trying to edit a table through a text box on a form instead of
> >> >directly in the table, but cannot edit the data.
>
> >> >1. The form is set up with its own query as a recordsource to a
> >> >table.
> >> >2. Control source for the text box on the form bound to a field in
> >> >the table recordsource at the control source.
>
> >> >3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
> >> >Additions are all set to yes.
>
> >> It's very likely that the Query itself is not updateable. Not all queries
> >> are!
> >> Totals queries, Unique Values queries, UNION queries, etc. all block
> >> updating.
>
> >> Try opening the query itself in datasheet view. Is there a *> new record row
> >> at the bottom? If not, that's the problem. You could open it in SQL view and
> >> post the SQL text here for help in making it into an updatable query.
>
> >> John W. Vinson [MVP]
>
> > Thanks for your help! I appreciate if a lot. Here is the sql text:
>
> > SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
> > [8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
> > MaryLumTransDb.NxTrendSKU
>
> > FROM MaryLumTransDb
>
> > GROUP BY [snip]
>
> A query with GROUP BY is NEVER editable.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com- Hide quoted text -
>
> - Show quoted text -

That did it . . . and now makes complete logical sense to me. I
didn't even need the group by in this particualar query anyhow. Most
of my work involves querying data for reporting and have only recently
needed to acually write to the data, so group by just became habit
when writing a new query since I am often using a lot of sum
functions, etc.. Thank you very much! My work is all cut out for me
for awhile now.


Coby.

What is the SQL of the query for your form?

You can view the query in SQL view and paste the SQL from there.

Some types of query are not updateable, e.g. those that have a GroupBy
clause...

Steve

"Coby" wrote:

> I am trying to edit a table through a text box on a form instead of
> directly in the table, but cannot edit the data.
>
> 1. The form is set up with its own query as a recordsource to a
> table.
> 2. Control source for the text box on the form bound to a field in
> the table recordsource at the control source.
>
> 3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
> Additions are all set to yes.
>
> It seems like I have everything set up logically to do this, but I am
> stumped because I cannot edit anything on the form for some reason.
>
> Any helped on what I am doing wrong would be appreciated.
>
> Stumped,
> Coby.
>
>

You should never use Group By unless it is absolutely necessary. It will make
your queries less efficient.

Steve

"Coby" wrote:

> On Aug 16, 4:58 pm, "Rick Brandt" <rickbran...@hotmail.com> wrote:
> > "Coby" <coby.giff...@selectbuild.com> wrote in message
> >
> > news:1187308434.034751.199100@z24g2000prh.googlegroups.com...
> >
> >
> >
> >
> >
> > > On Aug 16, 4:43 pm, John W. Vinson
> > > <jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
> > >> On Thu, 16 Aug 2007 16:27:52 -0700, Coby <coby.giff...@selectbuild.com>
> > >> wrote:
> > >> >I am trying to edit a table through a text box on a form instead of
> > >> >directly in the table, but cannot edit the data.
> >
> > >> >1. The form is set up with its own query as a recordsource to a
> > >> >table.
> > >> >2. Control source for the text box on the form bound to a field in
> > >> >the table recordsource at the control source.
> >
> > >> >3. Locked property is set to no, Allow Edits, Data Entry,Deletions,
> > >> >Additions are all set to yes.
> >
> > >> It's very likely that the Query itself is not updateable. Not all queries
> > >> are!
> > >> Totals queries, Unique Values queries, UNION queries, etc. all block
> > >> updating.
> >
> > >> Try opening the query itself in datasheet view. Is there a *> new record row
> > >> at the bottom? If not, that's the problem. You could open it in SQL view and
> > >> post the SQL text here for help in making it into an updatable query.
> >
> > >> John W. Vinson [MVP]
> >
> > > Thanks for your help! I appreciate if a lot. Here is the sql text:
> >
> > > SELECT MaryLumTransDb.[8801_ActiveStatus], MaryLumTransDb.
> > > [8806_ActiveStatus], MaryLumTransDb.NxTrendDescription,
> > > MaryLumTransDb.NxTrendSKU
> >
> > > FROM MaryLumTransDb
> >
> > > GROUP BY [snip]
> >
> > A query with GROUP BY is NEVER editable.
> >
> > --
> > Rick Brandt, Microsoft Access MVP
> > Email (as appropriate) to...
> > RBrandt at Hunter dot com- Hide quoted text -
> >
> > - Show quoted text -
>
> That did it . . . and now makes complete logical sense to me. I
> didn't even need the group by in this particualar query anyhow. Most
> of my work involves querying data for reporting and have only recently
> needed to acually write to the data, so group by just became habit
> when writing a new query since I am often using a lot of sum
> functions, etc.. Thank you very much! My work is all cut out for me
> for awhile now.
>
>
> Coby.
>
>
>
>