 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / March 2005Catching import errors from using transfertext
Hi, I've created a button in a form that calls the transfertext function to import a file when it's clicked. Currently the user is not informed when there are import errors. e.g., type conversion errors in fields - the row is still imported, and the errors logged in a new table, but unless the user checks the tables, he wouldn't know there was an error during importing. is there a way to catch all these errors and prompt the user? And is there a way to show the user the rows affected (i.e. open the table) by clicking another button? Thanks! Hi, what you can do: before transfertext you delete at import errors table you have, then run transfertext, after it you check for import errors table - once one is exists - you can give a warning to user and then show data.  SignatureAlex Dybenko (MVP) http://Alex.Dybenko.com http://www.PointLtd.com > Hi, I've created a button in a form that calls the transfertext function > to [quoted text clipped - 10 lines] > > Thanks! Hi Alex, thanks for the suggestion. How would I be able to identify which table contains the import errors? Will the table name always be the same, allowing me to hard code the table name in the code? > Hi, > what you can do: [quoted text clipped - 16 lines] > > > > Thanks! Hi, i do not remember naming convention for import errors table, but once you get it- you will know. just make you you delete any of it before import -then once you have it after import - thn error(s) occure SignatureAlex Dybenko (MVP) http://Alex.Dybenko.com http://www.PointLtd.com > Hi Alex, thanks for the suggestion. How would I be able to identify which > table contains the import errors? Will the table name always be the same, [quoted text clipped - 26 lines] >> > >> > Thanks! Alex, I've got it working now... Thanks again... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.