Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Is this possible? (VB.net/Excel) 1
- Thread starter lisalis99
- Start date
SiriusBlackOp
Programmer
- Oct 20, 2006
- 503
- Thread starter
- #42
SiriusBlackOp
Programmer
- Oct 20, 2006
- 503
No... you are going to have to add it into here:
And then change this:
Senior Software Developer
Code:
For Each item In ListBox2.Items
If item.Selected = True Then
'--Note: if item.Value doesn't work use item.Text
[red]sFields += "[" & item.Value & "], "[/red]
End If
NextAnd then change this:
Code:
If sFields.Length > 2 Then
[red]sFields = sFields.Substring(0, (sFields.Length - 3))[/red]
End IfSenior Software Developer
SiriusBlackOp
Programmer
- Oct 20, 2006
- 503
SORRY.... AGAIN!!! Ahhhgg!
Forget that last part!
Just do the First Change!
The second one would have stripped out the "]" and we still need that or another SQL error will crop up.
Senior Software Developer
Forget that last part!
Just do the First Change!
The second one would have stripped out the "]" and we still need that or another SQL error will crop up.
Senior Software Developer
- Thread starter
- #45
SiriusBlackOp
Programmer
- Oct 20, 2006
- 503
- Status
