By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,914 Members | 1,100 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,914 IT Pros & Developers. It's quick & easy.

keeping the timestamp record

P: 1
Hi, I am new here and new to Access and VB. I know C++, but I have a school project which requires me to design a database in Access :S! (Pardon my terminology, VB is not my first language!)
I have to keep a record of all users who make changes in the records. After my text box in the form view is updated, "CurrentUser" and "Now()" are saved in a table which can hold multiple values. The problem is that each time, the old values in record table are being updated and no new value is added (to keep the record), unless I manually click on the last record (so after update, username and date will be saved as new entery)! I tried to use acNewrec and Setfocus but it did not work. Can anybody help me? :S

(MS Access 2003, OS XP)
Jul 16 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,206
What code are you using to save CurrentUser and Now() to your table?
Jul 16 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.