Recent content by PanKey

Maybe I should clarify I need at regular interval to import a couple of CSV files. These files are linked tables in access. The rules and XY transformations are complex. Hence the combination of UDF's and Queries. My div by zero is a simplification of such a transformation. The main business...

There was a slight error in above code Dbengine.committrans should be above v: But the problem is still there

Hi paul That will not update the single row But the good rows will be updated and i do not want that

Hi In below test scenario i would like to do a rollback but my err handler is never reached. Access throws its own error " devision by zero" Table2 holds 2 fields type double Thevalue( is first field) TheResult ( is second field and has nulls) 5 7 0 8 Function myCalc(TV As Variant) As Double...