export records for archive

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I have a database called "ProjectReport", it consist of project data. Some
of the data is very old and needs to be archived. I would like to be able to
select a record and use a button to send it to a database that was created to
house archived records called "ProjectReportArchive".

What is the code behind the button to send a record from one database to
another database?

I split the database and the back end is called "ProjectReport_BE"
Should I split the archive database??

Thanks in advance.
 
Deb,
Your Project records should have a unique key field value that identifies
each record specifically.
Use that value to criteria an Append query from your working table to
your archive table.
After running the Append, run a Delete query agaisnt the working table to
remove that specific record.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top