Prev: Non-modal forms and multiple documents
Next: Formatting "Caps" in a Style
From: Jay on 21 Jan 2010 10:15
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.
From: Fumei2 via OfficeKB.com on 21 Jan 2010 13:39
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


Jay wrote:
>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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/word-programming/201001/1

From: Compass Rose on 21 Jan 2010 18:18
Sorry, meant to post to General Questions, not Word Programming.

"Jay" wrote:

> 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.
 | 
Pages: 1
Prev: Non-modal forms and multiple documents
Next: Formatting "Caps" in a Style