Search:

Look into the Multi select property of the listbox control

Hi everyone ...
I am creating an ADODB connection and recorset using code in a .BAS module. The procedure accepts a SQL string that is used to open the recordset.
I call it from form load and it...

PeeJavery ...
First, what did you expect the company to do for you? In reading your post, you actually do NOT own the software ...your friend does .... and by his "giving" it to you, both of you...

First make SURE you have ALL of MSDN installed. It has explanations of almost every control, method, property and event.
If you need help on a specific item, pressing F1 will generally lead you in...

Viki ..
Consider this code. I knocked it up real quick


Option Explicit
Dim intArray(3) As Integer

Private Sub Command1_Click()
Dim i As Integer
Dim strIn As String

mhd..
post your source code, otherwise we have no way of knowing what could be the prblem.

TwoDogs ...
Thanks ... I knew I was close. I was missing the ctrl.name part.

Hi everyone ..
I have several listboxes on a form .. named list1 through list12
They are NOT a control array.
I need to clear them on one button click. Currently, I have it as
List1.clear...

Take a look at this code..


Private Sub Command1_Click()
Dim i As Integer
For i = 0 To List1.ListCount - 1
If List1.Selected(i) Then
Debug.Print "You chose " &...

dinesh ...
Look here
http://www.connectionstrings.com/

or here, it looks like they have OLE DB Data provider connections for DB2/
http://www.able-consulting.com/ADO_Conn.htm

HTH
Michael

Clipper .. the purpose of this forum is NOT for us to do your homework for you, rather it is a place for you to ask questions on something that you are having trouble understanding or getting the...

Read-only is READ ONLY ... you cannot write to or manipulate a read only property.

Cjard ...
If you happen to have that in a small working project, I would love to see all the source code, so that maybe I can wrap my mind around it a little better.

It has to do with Scope.
A public variable must be declared in either a seperate module or in the General declarations section of a form. They can be accessed by ANY code within the project. Public...

I found this example somewhere on the Net, but I cannot remember where. Perhaps it will help you get going.

Webproject ...
I am not real sure that you will get a response on here for that request. The purpose of this Board is to answer specific questions on specific problems.
If you really need that...

1.) Identify your desired results.
2.) Design on paper the flow of your project.
3.) Break the design down to individual functions of the identified desired results.(New Book purchaes, Book sale,...

Thread1 ...
Since I only need the text of the first column in each row, I changed the code slightly and it works perfect.


Private Sub Command1_Click()
Dim vBM As Variant
Dim col As...

Thread1 ...
I will try that right now. The project does reference Excel and Word. I know Excel uses columns, and word does in some of its objects.
Thanks ... If this works(and I think it will), I...

Thread1 ....
Nope ... did not work :(
Type MisMatch error on this line ...

For Each col In DataGrid1.Columns
and
Method or Data memeber not found on this line...
MsgBox col.Text

I will...

Hi everyone .... I need to get the text of each item selected in a multi-select DataGrid control. I can get the index number, but so far, each attempt I have made only gets me the first item...

Got it ...


sWorkingString = Left$(sWorkingString, (Len(sWorkingString) - 1))

Hi everyone ...
I need to loop through a listbox(figured out), then remove the last character from the listbox item(Problem) then assign that to a new array.
Here is some of the code..
[VBCode]...

Hi everyone ... In a certain portion of a project I need to sort a 15 element String Array. So far, all my tries have ended in compile errors :-(
The only way I can think of do it now, would be to...

Found it

ListView Control with View property set to 3 - lvwReport.