Hi,
The version of Access I'm using is Access 2010.
I've been trying to work with the "Collect Data" tab to email a survey to 800 people and have the results be populated in the database. I know that's possible with the "Create Email" feature, but I want to take it a step futher.
My survey table has both a surveyid (pk-autonumber) and a clientid (fk) that links it back to the client taking the survey. I'm wondering whether it's possible to populate the html form that gets emailed with the clientid. So far I've not been able to do this. I can't use the InfoPath option because my recipients will most likely not have InfoPath installed on their computers. Do I have any options, other than having the clients type their own clientid's into the survey, which would be messy enough to negate any time savings I'd get from emailing the survey.
Do you think survey monkey would be a better option for this?
I'd appreciate any suggestions given. Thank you!
The version of Access I'm using is Access 2010.
I've been trying to work with the "Collect Data" tab to email a survey to 800 people and have the results be populated in the database. I know that's possible with the "Create Email" feature, but I want to take it a step futher.
My survey table has both a surveyid (pk-autonumber) and a clientid (fk) that links it back to the client taking the survey. I'm wondering whether it's possible to populate the html form that gets emailed with the clientid. So far I've not been able to do this. I can't use the InfoPath option because my recipients will most likely not have InfoPath installed on their computers. Do I have any options, other than having the clients type their own clientid's into the survey, which would be messy enough to negate any time savings I'd get from emailing the survey.
Do you think survey monkey would be a better option for this?
I'd appreciate any suggestions given. Thank you!
