Create an error Log (1 Viewer)

E

ECEK

Registered User.

Local time

Today, 20:32

Joined

Dec 19, 2012

Messages

717

• Apr 12, 2018

• #1

I have a series of Macros that import data.
On error I want to insert text into a Table to record the errors.

On error insert new into tblErrorLog ErrorText "This particular import didn't work" , go to next.

Could you point me the right direction to build the Macro that will do this.

Many, many thanks for your time.

 

Last edited: Apr 12, 2018

Minty

AWF VIP

Local time

Today, 20:32

Joined

Jul 26, 2013

Messages

10,367

• Apr 12, 2018

• #2

I think you may need to use VBA to achieve this, and I would be tempted to create a module to do this so you simply call it wherever the error occurs, rather than hard coding it per macro.

I'm not to sure that the wise owls here ever use macro's, so you may struggle to get a speedy response.

 

E

ECEK

Registered User.

Local time

Today, 20:32

Joined

Dec 19, 2012

Messages

717

• Apr 12, 2018

• #3

Sounds like a plan !!!

Thanks Minty
I created an Append query using Insert into.

I just open the Query