Go Back   Access World Forums > Microsoft Access Discussion > Macros

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-12-2018, 12:51 AM   #1
ECEK
Newly Registered User
 
Join Date: Dec 2012
Posts: 657
Thanks: 200
Thanked 4 Times in 4 Posts
ECEK is on a distinguished road
Create an error Log

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 by ECEK; 04-12-2018 at 01:03 AM.
ECEK is offline   Reply With Quote
Old 04-12-2018, 01:07 AM   #2
Minty
AWF VIP
 
Minty's Avatar
 
Join Date: Jul 2013
Location: UK - Wiltshire
Posts: 5,797
Thanks: 140
Thanked 1,565 Times in 1,537 Posts
Minty has a spectacular aura about Minty has a spectacular aura about Minty has a spectacular aura about
Re: Create an error Log

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.
__________________
If we have helped please add to our reputation - click the scales symbol on the left, tick 'I approve' and leave a comment.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Minty is offline   Reply With Quote
Old 04-12-2018, 01:21 AM   #3
ECEK
Newly Registered User
 
Join Date: Dec 2012
Posts: 657
Thanks: 200
Thanked 4 Times in 4 Posts
ECEK is on a distinguished road
Re: Create an error Log

Sounds like a plan !!!

Thanks Minty
I created an Append query using Insert into.

I just open the Query

ECEK is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Create error msg box NikkCol Macros 5 11-19-2011 08:16 AM
help! error msg, can't create new records Sadie Hewgill General 12 10-28-2010 10:35 AM
Getting an error unable to create mde Jon123 General 3 06-13-2005 04:52 PM
Create error messages Kila Forms 5 02-08-2005 01:11 PM
[SOLVED] Need to create an error message! smcfadden2 Queries 1 10-27-2004 01:16 PM




All times are GMT -8. The time now is 07:18 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World