Hi There,

If these a way to have a Bottom on a form that when click on it, it
will copy and paste the information to another table in access in
instead of creating an append query?

Any help will be appreciated,

I may not be fully understanding what you are trying to do...

As I understand it, pasting a record to "another table in access" IS
appending it.

And if you already have the information in one record in one table, why
would you want a copy of it in another table? Wouldn't that make it much
harder to keep the two copies synchronized?

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Fred's" <(E-Mail Removed)> wrote in message
news:5d42a350-4ea0-48ed-9202-(E-Mail Removed)...
> Hi There,
>
> If these a way to have a Bottom on a form that when click on it, it
> will copy and paste the information to another table in access in
> instead of creating an append query?
>
> Any help will be appreciated,
>
>

On Jan 3, 3:26*pm, "Jeff Boyce" <nonse...@nonsense.com> wrote:
> I may not be fully understanding what you are trying to do...
>
> As I understand it, pasting a record to "another table in access" IS
> appending it.
>
> And if you already have the information in one record in one table, why
> would you want a copy of it in another table? *Wouldn't that make it much
> harder to keep the two copies synchronized?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>
> news:5d42a350-4ea0-48ed-9202-(E-Mail Removed)...
>
>
>
> > Hi There,
>
> > If these a way to have a Bottom on a form that when click on it, it
> > will copy and paste the information to another table in access in
> > instead of creating an append query?
>
> > Any help will be appreciated,- Hide quoted text -
>
> - Show quoted text -

It's for history purpose that I need two table

I don't have a clear enough picture to understand your situation yet...

Saving an exact copy to another table sounds very much like what you'd need
to do ... if you were working with a spreadsheet!

You won't get the best use of Access' relationally-oriented
features/functions if you feed it 'sheet data.

If you'll provide more specific descriptions, the newsgroup readers may be
able to offer more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Fred's" <(E-Mail Removed)> wrote in message
news:526ceefa-fc7c-4f4a-9c8d-(E-Mail Removed)...
On Jan 3, 3:26 pm, "Jeff Boyce" <nonse...@nonsense.com> wrote:
> I may not be fully understanding what you are trying to do...
>
> As I understand it, pasting a record to "another table in access" IS
> appending it.
>
> And if you already have the information in one record in one table, why
> would you want a copy of it in another table? Wouldn't that make it much
> harder to keep the two copies synchronized?
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
> "Fred's" <frederic10_m...@hotmail.com> wrote in message
>
> news:5d42a350-4ea0-48ed-9202-(E-Mail Removed)...
>
>
>
> > Hi There,
>
> > If these a way to have a Bottom on a form that when click on it, it
> > will copy and paste the information to another table in access in
> > instead of creating an append query?
>
> > Any help will be appreciated,- Hide quoted text -
>
> - Show quoted text -

It's for history purpose that I need two table

Access is a relational database. It is not a spreadsheet even though tables
look something like spreadsheets when opened in datasheet view.

Use an update query when you want to modify existing records and use an
append query when you want to add new rows.

In addition to action queries, you can use DAO or ADO to update/add/delete
data in other tables.

"Fred's" <(E-Mail Removed)> wrote in message
news:5d42a350-4ea0-48ed-9202-(E-Mail Removed)...
> Hi There,
>
> If these a way to have a Bottom on a form that when click on it, it
> will copy and paste the information to another table in access in
> instead of creating an append query?
>
> Any help will be appreciated,
>
>

On Thu, 3 Jan 2008 12:03:24 -0800 (PST), "Fred's"
<(E-Mail Removed)> wrote:

>Hi There,
>
>If these a way to have a Bottom on a form that when click on it, it
>will copy and paste the information to another table in access in
>instead of creating an append query?
>
>Any help will be appreciated,
>

Yes... you could open a Recordset based on the other table and use the AddNew
method, and set the value of each field individually.

An Append Query will require less code, will be easier to implement, and will
run faster, however.

What's the purpose of storing this information, apparently redundantly?

John W. Vinson [MVP]

"Fred's" <(E-Mail Removed)> wrote:

>It's for history purpose that I need two table

Leave the data in the first table. And figure out how to show only
"current" records on various forms and reports.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/