Re: Moving a record (almost) works...?

Kenneth wrote:
>
> Hi Liz,
>
> I am running Chimney Sweep as we click.

Let us know what it says.

> Beyond that, I am a bit confused by your comment above...
>
> I have posted all the code that is on the ChangeValue so I
> don't know what you are suggesting I disable. Also, the
> amount due is not calculated. That amount is simply entered
> on the form.

OK, I thought something was being calculated. It's not; disregard that
part.

Disable all the code in the changeValue event you posted. I want you to
check what the record looks like if it's allowed to stay in the main table
rather than moved to the archive table - just as a test. Enter the amount
and hit Ctrl + F5 (to post your change) and then F9 (to leave edit mode).
What does the record look like? In your example, when the record got to
the archive table, a field that should have been $1.00 was $732161.00 - I
want to know whether the same field, left in the main table, will change
from $1.00 to $732161.00 or whether it will stay at $1.00. (You can undo
your edits, apply the code and re-do your edits later to get the record
into the archive table.)

Also, can you give a real life example of the values (if that isn't (hard
to imagine receiving $1 against an invoice)) cuz there's one known issue
that could be happening here, but not if that's the real value.

Liz
.

Relevant Pages

  • Re: Nanki Poo is back at the Vet
    ... and for you and Liz. ... No amount of time can erase the memory of a good cat, ... masking tape can ever totally remove his fur from your couch. ...
    (rec.pets.cats.anecdotes)
  • Re: Moving a record (almost) works...?
    ... >> Hi Liz, ... >> amount due is not calculated. ... >to imagine receiving $1 against an invoice)) cuz there's one known issue ... I will also mention that the spurious entry of $732121.00 is ...
    (comp.databases.paradox)
  • Re: I need some help!
    ... Funny, Liz, you have me blocked but still see my posts. ... like govt workers apparently (our postal person who leaves packages on ... He was fired because the amount in his till at the end of the day didn't match the amount of postage/products sold per the computer. ... postal workers are NOT tenured. ...
    (sci.med.transcription)
  • Re: Need advice, Please... becoming an IC
    ... Thanks, Liz. ... I only make $13.50/hr working for the hospital plus 0.05 per ... line after 4000 lines per week, so $17/hr to me doesn't sound too bad to me. ... > you're happy with that amount, that's all that matters, and this might ...
    (sci.med.transcription)
  • Re: Moving a record (almost) works...?
    ... something is probably interfering with the code that does ... the calculation of amount due, ... the changeValue event and enter the amount due into the received field, ...
    (comp.databases.paradox)
Loading