M
microfich
Hi, newbie here.
If you could hold my hand a bit please...
I am importing several large (up to 1MM rows) txt files into several Access
tables and want to check for roughly 200 format and value errors and ref.
integrity scenarios. This will not be an application, just a 2 or 3 time
effort to support a conversion. I entered validation rules for the scenarios
into the table design and while that works to a point at import time, no
specific errors are thrown and I'd like to be able to code to show all the
errors in a query or report (e.g. If table.field1.value <> 'xyz' then "Record
#n: field 1 value not equal to 'xyz' ".)
I'm thinking of creating a form with a button that would launch the error
checking but don't really know how to go about the coding of it. Any advice
on the best way to do this?
Thanks!
If you could hold my hand a bit please...
I am importing several large (up to 1MM rows) txt files into several Access
tables and want to check for roughly 200 format and value errors and ref.
integrity scenarios. This will not be an application, just a 2 or 3 time
effort to support a conversion. I entered validation rules for the scenarios
into the table design and while that works to a point at import time, no
specific errors are thrown and I'd like to be able to code to show all the
errors in a query or report (e.g. If table.field1.value <> 'xyz' then "Record
#n: field 1 value not equal to 'xyz' ".)
I'm thinking of creating a form with a button that would launch the error
checking but don't really know how to go about the coding of it. Any advice
on the best way to do this?
Thanks!