Search results

  1. V

    Recordset Bookmark return no current record

    I am just trying to filter record and copy value base on a criteria. Once the first value is copy I want o bookmark the record on the destination table so I can copy the second value to the same record
  2. V

    Recordset Bookmark return no current record

    I tried placing the bookmark at the beginning and I got the same result: No current record
  3. V

    Recordset Bookmark return no current record

    I declared the RSbookmark mark as variant. I did not copy this part of the code but I state it on the information. the bookmark was set on the else statement
  4. V

    Recordset Bookmark return no current record

    Hi I am trying to bookmark the position on a recordset to later return to the same position and the bookmark codes is returning no record. I have not used this before but any help will be greatly appreciated. The problem is when stepping to RSBookmark = rs4.Bookmark the rsbookmark has been...
  5. V

    Adding Default value of zero when there is no any value

    Does not works means it does not print zero when the value is null. The invoiceamount is a field in the new table. I am pulling the invoice amount from one table and copy into another
  6. V

    Adding Default value of zero when there is no any value

    I tried both of these options and it does not work. I created this field on the table using the tabledef and I created as double.
  7. V

    Adding Default value of zero when there is no any value

    Hi all; I am having a hard time adding a zero to a calculated value to a group of fields on a table. I can not add this property under the table because I am deleting and creating the table often. I tried NZ and Format and I was not able to see default zero when there is not value. Any help...
  8. V

    Reuseable Where Condition

    I am not following the original advice. The variable are declared outside de procedure
  9. 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
  10. 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...
  11. 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...
  12. 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 = " &...
  13. 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 = " &...
  14. V

    Dealing with Null value on SQL Statement

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

    Dealing with Null value on SQL Statement

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

    Dealing with Null value on SQL Statement

    these data type is integer
  17. 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
  18. 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...
  19. V

    Dealing with Null value on SQL Statement

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

    Dealing with Null value on SQL Statement

    I tried that and it does not work
Top Bottom