Saving deleted records to another (database)

[Debb]

Hello,

I am not sure where I should post my question, so if it is not posted is the right location please let me know. As it stands may question is
How do I save a deleted record to another (database)? I need step by step instructions. I do not want to use an "inactive" column nor do I want to do an "audit" I just want to maintain a list of the records that have been deleted. I am using MS Access 2003.

Thanks

 

[Trevor G]

Hi Debb,

What you need to do is use an Append Query followed by a Delete Query both should use the same criteria.

You can set the Append query to Append to another database then the delete query to delete the entries in the current database, therefore you have a working solution.

You can then create a MACRO to run both at once and once tested you can set the Warnings to False so you get the several prompts.

 

[Debb]

It has been years since I worked with Access so I am relearing it and discovering new ways to do tings. With that being said is it possible to update a report once it has been generated. For instance if I left a name off the the table and already ran the report, do I need to rerun it or is there another way to updat the report.

Again....Thanks for your expertise.

 

[Trevor G]

From what you have said it seems that you would need to rerun it.

 

[Debb]

Hello, Its me again

Trevor, you have really help me with my previous question, I am hoping you can help me with this one. My database is growing very fast; I would like to know how to write codes to:

1. First, I want to automatically move fields (rows) from master database (a) to my removed database (b). Then delete the client from the master database(a). Currently, I run a query (thank for the tip). However, since my database is growing I need to make this process simpler.

2. I also want to setup an auto suspense date for each client person I enter into the database and if possible I would like to be able to formulate some type of statistical data that will let me know how long a person is on my master database. I have a field that indicates the date I entered the person onto the database. Oh yes, I forgot to say I know nothing about writing codes but eager to learn.

Thanks you

Debb

 

[Galaxiom]

How big is your database? Unless you have a few million records it it not likely to matter.

Have you compacted the Back End lately?

BTW. This is entirely the wrong section of the forum for asking questions. This section is for suggestions about this site.

You should also start new threads for new questions rather than reactivating old ones.

 

[Debb]

Show History in Database

Hello,
I have a master database in forms and tables of several clients (approx. 200). I conduct business with my clients 3-4 times per year, sometimes more. My question is: how do I generate a history that indicates the dates I began working with my clients, the dates ended, and the items they requested for each business transaction. I only want their account info entered into the master database once, not each time I transact business with them. I also want to be able click on their name in my forms database and pull up their history. By the way I have upgraded Access 2010.
Thanks for your assistance.
Debb

 

[Trevor G]

You need 2 tables and link them. A form will then have the main table and the other table can appear as a SubForm.

In your first table do you have an auto ID field as Primary.

In your second table you need a ID field that is a number field.

You can then create a relationship between the 2.

The Form can then be created.

You should look at YouTube and search for Creating a Relational Database.

This link might help you

http://www.youtube.com/watch?v=sJ28pLSXfyc&feature=related

 

[ulieq]

Inactive column is the best choice...Deletion is evil.