question about "At Your Survey" survey app

[tlyczko]

Hello,

Doug Steele, Microsoft Access MVP, has commented:

"See whether the sample application "At Your Survey" which Duane Hookom
has at http://www.rogersaccesslibrary.com/d...uanehookom.htm
gives you what you need."

I wonder if anyone who has used this little app could advise me upon
adapting this app to work successfully to administer a survey that has
to have one comments field filled in, and of any issues I should be
aware of when using it in Access 2003.

I wrote to Mr. Hookom, but I don't know whether or not he wants
questions sent here or to him...

Thank you,
Tom

[Douglas J. Steele]

I'll let Duane know you've posted here.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"tlyczko" <tl*****@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

Hello,

Doug Steele, Microsoft Access MVP, has commented:

"See whether the sample application "At Your Survey" which Duane Hookom
has at http://www.rogersaccesslibrary.com/d...uanehookom.htm
gives you what you need."

I wonder if anyone who has used this little app could advise me upon
adapting this app to work successfully to administer a survey that has
to have one comments field filled in, and of any issues I should be
aware of when using it in Access 2003.

I wrote to Mr. Hookom, but I don't know whether or not he wants
questions sent here or to him...

Thank you,
Tom

[tlyczko]

Thank you, Doug.

Duane replied to my email, and said (he asked that I post this here):

<quote>
Tom,
How many characters do you think you need to place in the comment
field? The response field should hold 255 characters.
There are a couple options if you need more:
1) add a memo field to the tblResponses
2) create a separate table with a primary key that matches the primary
key for tblResponses

In either of these to cases, you could create a small dialog form that
allows the user to enter the longer text. You could use some event like
a double-click of the answer text box or other to open the dialog form
and set the defaults of the hidden RspnsId and QstnID to the value from
the response entry form.

If you need only one comment for the entire list of questions for one
respondent you could add a memo field to tblSrvRspns

I would appreciate if you would post this back to c.d.m.a. as I don't
frequent that forum and apparently you posted there prior to contacting
me directly.

Duane
</quote>

I have also inquired about whether and how his app handles a question
with multiple answers where the respondent can pick one or all the
answers, and if I receive an answer, I will post that here...

Thank you,
Tom