User Profile

Collapse

Profile Sidebar

Collapse
twink
twink
Last Activity: Oct 4 '07, 03:25 AM
Joined: Jul 20 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • twink
    started a topic Run Time Error In VBA Code

    Run Time Error In VBA Code

    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...
    See more | Go to post

  • 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;"...
    See more | Go to post

  • twink
    replied to I have a problem with my access report
    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....
    See more | Go to post

    Leave a comment:


  • twink
    replied to I have a problem with my access report
    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...
    See more | Go to post

    Leave a comment:


  • twink
    started a topic I have a problem with my access report

    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
    See more | Go to post

  • twink
    started a topic Access report

    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.
    See more | Go to post
No activity results to display
Show More
Working...