Recent content by eggy168

I really don't know what's wrong of me. I tried everything you said and corrected the mistaked. :mad: ~~I moved the variable, Previous_Saved_Time and declared it as Public exactly like the gif you attached into a Module. Then I moved the function to the same module underneath the variable. I...

Did you try to put a macro or vb? You can try to put all the queries you need to run into a macro so when the first query runs, the marco kicks in and the rest of the queries will run automatically instead of typing the 'memerbership' in every query.

I think I am so stupid :( Even I follow the steps, it is still not working on my db. I have no idea what's wrong. The time doesn't changed. No idea :confused: Option Compare Database Public Previous_Time_Saved As Boolean Private Sub Form_BeforeInsert(Cancel As Integer) If...

hmm..I don't know how to set the Previous_Saved_Time as false in the onCurrent event type. Private Sub Form_Current() set Previous_Saved_Time as False End Sub This gives me an error message. :confused:

CurrentUser() works the same thing

I am sorry, it is me again. I have to take the word back for the currentuser(). It looks like the Backup_Log_Stamp is not working totally. The Last_Modified_By_User and the Date_Last_Modified are not working. So, I don't know what's happening. However, when I put the Function and the Call...

Sorry smercer, i didn't know this is today's thread. i sent you an email regarding this thread. Anyhow, the Backup_Log_Stamp() is not quite working when I test it in my database. The Previous_Modification_Time and the Date_Last_Modified are not changing although I edited the record and exit...

I just want to add two fields into the current Access2000 FE/SQL2000 BE database. ~ lastmodifiedDate (datetime) and lastmodifiedBy (char) to record who is the person who edit the record and what time s/he edits the record. I had been working on the AfterUpdate() in Access, the lastmodifiedDate...