am trying to access certain rows in a table through a combo box.Basically what I am trying to do is when I select "Delete Data" from the combo box and click the go button it will run a macro. I get this error (Run-time error '3265' Item not found in this collection) Here is the code. I am new to VBA so please excuse me. Here is the code:
Private Sub GO_Click()
Set rec = New ADODB.Recordset
Dim rs As...
User Profile
Collapse
-
Run Time Error In VBA Code
-
Run Time error in VBA code when trying to access rows from a table
I am trying to access certain rows in a table in a combo box. I get this error (Run-time error '3265' Item not found in this collection) Here is the code. I am new to VBA so please excuse me. Here is the code:
Private Sub GO_Click()
Set rec = New ADODB.Recordset
Dim rs As Recordset
Dim sql As String
Dim Combo43 As ComboBox
sql = "SELECT tblListBox.List FROM tblListBox;"... -
Yes it is one person who happens to have multiple unique indentifiers. I know that Reggie Smith is the same person because that is what was told me to me by the person I set the data base up for. They stated that they needed him to have two unique indentifiers for business purposes.... -
Yes for instance Reggie Smith has two unique indentifiers. One is R5066 and the other is R5077. Since my query is ran by the r-id he comes up on my reports twice. I want him to show up once with all data of both r-id. For example
R5066 Reggie Smith 700 100 = 800
R5077 Reggie Smith 700 100 = 800
Report needs to look like
Reggie Smith 1600...Leave a comment:
-
I have a problem with my access report
I have a someone that is listed in my reports twice because they have two r-id. I need to take the data from both r-id and combine them? For example :
Reggie Smith 700 700
Reggie Smith 100 100
Needs to be
Reggie Smith 1600 -
Access report
I am creating a report in access. I have a employee that has two r-id which would be a primary key in my employee table. On my reports the the employee that has two different r-id is listed twice how do I get this combined? For example
5600 reggie smith 239.00 356.00
4600 regies smith 300.00 300.00
I need it to read 5600 reggies smith 1195 on my report.
No activity results to display
Show More
Leave a comment: