Record changes

**kameran** · 07-17-2011, 06:00 AM

Hallo Friends,

I have a databse with 3 tables , each tabel has many Col.

I want to record any changes in the tables .. something like a log book

Like a report shows me which data in which table and col. has been changed.

Thanks in advance!

Kameran

**alansidman** · 07-17-2011, 07:28 AM

If your db has many columns(fields), I wonder if your data base is normalized. Here is a link to answer your tracking question

http://www.datawright.com.au/access_..._in_access.htm

You may also want to read up on database normalization. Here is one to explain that.

http://forums.aspfree.com/microsoft-...es-208217.html

http://www.datawright.com.au/access_..._using_VBA.htm

Alan

**kameran** · 07-17-2011, 09:48 AM

Originally Posted by alansidman

If your db has many columns(fields), I wonder if your data base is normalized. Here is a link to answer your tracking question

http://www.datawright.com.au/access_..._in_access.htm

You may also want to read up on database normalization. Here is one to explain that.

http://forums.aspfree.com/microsoft-...es-208217.html

http://www.datawright.com.au/access_..._using_VBA.htm

Alan

Hallo Alan ,

Thanks a lot ... I don't know what is my mistake Could you please check the attached file.

Thanks
Kameran

**kameran** · 07-19-2011, 12:01 PM

Hallo All,

Can anyone in the forum help me with this file .

Thanks in adavance

Kameran

**davegugg** · 07-19-2011, 01:51 PM

You need to call your LogChanges function. It looks like it's all set up, but you need to set up when it will run. In general, you'd want to add a button on your form to save any changes. Then after saving the changes, call your LogChanges function.

**kameran** · 07-21-2011, 12:24 PM

Hallo ,

Really I don't know so much in Access and it's little bit defficult for me at this time..

Could u please send me at least one example to learn.

Thanks
kameran

**davegugg** · 07-21-2011, 05:45 PM

This is a fairly basic Access task. You should take some beginner / intermediate tutorials for setting up Access forms. You should be able to find hundreds with a quick Google search.