automate importing text via macro and windows scheduler issue

[Alexander Heimann]

I have succesfully created a macro to update a table by importing a
text file using the transfer text macro and the import specification.
When I click on the macro i get a text pop up letting me know it
couldn't append all the records in the text file due to key
violations. This is fine because i just need to update new records so
i click yes and continue anyway and it works great.. My problem is
that i want ot automate this macro using windows scheduler. I won't
able to click yes obviously. Any ideas? Should I Code a macro that
handles the pop up. Do you think I should import the text file into a
temp table, use a query to find new records, then only import new
records.

What do you guys think?

A

 

[PG]

Have you tried turning off the error messaging?

 

[PG]

DoCmd.SetWarnings False

-----Original Message-----
Have you tried turning off the error messaging?
me
know it
.

 

[Steve Schapel]

Alexander,

Put a SetWarnings/No action in your macro ahead of the TransferText action.

 

[Alexander Heimann]

Alexander,

Put a SetWarnings/No action in your macro ahead of the TransferText action.

thanks for all your help guys. now if the sys admin will get back to
me i can set up the scheduler. that database is on a networked drive
and i am thinking the reason the macro's aren't running is because i
need to set the scheduler on the server and not on my workstation,
probably a goodidea either way .. that way i can turn my workstation
off

thanks again