How do I capture user's login data in a form

J

Jay

I want to set up a form in Word that contains questions with check boxes (yes
/ no ) etc. with the next field in the table set up to display the log in
information for the person who completes the form; i.e., if I check the box,
my name and completion time / date is captured and displayed in another cell
in the form.
 
F

Fumei2 via OfficeKB.com

You would have to supply more details on what determines "completion time",
but you could certainly grab a time stamp for when it is opened, and then
another for when they execute some sort of "Done".

Date? I would assume that would be the current Day. Yes? Look up Now in
help.

As for the login name. There are various ways, but Environ("username") is
the one of the easiest to use.

MsgBox Environ("username") & " " & _
Format(Now, "mmmm d, yyyy")

displays:

myLoggedInName January 21, 2010
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top