Add warning messages to a form

[Patrick1977]

Hello,

I have a database that is importing and manipulating a bunch of text files.
I have a form with several buttons that implement the import and processing steps.
During the import steps, there are several message boxes that pop up saying: "Microsoft Access was unable to append all the data in the table." and describes 'key-violations' and ask if I want to proceed.

I would like these messages to be added, in order, to a subform and for the message boxes to not appear, but accepted.



Does anyone know how to do this?

I suppose it is a matter of grabbing the messages, and adding those to a table that can be shown as a subform on the main form. Using VBA, how do I grab the messages and automatically accept them?

Thank you for any insight.

[rpeare]

I didn't test this but you'd want something like this to trap the errors, not sure if the resume next will force the acceptance or not but it might.

sub whatever()
dim smsg

On Error GOTO ERRHANDLER

'do your stuff here

me.NOTICEFIELD = smsg

exit sub

ERRHANDLER:
smsg = smsg & err.number & err.description & vbcrlf
resume next

end sub

EDIT: if you're trying to trap the '0 records added 1 record ignored ' I don't think you can, those are part of the database engine of MS access, I could be wrong, and frequently am and someone can correct me if I am.

[davegri]

See attached zip file. It shows how to create an error log file (table) and how to show or not show users the error messages as they occur. You can probably adapt it for your use. It also includes a report to show the error log.
Good luck,
UpRider