ACCESS FEED: Re: [MS_AccessPros] Multivalued lookup based on a table

Hi Glenn,

Thanks for the "Not in List" code link. I'll give it a try see if I can make that work. I couldn't get much information from the second link. I think it might be because I have to create an account on that group.

Regards,

Steve

--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" wrote:
>
> Steve,
>
>
>
> This article http://www.databasedev.co.uk/not_in_list.html describes how to
> add items to a combo box's list. There is a link at the end of the article
> for additional examples. You might find this article
> http://www.utteraccess.com/wiki/index.php/MultiValue_Combobox_%28Stock%29
> also of interest.
>
>
>
> Glenn
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sspatriots
> Sent: February-18-13 1:12 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Multivalued lookup based on a table
>
>
>
>
>
> I have a set of them in a table. I'd like to be able to add to that list if
> all of the serial numbers I need to select are not in the table's drop-down
> list on my form.
>
> Thanks,
>
> Steve
>
> --- In MS_Access_Professionals@yahoogroups.com
> , "Glenn Lloyd" wrote:
> >
> > Hi Steve,
> >
> >
> >
> > Is your list of serial numbers currently in a table? Or did you type the
> > list when you used the lookup wizard?
> >
> >
> >
> > Glenn
> >
> >
> >
> > From: MS_Access_Professionals@yahoogroups.com
>
> > [mailto:MS_Access_Professionals@yahoogroups.com
> ] On Behalf Of sspatriots
> > Sent: February-16-13 6:51 AM
> > To: MS_Access_Professionals@yahoogroups.com
>
> > Subject: Re: [MS_AccessPros] Multivalued lookup based on a table
> >
> >
> >
> >
> >
> > Glenn,
> >
> > I would definitely be interested in seeing any code you may have as an
> > example. I kept banging away at it and did manage to get a drop-down list
> in
> > my form that allowed me to put checks by the selections I wanted. The list
> > is comprised of a lot of serial numbers. For example, if I pick four
> > different serial numbers they appear in the box like this
> > "AN5,AN7,AN12,AP2". The problem is that if a serial number isn't in the
> list
> > I made up, I can't add it. I'm hoping what you have will do that for me.
> >
> > The serial number definition is the first two characters represent the
> year
> > and the subsequent numbers represent sequentially assigned numbers. AP is
> > 2013.
> >
> > Thanks,
> >
> > Steve
> >
> > --- In MS_Access_Professionals@yahoogroups.com
>
> > , argeedblu wrote:
> > >
> > > Steve,
> > >
> > > I am not aware of a way to show a multi-valued combo list with check
> > boxes.
> > >
> > > However you can add items to the list by using the not in list event to
> > > trigger a form to add a record to the table that is the list's row
> source.
> > > I am on the road for the weekend but can give you some cod on Monday if
> > you
> > > still need it.
> > >
> > > In 2010, you can use the look up wizard for a multi valued field. That
> may
> > > even give you the check boxes you are looking for but I do not recommend
> > > multi-valued fields.
> > >
> > > Glenn
> > >
> > > Sent from my Galaxy tablet.
> > > On Feb 16, 2013 5:56 AM, "sspatriots" wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Glenn,
> > > >
> > > > Thanks for the help. I see what you are saying and managed to get the
> > > > multi-valued lookup in my table. Is there a way to see a multi-valued
> > list
> > > > with these checkboxes in a form? I'm struggling to even find much
> > > > information on how to do this on-line.
> > > >
> > > > Thanks,
> > > >
> > > > Steve
> > > >
> > > > --- In MS_Access_Professionals@yahoogroups.com
>
> > , Glenn Lloyd wrote:
> > > > >
> > > > > Steve
> > > > >
> > > > > I don't Â know of a way to do it in the wizard but if you look at
> the
> > > > properties of the combo box you should see a multi valued property.
> > > > >
> > > > > Glenn
> > > > >
> > > > >
> > > > >
> > > > > Sent from Samsung Galaxy Note ll Mobile Â
> > > > >
> > > > > -------- Original message --------
> > > > > From: sspatriots
> > > > > Date: 2013-02-15 9:27 PM (GMT-05:00)
> > > > > To: MS_Access_Professionals@yahoogroups.com
>
> >
> > > > > Subject: Re: [MS_AccessPros] Multivalued lookup based on a table
> > > > >
> > > > > I've pretty much given up on trying to create a multivalued lookup
> box
> > > > for my form that will allow the user to add entries to that lookup as
> > well.
> > > > >
> > > > > However, I do want to create the multivalued lookup box for my form.
> > > > From everything I've found, using the Lookup Wizard I should be able
> to
> > do
> > > > this. However, at the very end of going through all the steps with the
> > > > wizard where you label your lookup field, I don't see the options to
> > > > "Enable Data Integrity" and "Allow Multiple Values". Does anyone now
> of
> > a
> > > > setting or something I need to make in order to be able to see these
> > > > options in the Wizard. I'm using Access 2010.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Steve
> > > > >
> > > > > --- In MS_Access_Professionals@yahoogroups.com
>
> > , "sspatriots" wrote:
> > > > > >
> > > > > > Glenn,
> > > > > >
> > > > > > Actually what I was hoping to achieve was having a dropdown list
> > (I'm
> > > > guessing a combobox) on my form that has checkboxes next to everything
> > in
> > > > the list drops down where the user can select 1 or more of the
> choices,
> > but
> > > > also have the ability to add an entry to that list on the fly if they
> > don't
> > > > see what they need to see there. Or, is this not even possible. I
> really
> > > > don't know because I'm quite new to Access.
> > > > > >
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > > --- In MS_Access_Professionals@yahoogroups.com
>
> > , "Glenn Lloyd" wrote:
> > > > > > >
> > > > > > > Steve,
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > If I understand your question correctly, you want to have
> > checkboxes
> > > > on the
> > > > > > > form for the user to check but then add checkboxes to the form
> if
> > > > the user
> > > > > > > adds new items to the list in a combo box.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > As long as the source of the combo box list is a table, it is
> > > > relatively
> > > > > > > simple to add new items to that list. What is more difficult is
> > > > adding
> > > > > > > checkboxes to the form. In fact if you compile the application
> to
> > an
> > > > mde or
> > > > > > > accde, you can't add check boxes the form because that is a
> design
> > > > change.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Glenn
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > From: MS_Access_Professionals@yahoogroups.com
>
> >
> > > > > > > [mailto:MS_Access_Professionals@yahoogroups.com
>
> > ] On Behalf Of
> > > > sspatriots
> > > > > > > Sent: February-15-13 10:27 AM
> > > > > > > To: MS_Access_Professionals@yahoogroups.com
>
> >
> > > > > > > Subject: [MS_AccessPros] Multivalued lookup based on a table
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > Is it possible to have a multivalued lookup based on a table
> that
> > > > will allow
> > > > > > > a user filling out a form to add to that list from the form if
> > their
> > > > choice
> > > > > > > isn't in the list to select a checkbox for? If so, can someone
> > give
> > > > me an
> > > > > > > idea of how this is done? I need the user to be able to check as
> > > > many items
> > > > > > > that apply plus have the ability to add to the list.
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > Steve
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>