Here is some code:
DoCmd.SetWarnings False
.......
Call PPS_import([FILENM], 452, "Import UMC")
DoCmd.OpenQuery "fixPPS"
DoCmd.OpenQuery "fixPPS2"
DoCmd.OpenQuery "AppendPPSToImportTable"
The Problem:
PPS has a tendency to change the record lenght and they tend to put garbage
in the imput file. Record lenght should be 450 bytes, The garbage is
actually the command used to generate the file???? The garbage tends to be in
records 48 & 49.
Trust me, the PPS IT person does NOT know how to fix these problems.
The Ideal:
Take note, If PPS made a mistake then query "FIXPPS" will be the only query
that will give an error. IS is possible to lookup the "FIXPPS" query
results and see if it had an error? IF it did then I wont to open up a
special window that displays the "IMPORT TABLE". That way clearance
department can see if it just two bad records or the whole file that is bad.
Maybe give them a chance to delete the bad records...... Maybe.
I really don't wont the "error window" to open unless there is an error.
What do you think?
Scott Burke
|
Similar Threads
