Hello All:

I have hopefully a simple question for an experience Access Guru. I
have text files that I suck into Access with the wizard. Of course,
these files are in no way normalized and the data needs to be added to
the normalized structures at that point. I have written code to
select records from this import table, loop through the data one
record at a time and populate the appropriate normalized tables as
they should be populated. My problem arises in that everytime I try
to add a record, a system message pops up to TELL ME that I am
inserting a record! I click OK and the next popup comes. Basically,
I'm trying to automate an insert, and I can't figure out a way to
override or get rid of these annoying little popups. Once I have all
of the issues and bugs worked out, I want to run it and inform myself
ONLY when the routine is done!

I thought about using macros, but I am not able to do all of the logic
steps that are required to parse,... look for existing records... if
then's ... you know what I mean... I feel like I have more power in a
Sub.

There must be others of you out there who have written or had the need
to do similar import routines. Am I taking the wrong approach, or how
do I turn off these messages.

Some Guru out there... pleae help! Iny input is appreciated!