Search results

  1. V

    Reuseable Where Condition

    I just need a way to pass value from one procedure to another or just use the result of the a prior procedure into another
  2. V

    Reuseable Where Condition

    I am looking for some guide from this great community. I am creating a filter form to run different reports based on the criteria selected on the form. The Where condition on the onclick event is working fine. The issue that I am having is when I call the runreport procedure, the value created...
  3. V

    Dealing with Null value on SQL Statement

    I tested the nz(RS2!CompanyID,0) and nz(RS2!CompanyID, " ") and I received the following errors Error 94 invalid use of null (debug.print one) and 3075 missing operator with debug.print two plancarrier=1 And entityid=2 And benefitsID=1 AND plantype=7 AND plandatailid=60 AND...
  4. V

    Dealing with Null value on SQL Statement

    I created the following two variable Dim CoCodeID2 As Integer CoCodeID = Nz(rst!companyid) CoCodeID2 = Nz(RS2!companyid) I used as following and I received error -2147352567 SumInvoiceAmt = DSum("invoiceamount", "tbbilling", " plancarrier =" & RS2!PlanCarrier & " And entityid = " &...
  5. V

    Dealing with Null value on SQL Statement

    When I run the code it gave me error 3075 Missing Operator SumInvoiceAmt = DSum("invoiceamount", "tbbilling", " plancarrier =" & RS2!PlanCarrier & " And entityid = " & RS2!EntityID & " And benefitsID = " & RS2!benefitsid & " AND plantype = " & RS2!plantype & " AND plandatailid = " &...
  6. V

    Dealing with Null value on SQL Statement

    The code works fine without the addition of the companyid
  7. V

    Dealing with Null value on SQL Statement

    I also tried to store the value on a variable and it was unsuccessfully.
  8. V

    Dealing with Null value on SQL Statement

    these data type is integer
  9. V

    Dealing with Null value on SQL Statement

    the tbbilling is just a table with the data companyid is the only one with some null value
  10. V

    Dealing with Null value on SQL Statement

    SumInvoiceAmt = DSum("invoiceamount", "tbbilling", " plancarrier =" & RS2!PlanCarrier & " And entityid = " & RS2!EntityID & " And benefitsID = " & RS2!benefitsid & " AND plantype = " & RS2!plantype & " AND plandatailid = " & rst!plandatailid & " AND year(invoicedate) = " & InvYr & " AND...
  11. V

    Dealing with Null value on SQL Statement

    When I used Zero it give invalid use of null
  12. V

    Dealing with Null value on SQL Statement

    I tried that and it does not work
  13. V

    Dealing with Null value on SQL Statement

    Hello All. I am breaking my head trying to find the way of handling this null value on the following expression. when I add the companyid parameter will give me syntax error 3075 of missing operator and I ran out of options base on my limited knowledge of vba. The code breaks when I add : "...
  14. V

    SQL Errror 3021

    Quick Question. When I am posting the value how do I tell vba where to post the value because the value is just posting to the end of the table no to the corresponding record
  15. V

    SQL Errror 3021

    Thanks all for your input. I requery the recordset and I not longer has that error.
  16. V

    SQL Errror 3021

    My approach is looking the matching value in the original table against the new table and then post the invoice amount in the month column on the new table
  17. V

    SQL Errror 3021

    I have the same code in anther place and it works fine
  18. V

    SQL Errror 3021

    I want to create and delete a table so I can post value from another table and then create a report with the final table value. My issue is populating the value of each month to the table recently created
  19. V

    SQL Errror 3021

    I need some advice regarding this code that is erroring out on the not match statement. It is giving up error 3021 on the rs2.findfirst line and I can not figure out what is wrong. I am just trying fill value for each month. Like a crosstab report On Error GoTo ErrorHandle Set db =...
  20. V

    VBA Incorrect DatePart

    This option works
Back
Top Bottom