Field auto-generation.

[DocZayus]

Hi, I'm new around here, but you should be seeing quite a bit of me on the Forums.

I have a fairly basic Knowledge of the Office Suite. So I will be begging for help. Quite often. But don't worry, I learn fairly fast. My only problem is that my main language is French but I am am fluently Bilingual. I just lose track sometimes.

Anyhow, here's my 1st Question:

Users need to login to use the database, and I make a weekly update.
I have a Form, with many fields, some locked, others not.
I need for 2 fields to update when one field changes.
i.e.:
when a name gets entered in field1, have field2 automatically enter the users login name, and have field3 auto-add the Date().

My Office Suite is in French, but I should be able to figure it out.
Thx!

-Doc

 

[DocZayus]

thanks!

Me.LastUpdateBy = CurrentUser()
Me.LastUpdateDate = Now()

Me. <- does that mean the current field?
Because I need 2 other fields to be modified when the first is changed.

and I don't need time of day, it's just to inform us of who last made changes and when. but I will try the Now() command, to see the outcome.

Thx!

(I'm home now, but I will check it out tomorrow at work.)

 

[DocZayus]

Thanks, going to try that out.

 

[DocZayus]

ccess can't find the macro called ME
Me.DATE MOD = Now()

I've also tried
="DATE MOD = now()"
="[DATE MOD] = now()"
=(DATE MOD = now())
=[Me].[DATE MOD]=Maintenant()
=[Me.DATE MOD]=Maintenant()

and many other light variations with " " and () and []

any ideas?

(ps: maintenant() and now() are the same french/english)

 

[DocZayus]

field names are
[MODIFICATION] (for the name - currentuser() )
[DATE MOD] (for the date - now() )
[MATRICULE] (the modified field)

-doc

 

[Lilgreenfrog]

im hvaing exactly the same problem as this at the moment, and wondered if you had managed to resovle it, and if so, how?

Also, weirdly I'm leaving Britain for Quebec in 3 weeks time to live there for a year! Hope its all everyone says it is!