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!

At the start of your routine issue

Docmd.SetWarnings False

Then at the end

Docmd.SetWarnings True (else it stays off for your entire session)

--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/response

"BlueDolphin" <bluedolphin1414 (AT) hotmail (DOT) com> wrote

while you can do it this way if you didnt start with normalized data
(eg tab delimited) then you will probably end up with import errors in
the first place no? my solution to this issue was to use vba to
normalize the data before importing. then the import can get it right
the first time.

John
jobrien at acscience dot com


bluedolphin1414 (AT) hotmail (DOT) com (BlueDolphin) wrote in message news:<fb300aa1.0310310829.436deb0b (AT) posting (DOT) google.com>...

It sounds like you could use Docmd.Setwarnings False
to suppress any warnings (pop-ups telling you you are inserting, updating,
deleting, etc.)
HOWEVER, make sure you use Docmd.Setwarnings True in your error handler as
well as at the conclusion of your inserting code or else you could have
problems down the road.

Hope this helps.

Tim

"John" <jobrienct (AT) excite (DOT) com> wrote