-
Hi,
First I want to appologize for my bad English,I hope someone will understand me.
I'm creating a new appliction for my company but I'm stuck.
Here is my problem.
So I created a form with a listbox(1) within data based on a table. Then I created another listbox(2) because I have to select several things from listbox(1). So I placed a button on my form and I can add my selected data into listbox(2).
But I also placed a button on it to remove data from listbox(2) in case of I added something wrong. This also works but when I now want to add new data,he also add the data I already removed. And then second thing I want to use the data of listbox(2) as criteria for a query. It works when I use a combobox but not with a listbox. I already know that I have to work with SQL but I never worked with SQL.
By th way I work with Access97
So can someone help me please??
This is my code
Option Compare Database
Option Explicit
Private Sub Command10_Click()
On Error GoTo Err_Command10_Click
DoCmd.Quit
Exit_Command10_Click:
Exit Sub
Err_Command10_Click:
MsgBox Err.Description
Resume Exit_Command10_Click
End Sub
Sub cmdCopyItem_Click()
End Sub
Function CopySelected(frm As Form) As Integer
End Function
Private Sub Command50_Click() 'add
Dim ctlSource As Control
Dim ctlDest As Control
Static strItems As String
Dim intCurrentRow As Integer
Set ctlSource = lst_bts
Set ctlDest = lst_selectedbts
For intCurrentRow = 0 To ctlSource.ListCount - 1
If ctlSource.Selected(intCurrentRow) Then
strItems = strItems & ctlSource.Column(0, intCurrentRow) & ";"
End If
Next intCurrentRow
' Reset destination control's RowSource property.
ctlDest.RowSource = ""
ctlDest.RowSource = strItems
lst_selectedbts.RowSource = strItems
lst_selectedbts.Requery
txtSelected_bts.Value = strItems
End Sub
Private Sub Command51_Click() 'remove
Dim ctlDest As Control
Dim intCurrentRow As Integer
Dim strItems As String
Set ctlDest = lst_selectedbts
For intCurrentRow = 0 To ctlDest.ListCount - 1
If Not ctlDest.Selected(intCurrentRow) Then
strItems = strItems & ctlDest.Column(0, intCurrentRow) & ";"
End If
Next intCurrentRow
ctlDest.RowSource = ""
ctlDest.RowSource = strItems
End Sub
Private Sub Form_Click()
ReDim strSelectie(lst_bts.ListCount - 1)
txtSelected_bts = ""
End Sub
Private Sub Form_Load()
ReDim strSelectie(lst_bts.ListCount - 1)
End Sub
-
Hi Pieje,
Your problem is with your
Static strItem As String
Didn't you receive my mail...or was I wrong...?
Ps: My email adress at work is:
[email protected]