Prev: Combo Box Adding Button to edit list items
Next: Value list updates not appearing in form
From: Jeff Boyce on 3 Jun 2010 12:15
Nope, I was trying to imagine modifying the form every time I needed a new
question.

Consider looking into the more normalized survey/questionnaire design
offered by Duane H.:

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3


Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" <laura.e.dodge(a)gmail.com> wrote in message
news:96937b8c-fdac-46d5-9e4c-1dd182d8393f(a)z33g2000vbb.googlegroups.com...
> Hi Jeff,
>
> The data type under the control is Text. This project is for data
> entry for a large questionnaire. So each question on the questionnaire
> has a control on the form for an answer. If I need to add questions it
> doesn't screw up the numbers because they are already assigned on the
> paper questionnaire. If I need space for another answer because the
> respondent checked two boxes instead of just one, the question becomes
> 210a, 210b, etc. Is that what you're asking? Thanks!
>
>
>


From: laeldo on 3 Jun 2010 14:12
The design of my database aside, all I want to know is whether Access
can recognize a particular free-text response and act accordingly. Do
I need quotes, should I use the "Like" feature, etc?

From: laeldo on 3 Jun 2010 14:12
The design of my database aside, all I want to know is whether Access
can recognize a particular free-text response and act accordingly. Do
I need quotes, should I use the "Like" feature, etc?

From: Jeff Boyce on 3 Jun 2010 14:20
The design of your database isn't an "aside".

"How" depends on "what" ... and the "what" is the design of your database.
It all starts with the data!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"laeldo" <laura.e.dodge(a)gmail.com> wrote in message
news:e55c318e-8225-41d5-9953-af65b7e034cb(a)y4g2000yqy.googlegroups.com...
> The design of my database aside, all I want to know is whether Access
> can recognize a particular free-text response and act accordingly. Do
> I need quotes, should I use the "Like" feature, etc?
>


First  |  Prev  | 
Pages: 1 2
Prev: Combo Box Adding Button to edit list items
Next: Value list updates not appearing in form