Re: calculated control-!

From: Graham R Seach (gseach_at_NOSPAMpacificdb.com.au)
Date: 02/18/04

  • Next message: Dan En._at_nospam: "Re: Detect Windows 95 version by registry key"
    Date: Wed, 18 Feb 2022 12:32:00 +1100
    

    Vinod,

    <<What is the solution to place the calculated data back in the table?>>
    Don't! It is bad practice to store calculated values. They can be easily
    recalculated as needed.

    Regards,
    Graham R Seach
    Microsoft Access MVP
    Sydney, Australia

    "vinod" <vkwd_7@yahoo.co.in> wrote in message
    news:uVDTHaY9DHA.2756@TK2MSFTNGP10.phx.gbl...
    > I have a table as under:
    > membno name Osbal amt_recd
    > I created a form on this table as source and then in design view added
    three
    > more calculated controls:
    > Newosbal interest osbal2
    > I have written vba functions for these additional three controls in
    > modules.
    > these functions are placed in control source of respective controls and
    when
    > I run the form in form view these controls are populated with correct
    data.
    > What I want to do is that data in these 3 additional controls may be
    placed
    > back in the source table or in some other table because when i save the
    form
    > it can be saved only as report or form not as a table.What is the solution
    > to place the calculated data back in the table?
    > I am a novice and just trying but without any success.
    > will you please help!there are about 1500 recrds to deal with.
    > Is there a way to put the data from the calculated control (osbal2_04)on
    the
    > form to the soource table field(osbal)
    > thanks
    > vk wadhawan
    >
    >
    >
    >


  • Next message: Dan En._at_nospam: "Re: Detect Windows 95 version by registry key"