Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / February 2008

Tip: Looking for answers? Try searching our database.

multiple selection

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
florin - 19 Feb 2008 15:57 GMT
How can I select multiple records into a list box?
I want that for append identical records (for select records)
in another table.
Many thanks
Florin
eliyhoo - 19 Feb 2008 23:44 GMT
> How can I select multiple records into a list box?
> I want that for append identical records (for select records)
> in another table.
> Many thanks
> Florin
>היי מה שלומך צרי קשר
florin - 20 Feb 2008 09:45 GMT
Any ideea?

> How can I select multiple records into a list box?
> I want that for append identical records (for select records)
> in another table.
> Many thanks
> Florin
Larry Linson - 20 Feb 2008 20:12 GMT
> How can I select multiple records into a list box?
> I want that for append identical records (for select records)
> in another table.

If you want to select multiple records from those listed in the list box,
the multi-select list box feature (see Access Help) will allow you to do
that.

If you want to select multiple copies of one record in a list box, you can
do that with a normal list box, and a text box to enter the number of copies
to <do whatever you want to do with>.

If you want to select multiple copies of multiple records, a List Box is not
the control you need. You could do that with a Subform Control and an
embedded Form.

On the other hand, if your design is such that you need to put multiple
copies of the same record into another table, that is likely an indication
that your design does not follow relational database design guidelines.  If
so, you should examine the design carefully, preferrably with the assistance
of and advice from, a relational database professional, because there's a
very high probability that correcting the design now will save you somewhere
between a little and a vast amount of time and energy in the future when you
work on this database.

Larry Linson
Microsoft Office Access MVP
tommu - 25 Feb 2008 12:10 GMT
Hi, I'm using Access 2003 and I cannot find a multi-select list box in the
Access help. Can you tell me the words I should be searching for?
Thanks

>  > How can I select multiple records into a list box?
>  > I want that for append identical records (for select records)
[quoted text clipped - 23 lines]
>  Larry Linson
>  Microsoft Office Access MVP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.