473,320 Members | 1,946 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

MultiSelect List Boxes

Please point me in the direction of some good, free web based
resources\ documentation for information on developing the multi
select list boxes. Have made extensive use of the non-multi list
boxes in the past but am having problems locating good info for
writing code & using the multi select boxes. BTW am using acc
'97. Thanks for your input.
dc
Apr 17 '06 #1
5 2868
If you are trying to use multi-select listboxes to store multiple option
values in a single field, don't! Instead, create a related table to hold the
related records, and use a subform.

If you are trying to use an unbound multi-select listbox as criteria, see:
Use a multi-select list box to filter a report
at:
http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <no*****************@charter.net> wrote in message
news:Xn************************@216.196.97.131...
Please point me in the direction of some good, free web based
resources\ documentation for information on developing the multi
select list boxes. Have made extensive use of the non-multi list
boxes in the past but am having problems locating good info for
writing code & using the multi select boxes. BTW am using acc
'97. Thanks for your input.
dc

Apr 17 '06 #2
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44435939$0$16685$5a62ac22@per-qv1-newsreader-
01.iinet.net.au:
http://allenbrowne.com/ser-50.html


Thanks for your reply and the example\sample. Am trying to open
several records of a table via a specific form by highliting
those records in a list box. When the record has been updated &
then form closed the next highlited record would open in the
same form for editing until each of the highlited records have
been updated. Hopefully this makes sense. This is actually
similiar to the Developers Sample Phone list that is shipped
with Access but I felt that example was pretty cheesy & was
difficult to follow the code.Thanks for any help you can offer.
dc
Apr 17 '06 #3
So the list box is being used to filter the records that need to be edited?

You could use the code in the link to OpenForm with a WhereCondition so that
it contains only the records to be edited. The user then edits the record,
steps to the next one (using the built-in navigation buttons), and so on,
going back if needed, until the selected records are done, and then closes
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <no*****************@charter.net> wrote in message
news:Xn*************************@216.196.97.131...
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44435939$0$16685$5a62ac22@per-qv1-newsreader-
01.iinet.net.au:
http://allenbrowne.com/ser-50.html


Thanks for your reply and the example\sample. Am trying to open
several records of a table via a specific form by highliting
those records in a list box. When the record has been updated &
then form closed the next highlited record would open in the
same form for editing until each of the highlited records have
been updated. Hopefully this makes sense. This is actually
similiar to the Developers Sample Phone list that is shipped
with Access but I felt that example was pretty cheesy & was
difficult to follow the code.Thanks for any help you can offer.
dc

Apr 17 '06 #4
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44***********************@per-qv1-newsreader-01.iinet.net
..au:
So the list box is being used to filter the records that
need to be edited?

You could use the code in the link to OpenForm with a
WhereCondition so that it contains only the records to be
edited. The user then edits the record, steps to the next
one (using the built-in navigation buttons), and so on,
going back if needed, until the selected records are done,
and then closes the form.


Thanks again for your reply. Are you saying that in the line
right above Exit_Handler I should change it to an OpenForm
rather than OpenReport?? I'm not sure I follow. I'm not the
best at this sort of thing.
dc
Apr 18 '06 #5
Yep: OpenForm will open the form, and you use the WhereCondition to open it
limited to the selected records (as long as the form is not already open.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <no*****************@charter.net> wrote in message
news:Xn*************************@216.196.97.131...
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44***********************@per-qv1-newsreader-01.iinet.net
.au:
So the list box is being used to filter the records that
need to be edited?

You could use the code in the link to OpenForm with a
WhereCondition so that it contains only the records to be
edited. The user then edits the record, steps to the next
one (using the built-in navigation buttons), and so on,
going back if needed, until the selected records are done,
and then closes the form.


Thanks again for your reply. Are you saying that in the line
right above Exit_Handler I should change it to an OpenForm
rather than OpenReport?? I'm not sure I follow. I'm not the
best at this sort of thing.
dc

Apr 18 '06 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Danny | last post by:
I like the combo box because you can scroll through items nicely, but the list box just has the navigation where you can go up and down. I am trying to allow the user to multiselect items. With...
3
by: Shannan Casteel via AccessMonster.com | last post by:
I have three main tables. The first is the table that my main form will be based on. This is where the user will enter all the data. The table is called TechnicalProblemsTable. It looks like...
1
by: tod4 | last post by:
Hi, My problem: I have query with value klient and product. On my form Im using multiselect box as filter of klient value. Now I would like to use second multiselect on this form for product...
0
by: - HAL9000 | last post by:
Was/Is there a resolution to this bug of using ListView check boxes and MultiSelect together? I have the same difficulty as the author. ...
3
by: kaosyeti via AccessMonster.com | last post by:
hey... i have an unbound multiselect listbox on a form that i want to use to populate text boxes on that form. so if a user selects the 3rd item in a list of 20, how can i have that item show up...
1
by: syam | last post by:
Hai Friends.. I have a search page and contains multiple multiselect list boxes, each containing 6 options. I want to check whether the user has checked atleast one option in each of...
5
by: martin DH | last post by:
Hello, The details are below, but I have a simple form (Form1) with two objects and a "search" command button. When the two objects are cascading combo boxes (the form creates the parameters for a...
1
by: Redbeard | last post by:
I am a newbie running Access 2003. A couple of weeks back a member named ADezil help me write a code that let a , MultiSelect Listboxs that run a Query on a Form (many thanks). I have used this...
4
by: redcali55 | last post by:
Hello, Does anyone know what to alter this VBA code (below) so that a report can be filtered using criteria from TWO multiselect boxes? e.g. allowing the user to view products from multiple...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.