Where am I in the table when my UDF bombs??

  • Thread starter Thread starter G Lykos
  • Start date Start date
G

G Lykos

Greetings! Have a UDF that is used in an append query, and it chokes on a
particular source data combination. Is there a simple and direct method to
determine the record number in the source table when this happens?

Thanks,
George
 
George,

You will need to give more details before anyone could give an
intelligent reply. But probably not, if you are talking about an Append
Query... as far as I know, this does not proceed by sequential
individual records.
 
Steve, I thought the description was reasonably unambiguous, but I'll
elaborate - an append query which includes a UDF call is reading records
from an input table, and on some data combination the UDF errs out. I want
to go to the problem record in the datasheet view of the table. The
datasheet view of the table has a record position indicator at the bottom.
When I stop on each UDF call, the query appears to process the input table
in the same order as displayed in the datasheet view. Can I somehow read
the current record number inside the UDF (short of filling a calculated
record number field and passing it as another parameter to the UDF)?

Thanks,
George
 
Back
Top