Hi There

I am wondering if someone can help me.  I am using access to create a
survey/questionnaire that children with disabilities will be using.  I
am trying to make it user friendly for them and I am at the beginning
and already hit a snag.

I am using Access 2007 although I can use 2002 if it will make it
easier (used to using that, trying to get to grips with new layout in
2007 still).

There are several questions, some of them are straighforward and will
just have space for them to type and answer.  The ones I am trying to
do at the moment says something like...

What do you like doing when staying here?

Then there are various different ones like playing outside, swimming
etc.  The guy who is wanting this done had done one on paper, but a
lot of the young people respond much better when using a computer.
For each of the choices they have there are smiley faces next to them
(wingdings J K and L) and he is looking for them to be circled.  Then
there is a space for comments.

I am wondering which is the best way to do it and if either of them
are possible, and if they are, how would I go about doing them?

1. Having a Combo Box that would display the smiley faces that they
can choose from

Or

2. With each comment there are three buttons next to them each with a
smiley face on them, if so, how would I save this to the table?

Thanks

Colin

Colin,

    I have done something similar to your idea 2.  I just create and option 
group on the form using the toggle button option.  Then create a label that 
is the same size and shape as your toggle button with your color or whatever 
on it.  Then after you get the option group working how you want, move the 
toggle overlay on top.  

    I have used colors and not pictures but I think it would work.

HTH

Vanya


"weircolin@googlemail.com" wrote:

> Hi There
> 
> I am wondering if someone can help me.  I am using access to create a
> survey/questionnaire that children with disabilities will be using.  I
> am trying to make it user friendly for them and I am at the beginning
> and already hit a snag.
> 
> I am using Access 2007 although I can use 2002 if it will make it
> easier (used to using that, trying to get to grips with new layout in
> 2007 still).
> 
> There are several questions, some of them are straighforward and will
> just have space for them to type and answer.  The ones I am trying to
> do at the moment says something like...
> 
> What do you like doing when staying here?
> 
> Then there are various different ones like playing outside, swimming
> etc.  The guy who is wanting this done had done one on paper, but a
> lot of the young people respond much better when using a computer.
> For each of the choices they have there are smiley faces next to them
> (wingdings J K and L) and he is looking for them to be circled.  Then
> there is a space for comments.
> 
> I am wondering which is the best way to do it and if either of them
> are possible, and if they are, how would I go about doing them?
> 
> 1. Having a Combo Box that would display the smiley faces that they
> can choose from
> 
> Or
> 
> 2. With each comment there are three buttons next to them each with a
> smiley face on them, if so, how would I save this to the table?
> 
> Thanks
> 
> Colin
> 

Thanks for your reply, makes sense.  Would that mean however that for
every question I would need to have three fields in a table?

Cheers

Colin,

      I was on holiday so sorry for the late response.

      The option group data gets stored in one field.  Say you have a 
question relating to swimming.  
  Does Swimming Make You:
      Happy     option value = 1
      Okay       option value = 2
      Sad        option value = 3

     Then in your table there is one field called Swimming.
      if swimming = 1 then they are happy
      if swimming = 2 then they are okay  and so on.

HTH

Vanya

"weircolin@googlemail.com" wrote:

> Thanks for your reply, makes sense.  Would that mean however that for
> every question I would need to have three fields in a table?
> 
> Cheers
>