The reason is that the user may not have Excel on there PC, and I need a way which looks seamless to the user to take Excel format data generated...

Jeff, you have been most helpful anyway, and I can getalong with what I have.

If I don't have the dynamic update to the actual table at the end of the...

Hi Jeff,

Its almost there...

When I add this to the end of the Instead Of Trigger...

-- Need to do the physical Insert or Update or Delete because this is an Instead...

Hi Jeff,

I could use an Instead Of Trigger, then I could go back to the previous version of the UDF and trigger and I could actually audit the changes to...

Hi Jeff,

That works. The only problem I have now is that once I add a text column onto the end of the table the trigger is on to test,

The follwoing part...

Hi Jeff, thanks for bearing with me.

You were right, I reduced the row length a bit and that solved the problem.

One final issue - It fails if the table the...

Thanks Jeff.

I have included both audit table and the table the trigger is on. The UDF and Tally Table are exactly as you specified in your original email.

I have fixed...

Jeff, thanks for the update. You have been most helpful.

I only had to make the following changes (extra quotes and remove the red...

Hi,

Thanks to your help Jeff, I am almost there. It audits changes made to multiple rows correctly, but when I update a single row and single field, it does...

Thanks Jeff,

I will give this a go.

CCB

Hi Jeff, I have just implemented it, but (forgive my ignorance), How do I actually link into it the old and new values of the changed items. The other thing is...

Hi Jeff, Yes, I forgot to put on the TableName column in the original post.

Thanks very much for the rest of the info. I will give it a go.

CCB

Thanks again Ken.

CCB

Perfect Kev,

You are a star.

CCB

Hi Ken,

Thanks very much for your reply.

It almost works except the insert bit generates a "A domain error occurred." message - If I remove the call to the UDF and put...