Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Clean data in form when run AppendQuery

Discussion in 'Information Technology' started by an, Jul 28, 2006.

  1. an

    an
    Expand Collapse
    Guest

    Hi!

    I have a form with a command button to run Append Query and close the form.

    I would like, when open the form on next time, it show us all text boxes
    with numbers cleaned (with zeros).

    Thanks in advance.
    an
     
  2. Loading...


  3. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    I'm not sure I see the connection between running an Append query and having
    the form cleaned the next time.

    An Append query adds data from Table A to Table B. How can you use that fact
    to determine what needs to be cleaned on the form? Are you under the
    (mis)impression that an Append query removes the data from Table A when it
    adds it to Table B?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "an" <an@discussions.microsoft.com> wrote in message
    news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > Hi!
    >
    > I have a form with a command button to run Append Query and close the
    > form.
    >
    > I would like, when open the form on next time, it show us all text boxes
    > with numbers cleaned (with zeros).
    >
    > Thanks in advance.
    > an
     
  4. an

    an
    Expand Collapse
    Guest

    Sorry for my bad explanation.

    I have a table B, to Historic values, where add new data trought run append
    query.
    Is correct?

    But when we "reopen" the form to new data, (naturally) it show us the last
    values entry.
    I would like, if is possible, to clean all that last values...

    Thanks.
    an

    "Douglas J. Steele" wrote:

    > I'm not sure I see the connection between running an Append query and having
    > the form cleaned the next time.
    >
    > An Append query adds data from Table A to Table B. How can you use that fact
    > to determine what needs to be cleaned on the form? Are you under the
    > (mis)impression that an Append query removes the data from Table A when it
    > adds it to Table B?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no private e-mails, please)
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > > Hi!
    > >
    > > I have a form with a command button to run Append Query and close the
    > > form.
    > >
    > > I would like, when open the form on next time, it show us all text boxes
    > > with numbers cleaned (with zeros).
    > >
    > > Thanks in advance.
    > > an

    >
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Are you asking how to remove the values from the original table?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "an" <an@discussions.microsoft.com> wrote in message
    news:963BF591-4463-404C-AFA2-A0A32C3A7696@microsoft.com...
    > Sorry for my bad explanation.
    >
    > I have a table B, to Historic values, where add new data trought run

    append
    > query.
    > Is correct?
    >
    > But when we "reopen" the form to new data, (naturally) it show us the last
    > values entry.
    > I would like, if is possible, to clean all that last values...
    >
    > Thanks.
    > an
    >
    > "Douglas J. Steele" wrote:
    >
    > > I'm not sure I see the connection between running an Append query and

    having
    > > the form cleaned the next time.
    > >
    > > An Append query adds data from Table A to Table B. How can you use that

    fact
    > > to determine what needs to be cleaned on the form? Are you under the
    > > (mis)impression that an Append query removes the data from Table A when

    it
    > > adds it to Table B?
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no private e-mails, please)
    > >
    > >
    > > "an" <an@discussions.microsoft.com> wrote in message
    > > news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > > > Hi!
    > > >
    > > > I have a form with a command button to run Append Query and close the
    > > > form.
    > > >
    > > > I would like, when open the form on next time, it show us all text

    boxes
    > > > with numbers cleaned (with zeros).
    > > >
    > > > Thanks in advance.
    > > > an

    > >
    > >
    > >
     
  6. an

    an
    Expand Collapse
    Guest

    Thanks for your reply.

    Basically, yes.

    an

    "Douglas J Steele" wrote:

    > Are you asking how to remove the values from the original table?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:963BF591-4463-404C-AFA2-A0A32C3A7696@microsoft.com...
    > > Sorry for my bad explanation.
    > >
    > > I have a table B, to Historic values, where add new data trought run

    > append
    > > query.
    > > Is correct?
    > >
    > > But when we "reopen" the form to new data, (naturally) it show us the last
    > > values entry.
    > > I would like, if is possible, to clean all that last values...
    > >
    > > Thanks.
    > > an
    > >
    > > "Douglas J. Steele" wrote:
    > >
    > > > I'm not sure I see the connection between running an Append query and

    > having
    > > > the form cleaned the next time.
    > > >
    > > > An Append query adds data from Table A to Table B. How can you use that

    > fact
    > > > to determine what needs to be cleaned on the form? Are you under the
    > > > (mis)impression that an Append query removes the data from Table A when

    > it
    > > > adds it to Table B?
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no private e-mails, please)
    > > >
    > > >
    > > > "an" <an@discussions.microsoft.com> wrote in message
    > > > news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > > > > Hi!
    > > > >
    > > > > I have a form with a command button to run Append Query and close the
    > > > > form.
    > > > >
    > > > > I would like, when open the form on next time, it show us all text

    > boxes
    > > > > with numbers cleaned (with zeros).
    > > > >
    > > > > Thanks in advance.
    > > > > an
    > > >
    > > >
    > > >

    >
    >
    >
     
  7. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    How are you determining which records to append to the history table?

    Use that criteria as the basis for a delete query to remove them from the
    original table.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "an" <an@discussions.microsoft.com> wrote in message
    news:4E58F82A-5F2C-460B-8DC3-1C350E44A86B@microsoft.com...
    > Thanks for your reply.
    >
    > Basically, yes.
    >
    > an
    >
    > "Douglas J Steele" wrote:
    >
    > > Are you asking how to remove the values from the original table?
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "an" <an@discussions.microsoft.com> wrote in message
    > > news:963BF591-4463-404C-AFA2-A0A32C3A7696@microsoft.com...
    > > > Sorry for my bad explanation.
    > > >
    > > > I have a table B, to Historic values, where add new data trought run

    > > append
    > > > query.
    > > > Is correct?
    > > >
    > > > But when we "reopen" the form to new data, (naturally) it show us the

    last
    > > > values entry.
    > > > I would like, if is possible, to clean all that last values...
    > > >
    > > > Thanks.
    > > > an
    > > >
    > > > "Douglas J. Steele" wrote:
    > > >
    > > > > I'm not sure I see the connection between running an Append query

    and
    > > having
    > > > > the form cleaned the next time.
    > > > >
    > > > > An Append query adds data from Table A to Table B. How can you use

    that
    > > fact
    > > > > to determine what needs to be cleaned on the form? Are you under the
    > > > > (mis)impression that an Append query removes the data from Table A

    when
    > > it
    > > > > adds it to Table B?
    > > > >
    > > > > --
    > > > > Doug Steele, Microsoft Access MVP
    > > > > http://I.Am/DougSteele
    > > > > (no private e-mails, please)
    > > > >
    > > > >
    > > > > "an" <an@discussions.microsoft.com> wrote in message
    > > > > news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > > > > > Hi!
    > > > > >
    > > > > > I have a form with a command button to run Append Query and close

    the
    > > > > > form.
    > > > > >
    > > > > > I would like, when open the form on next time, it show us all text

    > > boxes
    > > > > > with numbers cleaned (with zeros).
    > > > > >
    > > > > > Thanks in advance.
    > > > > > an
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >
     
  8. an

    an
    Expand Collapse
    Guest

    Ok, DJS,

    It lacked the "click"...

    Thank you for your help.
    an

    "Douglas J Steele" wrote:

    > How are you determining which records to append to the history table?
    >
    > Use that criteria as the basis for a delete query to remove them from the
    > original table.
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "an" <an@discussions.microsoft.com> wrote in message
    > news:4E58F82A-5F2C-460B-8DC3-1C350E44A86B@microsoft.com...
    > > Thanks for your reply.
    > >
    > > Basically, yes.
    > >
    > > an
    > >
    > > "Douglas J Steele" wrote:
    > >
    > > > Are you asking how to remove the values from the original table?
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "an" <an@discussions.microsoft.com> wrote in message
    > > > news:963BF591-4463-404C-AFA2-A0A32C3A7696@microsoft.com...
    > > > > Sorry for my bad explanation.
    > > > >
    > > > > I have a table B, to Historic values, where add new data trought run
    > > > append
    > > > > query.
    > > > > Is correct?
    > > > >
    > > > > But when we "reopen" the form to new data, (naturally) it show us the

    > last
    > > > > values entry.
    > > > > I would like, if is possible, to clean all that last values...
    > > > >
    > > > > Thanks.
    > > > > an
    > > > >
    > > > > "Douglas J. Steele" wrote:
    > > > >
    > > > > > I'm not sure I see the connection between running an Append query

    > and
    > > > having
    > > > > > the form cleaned the next time.
    > > > > >
    > > > > > An Append query adds data from Table A to Table B. How can you use

    > that
    > > > fact
    > > > > > to determine what needs to be cleaned on the form? Are you under the
    > > > > > (mis)impression that an Append query removes the data from Table A

    > when
    > > > it
    > > > > > adds it to Table B?
    > > > > >
    > > > > > --
    > > > > > Doug Steele, Microsoft Access MVP
    > > > > > http://I.Am/DougSteele
    > > > > > (no private e-mails, please)
    > > > > >
    > > > > >
    > > > > > "an" <an@discussions.microsoft.com> wrote in message
    > > > > > news:0B972A61-D925-48B7-9D99-C0B89CE64FCA@microsoft.com...
    > > > > > > Hi!
    > > > > > >
    > > > > > > I have a form with a command button to run Append Query and close

    > the
    > > > > > > form.
    > > > > > >
    > > > > > > I would like, when open the form on next time, it show us all text
    > > > boxes
    > > > > > > with numbers cleaned (with zeros).
    > > > > > >
    > > > > > > Thanks in advance.
    > > > > > > an
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >
     

Share This Page