custom warning message for data import

[Laoballer]

I'm creating an access program that will import a lot of tab delimited
text files. The table these files are being imported into has rules
so if I have a bad field in one of my file that record won't get
imported into the table. What I would like to do is be able to
display a msgbox with a message telling the user that the file being
imported won't import every record and that there's some fields with
bad data along with that file name. Is this possible?

I'm using DoCmd.TransferText acImportDelim

for the importing.

Thanks

 

[Allen Browne]

Answered in your post 1/2 hour later.