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
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
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...
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
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...
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...
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...
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 = " &...
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 = " &...