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

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" <(E-Mail Removed)> wrote in message
news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> > 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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:963BF591-4463-404C-AFA2-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> > > 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
> >
> >
> >

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" <(E-Mail Removed)> wrote in message
> news:963BF591-4463-404C-AFA2-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > > news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> > > > 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
> > >
> > >
> > >
>
>
>

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" <(E-Mail Removed)> wrote in message
news:4E58F82A-5F2C-460B-8DC3-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:963BF591-4463-404C-AFA2-(E-Mail Removed)...
> > > 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" <(E-Mail Removed)> wrote in message
> > > > news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >

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" <(E-Mail Removed)> wrote in message
> news:4E58F82A-5F2C-460B-8DC3-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> > > news:963BF591-4463-404C-AFA2-(E-Mail Removed)...
> > > > 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" <(E-Mail Removed)> wrote in message
> > > > > news:0B972A61-D925-48B7-9D99-(E-Mail Removed)...
> > > > > > 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
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>