The update is partialy working

January 1, 2011 at 03:03:54
Specs: Windows XP
Dear Community

I need your help. I have MS Access 2007 database. I'm interesed that when one adds/updates a costumer data the field of "last updated" will be updated automatically (this way there won't be mistakes). I have tried the following code found at your forum :

If (IsNull([LastContact]) Or [LastContact] < Date) Then
LastContact = Date
End If

(I have chaged the LastContact into my date fiels).

This code is partialy working i.e. it works, however, after closing the database and entering again the code isn't working. Can someone help me with this problem? Is this problem is a bug in the software or maybe the problem is in my side?

Thank you
Mordi Domi

edited by moderator: email address removed

See More: The update is partialy working

January 1, 2011 at 10:28:36
Please do not post your email address in a public forum.

We don't really care if you are subjected to a ton of spam but we don't want to be known as a forum where email addresses can be harvested.

Once we become known for that, then there are many other security issues that will have to be dealt with.

Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

January 1, 2011 at 21:33:02
Sorry for that

Report •
Related Solutions

Ask Question