Please this is urgent....

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kavinga - 09 May 2008 11:20 GMT

I have tried to use MS Office help to create a multivalued field... But I
have a problem with the step Number 6... -

Under Do you want to store multiple values for this lookup?, select the
Allow Multiple Values check box.

When I am trying it I dont get a check box like that......

Please somebody help me.....

Reply to this Message

George Nicholson - 09 May 2008 17:51 GMT

Are you using Office 2007? Afaik, that the first version to have a
multivalue option, but you might not realize that if you are looking at
instructions online somewhere.

Signature

HTH,
George

>I have tried to use MS Office help to create a multivalued field... But I
> have a problem with the step Number 6... -
[quoted text clipped - 5 lines]
>
> Please somebody help me.....

Reply to this Message

Evi - 12 May 2008 11:40 GMT

I don't have 2007 but so far I haven't found anything in Access which relies
entirely on the Wizard.
which can sometimes be very flighty.
Have you read the articles below to see if they contain details which may be
badly worded in Help?
http://www.databasedev.co.uk/multivalued-fields.html
http://office.microsoft.com/en-us/access/HA100140981033.aspx

The first one is particularly clear.

Please reconsider using a Lookup in your table, if that is what you are
planning to do. They cause no end of problems.

Evi

> I have tried to use MS Office help to create a multivalued field... But I
> have a problem with the step Number 6... -
[quoted text clipped - 5 lines]
>
> Please somebody help me.....

Reply to this Message

Evi - 12 May 2008 11:45 GMT

In this same newsgroup, Allen Browne answered this question in a message
No 'allow multiple values check box' - Allen Browne
He states:

1. Make sure you have converted this to an ACCDB (not merely an MDB opened
with A2007.)

2. In table design view, select the field where you want multiple values.

3. In the lower pane, click the Lookup tab, and choose Combo as the Display
Control.

4. Set the Allow Multiple Values property to Yes.

Evi

> I don't have 2007 but so far I haven't found anything in Access which relies
> entirely on the Wizard.
[quoted text clipped - 20 lines]
> >
> > Please somebody help me.....

Reply to this Message

Rate this thread: