|  | Can't make a multivalued field | | |
| | | SP |  |
|  Posted: Wed Aug 27, 2008 4:33 pm Post subject: Can't make a multivalued field |  |
I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me if
I want the allow multiple values. Also, the lookup properties of the fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in my
existing database so that I can add a multivalued field? |
| |
| | | Chris O'C via AccessMonst | |
| | Posted: Wed Aug 27, 2008 4:46 pm Post subject: Re: Can't make a multivalued field | |
You need to convert the db to accdb format for multivalue fields. mdb format
can't store them.
Chris
Microsoft MVP
SP wrote:
| Quote: | I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me if
I want the allow multiple values. Also, the lookup properties of the fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in my
existing database so that I can add a multivalued field?
|
--
Message posted via LINK |
| |
| | | Chris O'C via AccessMonst | |
| | Posted: Wed Aug 27, 2008 4:46 pm Post subject: Re: Can't make a multivalued field | |
You need to convert the db to accdb format for multivalue fields. mdb format
can't store them.
Chris
Microsoft MVP
SP wrote:
| Quote: | I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me if
I want the allow multiple values. Also, the lookup properties of the fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in my
existing database so that I can add a multivalued field?
|
--
Message posted via AccessMonster.com
LINK |
| |
| | | Roger Carlson | |
| | Posted: Wed Aug 27, 2008 4:48 pm Post subject: Re: Can't make a multivalued field | |
Is the existing Access database an MDB or an ACCDB? Multivalued fields can
only be created in ACCDB databases.
--
--Roger Carlson
MS Access MVP
Access Database Samples: LINK
Want answers to your Access questions in your Email?
Free subscription:
LINK
"SP" <SP@discussions.microsoft.com> wrote in message
news:4A29F961-4151-4999-94D6-BB347DA1532B@microsoft.com...
| Quote: | I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me
if
I want the allow multiple values. Also, the lookup properties of the
fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in
my
existing database so that I can add a multivalued field? |
|
| |
| | | SP | |
| | Posted: Wed Aug 27, 2008 6:06 pm Post subject: Re: Can't make a multivalued field | |
| |  | |
How do I know if it is an MDB or an ACCDB?
"Roger Carlson" wrote:
| Quote: | Is the existing Access database an MDB or an ACCDB? Multivalued fields can
only be created in ACCDB databases.
--
--Roger Carlson
MS Access MVP
Access Database Samples: LINK
Want answers to your Access questions in your Email?
Free subscription:
LINK
"SP" <SP@discussions.microsoft.com> wrote in message
news:4A29F961-4151-4999-94D6-BB347DA1532B@microsoft.com...
I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me
if
I want the allow multiple values. Also, the lookup properties of the
fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in
my
existing database so that I can add a multivalued field?
|
|
| |
| | | SP | |
| | Posted: Wed Aug 27, 2008 6:06 pm Post subject: Re: Can't make a multivalued field | |
How do I do this? (I'm new to using Access)
"Chris O'C via AccessMonster.com" wrote:
| Quote: | You need to convert the db to accdb format for multivalue fields. mdb format
can't store them.
Chris
Microsoft MVP
SP wrote:
I am trying to create a multivalued field in the table of an existing
database. For some reason, when I do the lookup wizard, it doesn't ask me if
I want the allow multiple values. Also, the lookup properties of the fields
don't have the option to allow multiple values.
It isn't a problem with my computer or the Access 2007 that I am using
because if I open a new database it allows me to select the option that
allows for multiple values. Is there a setting that I need to change in my
existing database so that I can add a multivalued field?
--
Message posted via AccessMonster.com
LINK
|
|
| |
|
|
