R
Rod
Hello,
I have tblDNC. I copy information from a PDF and paste it into tblDNC
[Number]. Number is of type text 10 format 0000000000, indexed (no
duplicates). There is verbage on the PDF, which most ends up generating an
error, which I tell Access to not tell me about and place in Paste Errors
(which I just delete). This takes care of the majority of the errors,
however, words such as Page 1, Pager 2, Page 300, I have to manually sort the
list and delete. Is there something I can do which will see the incoming
paste as not a number of format (###) ###-#### nor ###-#### and disreguard
the paste - no error message, just realize it is "Page 200" and should be
ignored?
Thanks much!
I have tblDNC. I copy information from a PDF and paste it into tblDNC
[Number]. Number is of type text 10 format 0000000000, indexed (no
duplicates). There is verbage on the PDF, which most ends up generating an
error, which I tell Access to not tell me about and place in Paste Errors
(which I just delete). This takes care of the majority of the errors,
however, words such as Page 1, Pager 2, Page 300, I have to manually sort the
list and delete. Is there something I can do which will see the incoming
paste as not a number of format (###) ###-#### nor ###-#### and disreguard
the paste - no error message, just realize it is "Page 200" and should be
ignored?
Thanks much!