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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
Tidak ada komentar:
Posting Komentar