multiple selection - Microsoft Access / VBA

Hello everybody !
I need little help from Your side.
I have form called Form2, and ListBox called List 20.
Property of List 20 allow multiple selection.
Also I have query called Distribution as mail merge source.I need to control
query Distribution to send letters to people selected in List 20.
When I use List20 control without multiple selection everything is OK.
Single letter is printed.

Thank You in advance for Your help
D

Nov 13 '05 #1

Subscribe Post Reply

2528

Rick Brandt

DK wrote:

Hello everybody !
I need little help from Your side.
I have form called Form2, and ListBox called List 20.
Property of List 20 allow multiple selection.
Also I have query called Distribution as mail merge source.I need to
control query Distribution to send letters to people selected in List
20.
When I use List20 control without multiple selection everything is OK.
Single letter is printed.

Thank You in advance for Your help
D

A ListBox with MultiSelect enabled always has a value of Null. The only way to
determine the selections is by using code to loop through the ItemsSelected
collection of the ListBox.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

THNX !
I will try to do so

"DK" <cc@cc.cc> wrote in message news:db**********@ss405.t-com.hr...

Hello everybody !
I need little help from Your side.
I have form called Form2, and ListBox called List 20.
Property of List 20 allow multiple selection.
Also I have query called Distribution as mail merge source.I need to control query Distribution to send letters to people selected in List 20.
When I use List20 control without multiple selection everything is OK.
Single letter is printed.

Thank You in advance for Your help
D

Nov 13 '05 #3

Similar topics

Multiple selection + table

by: Lori Costache | last post by:

Hi guys, I have a problem with multiple selection I have a list with 8 options in pull-down menu. For each option I have a price. Something like that :Element Price Table 10 Sofa ...

PHP

multiple selection

by: DK | last post by:

Hello everybody ! I need little help from Your side. I have form called Form2, and ListBox called List 20. Property of List 20 allow multiple selection. Also I have query called Distribution as...

Microsoft Access / VBA

How to process a CheckboxList multiple selection.

by: Jensen bredal | last post by:

Hello, Can someone guide me in how i may process a multiple selection on a databound checkboxlist? The checkboxlist is bound to a table of product category. The product category id is an FK in...

C# / C Sharp

setting a CListBox to multiple selection dynamically

by: Brent Baker | last post by:

Is there a way to change a CListBox from single selection to multiple selection, or back again, from inside the program after the CListBox has been created? Our application has several...

.NET Framework

Multiple selection in DropDownList

by: Michael Groeger | last post by:

Hi, I want to be able to have a DropDownList which supports multiple selection, but I haven't found a property for that in the DropDownList control. Is there a way to have multiple selection...

ASP.NET

Multiple selection in a DataGrid

by: Eddy Balan | last post by:

Hi. Please help me....... I would like to copy the datagrid contents to clipboard and then to paste it into Excel but I can't make a multiple selection. Eddy

Visual Basic .NET

dropdownlist multiple selection problem

by: ads | last post by:

hi, after binding the dropdownlist to a datasource, ive experience this error "Cannot have multiple items selected in a dropdownlist" after using the code:...

ASP.NET

Multiple selection in listbox without holding control key

by: bansh | last post by:

Hi all, As question title I need a javascript which provides the facility to make multiple selection without holding control key. Means I how is it possible to make multiple selection/deselction...

Javascript

How to use javascript code for Multiple selection box in HTML

by: shidram | last post by:

Hello sir, I have problem while using javascript with HTML multiple selection tag, I want to write javascript in such a way that if a I change the option by clicking on the radio button on html...

Javascript

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++