Access Data Collection Question

[Guest]

I am using Office 2007 for data collection with the new Access feature. The
entire process works fine, but I am unable to collect the e-mail addresses of
the responders unless they key it into the form. The survey is based on
tSurvey with the following fields:
txtEmail
txtQstOne
txtQstTwo
txtQstThree

I only want the form to show the questions. When I import the survey
results (I do this via a linked table to an Outlook folder) it only retrieves
the questions. If I include the address in the form and have the users key
in their address I can collect it, but I would rather not make them to that,
if at all possible.

Please let me know if clarification is needed...

Thanks in advance!

Pj

 

[pietlinden]

I am using Office 2007 for data collection with the new Access feature. The
entire process works fine, but I am unable to collect the e-mail addresses of
the responders unless they key it into the form. The survey is based on
tSurvey with the following fields:
txtEmail
txtQstOne
txtQstTwo
txtQstThree

I only want the form to show the questions. When I import the survey
results (I do this via a linked table to an Outlook folder) it only retrieves
the questions. If I include the address in the form and have the users key
in their address I can collect it, but I would rather not make them to that,
if at all possible.

Please let me know if clarification is needed...

Thanks in advance!

Pj

are the users' e-mail addresses match their NT/domain logon names? If
so, you can use

environ("username")