Recordset not Updatable

[Phil Hunt]

I have a simple form that have datasource from a main table join to a child
table. The recordset is made up of 1 main record and an aggregate (sum) of
its child. I fully understand why the recordset is not updatable. I just
want to know what is the best way to let user update the main table on the
same form, if possible. If not, please advise.

Thanks.

 

[Allen Browne]

The most efficient solution would be to bind the form to just the main
table, and then use a list box or subform to show the aggregate values from
the related table.

If there's only one or 2 related values to show, a DSum() expression would
work.

 

[Phil Hunt]

Thanks. I was hoping for a Access feature. It should be. It should know it
is partially updateable.

 

[BruceM]

There are reasons recordsets are not updateable. In this case the sum
cannot be updated since it involves several records. Because this field in
the recordset is not updateable, the recordset itself is not updateable. A
list box or subform (Access features) solve the problem.

 

[a a r o n _ k e m p f]

or

a) instead of triggers
b) uniqueTable property in ADP forms

nice try, kid

 

[BruceM]

You're babbling again. The word "or" suggests an alternative to something,
but you do not say what. In any case, my point is valid, although
admittedly not described in detail.

or

a) instead of triggers
b) uniqueTable property in ADP forms

nice try, kid

 

[Troll Chaser]

or

a) instead of triggers
b) uniqueTable property in ADP forms

Troll boy is at it again. Sorry, pimple-face, that won't solve his problem.
He won't be re-writing his entire database just because you forgot to take
your Zoloft today.

 

[a a r o n _ k e m p f]

tell me how that wouldn't solve it, please?

honestly-- tell me how I'm wrong.

Because either of my solutions would take care of his problem.
I Just can't believe how silly you guys sound BECAUSE YOU ARE WRONG

 

[Troll Chaser]

You are wrong because you propose an entire database rewrite to solve a
simple problem. That's akin to swatting flies with a 12 ga. shotgun.

tell me how that wouldn't solve it, please?

honestly-- tell me how I'm wrong.

Because either of my solutions would take care of his problem.
I Just can't believe how silly you guys sound BECAUSE YOU ARE WRONG

 

[Aaron Kempf knows nothing]

tell me how that wouldn't solve it, please?

honestly-- tell me how I'm wrong.

Because either of my solutions would take care of his problem.
I Just can't believe how silly you guys sound BECAUSE YOU ARE WRONG

 

[Aaron Kempf knows nothing]

or

a) instead of triggers
b) uniqueTable property in ADP forms

nice try, kid

 

[a a r o n _ k e m p f]

dude you're an idiot

if you're floating across the ocean.. and everyone keeps on pointing
and laughing-- they say 'your boat is not ocean worthy'

does that mean that you're really ok?

how do you handle unpredictable growth?
what if your clients want to grow from 3 employees to 6?

Access can't handle growth, it cannot handle very many records.

It's not a rewrite- you should have reWRITTEN a decade ago.
It's not a rewrite- you should have reWRITTEN a decade ago.
It's not a rewrite- you should have reWRITTEN a decade ago.

 

[a a r o n _ k e m p f]

please stop folling me, I do not feel safe with your predatory
behaivor

 

[So Sorry For Poor Aaron]

That's a totally transparent and patently useless try at playing the victim,
aaron.

Nobody's threatening you, nobody's said anything to make a rational human
being feel unsafe. Your saying that the poster's behavior is "predatory"
doesn't make it so.

You can't "build a case" that you are a non-delusional victim. Too many
people are recording all the threads here, so there's overwhelming evidence
that you are the provoker, you are the stalker (and, of course there's your
confession right in the public record).

Why don't you see if Daddy will buy you some simple video games to occupy
your time, so you don't have to harrass and irritate people who ask and
answer honest questions in the newsgroup? Tell him it's a good investment,
because it will keep you out of jail.

 

[a a r o n _ k e m p f]

they did a LOT more than threaten me.. they _ATTACKED_ me.

complaining to my employers-- because you disagree with my opinions--
is just plain ridiculous.
I didn't waste a single minute of company time, I was OFF THE CLOCK
and well within my bounds.

I didn't get threatened-- I got attacked.
And now _I_ get stalked by a dozen crazy dipshits.

**** THIS.

-Aaron