Bottom on a form that copy paste data in a table

F

Fred's

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,
 
J

Jeff Boyce

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
 
F

Fred's

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








- Show quoted text -
Click to expand...

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

Jeff Boyce

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

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








- Show quoted text -
Click to expand...

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

Pat Hartman

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.
 
J

John W. Vinson

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,
Click to expand...

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]
 
T

Tony Toews [MVP]

Fred's said:
It's for history purpose that I need two table
Click to expand...

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/
 
Top