PC Review


Reply
Thread Tools Rate Thread

Bottom on a form that copy paste data in a table

 
 
Fred's
Guest
Posts: n/a
 
      3rd Jan 2008
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,


 
Reply With Quote
 
 
 
 
Jeff Boyce
Guest
Posts: n/a
 
      3rd Jan 2008
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,
>
>



 
Reply With Quote
 
Fred's
Guest
Posts: n/a
 
      3rd Jan 2008
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
 
Reply With Quote
 
Jeff Boyce
Guest
Posts: n/a
 
      3rd Jan 2008
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


 
Reply With Quote
 
Pat Hartman
Guest
Posts: n/a
 
      3rd Jan 2008
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,
>
>



 
Reply With Quote
 
John W. Vinson
Guest
Posts: n/a
 
      3rd Jan 2008
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]
 
Reply With Quote
 
Tony Toews [MVP]
Guest
Posts: n/a
 
      4th Jan 2008
"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/
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search one table to copy and paste select data to another table Sarah Microsoft Access VBA Modules 1 12th Dec 2008 06:42 PM
Copy linked table and Paste as Data =?Utf-8?B?SlR1cm5lcg==?= Microsoft Access Macros 1 2nd Jun 2006 08:44 PM
Copy Pivot Table Data and Paste into New File =?Utf-8?B?UyBTYWluc2J1cnk=?= Microsoft Excel Programming 1 15th Nov 2005 01:17 PM
Copy/paste data from one table to another =?Utf-8?B?TG91Rw==?= Microsoft Access Macros 1 17th Mar 2005 08:08 PM
re copy and paste pivot table data =?Utf-8?B?Q2Fyb2xlIE8=?= Microsoft Excel Worksheet Functions 0 13th Oct 2004 03:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:20 PM.