How do you make an Archive table?

  • Thread starter Thread starter Bella Paul
  • Start date Start date
B

Bella Paul

Guest
:confused:
Hi'ya people i am really stuff, i have to do AS level ICT coursework. So i did a booking system.
I have 2 tables, called Borrowertbl and BookingTbl i was going to do "Computertbl" but my teacher said there was no need he said do a archive table but i dont have a clue how to do this. And also i still cant do enitity realtionship diaghrams. So please could anyone give me a helping hand i would totally be greatful. Thanx alot.

~Bella Paul ^_^
 
I don't know what you are trying to do but I wouldn't do an archive table. If you want to 'archive' some recores so they are not 'visible' unless you want to look at the 'archived' data then I would do the following: Add a Yes/No field to the table in which you want to archive records. Name the field Archived. Now when you want to 'archive' a record tick the Archived field. You can use a query to show archived or non-archived records.

hth,
Jack
 
oh thanx alot but my teacher said summot about archiving records using macros, bloody well hard :(
 
I have done something similiar to what you are attempting. I don't know if it's right, but it works. Create a table with all your fields you want and call it archived (or whatever). Create your macro that contains "RunSQL" command. In this command use a append query to the archive table. Then run the "RunSQL" command again, but run a delete query this time from your main table. Hope this helps.

Kacy
________
Michigan dispensary
 
Last edited:

Users who are viewing this thread

Back
Top Bottom