MS Access Help
July-22nd-2002, 01:22 PM
#1
Registered User
Thread Starter
Join Date: Dec 2001
Location: PA
Posts: 2,339
MS Access Help
I need help with copying a record from one table to another in MS access. My ultimate goal is to have like a button on a form, that runs a macro or whatever that will copy the record from the one table to the other, and delete it from the first table. In essense just move it from one table to another. Any help??? Thanks! 
July-22nd-2002, 01:45 PM
#2
Protege Enthusiast
Join Date: Nov 2001
Location: Hamilton, ON
Posts: 323
Re: MS Access Help
Originally posted by funkdaddysmack
I need help with copying a record from one table to another in MS access. My ultimate goal is to have like a button on a form, that runs a macro or whatever that will copy the record from the one table to the other, and delete it from the first table. In essense just move it from one table to another. Any help??? Thanks!
I need help with copying a record from one table to another in MS access. My ultimate goal is to have like a button on a form, that runs a macro or whatever that will copy the record from the one table to the other, and delete it from the first table. In essense just move it from one table to another. Any help??? Thanks!
Stocker
edit
(you can then run a macro to run the two queries back to back with a button off a form)
July-22nd-2002, 02:38 PM
#3
Registered User
Thread Starter
Join Date: Dec 2001
Location: PA
Posts: 2,339
Re: Re: MS Access Help
Originally posted by stocker
The easiest way is to run an append query, this will pull records out of one table and add them to the one you specify. Follow this with a delete query to delete the records from the first table.
Stocker
edit
(you can then run a macro to run the two queries back to back with a button off a form)
The easiest way is to run an append query, this will pull records out of one table and add them to the one you specify. Follow this with a delete query to delete the records from the first table.
Stocker
edit
(you can then run a macro to run the two queries back to back with a button off a form)
July-23rd-2002, 07:30 AM
#4
Protege Enthusiast
Join Date: Nov 2001
Location: Hamilton, ON
Posts: 323
Re: Re: Re: Re: MS Access Help
Originally posted by Gro Harlem
thats what MS access is all about!!! Damn queeries!! haha
thats what MS access is all about!!! Damn queeries!! haha
Stocker
Thread
Thread Starter
Forum
Replies
Last Post
jimshingleton
3rd Gen Protege/MazdaSpeed/P5/MP3
4
January-15th-2003 03:49 PM
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)