Creating a log when errors occur during process

[lynchoftawa]

Hi All

I think this is my first post, so I am expecting big things. Actually the boss has asked me to fix this problem, I am sure he has more faith in me than I do in myself, so I would hate to let him down.

We, and I say losely we, have built a process where correspondence is sent to the client when a xml or pdf file exists in a specified folder. The process uses a combination of data from the xml and data from a static table in the workbook.

What I need to create in a seperate worksheet is a error log that appends data based on the information provided, or not as the case exists.

The original process was built in MS Access, adding error information to a table called 'Log', what I need to do is transport that thinking to Excel. The original code that was used in MS Access is as follows;

Docmd.RunSQL ("INSERT INTO Log (LogTimeDate, Recipient, Address, TalismanAccount, Type) SELECT Now(), 'Processing Error', 'No static data entry for this account and Correspondence type (and no default settings found) - update static data' , '" & strTalismanAccount & "','" & strCorresType & " ' ; ")

There is also the need for an ErrorID in the log. This would of originally been taken care of with the AutoNumber in Access, no such luxury in MS Excel.

If I need to add further information, please let me know.

Thanks in advance

 

[dk]

Hi

Can I ask why you're moving your logging system from Access to Excel? A database system would normally be the natural choice for a system such as this (tighter control over what gets entered, better security). You said that your boss wants to you "fix this problem" but you haven't really described what the problem is. What are the specific issues that you're having?

DK

 

[lynchoftawa]

I know that MS Excel is not ideal, however my company has a problem with developing solutions using MS Access, that is why I am were I am.

 

[dk]

OK, fair enough, I've come across that same problem (normally with the IT department). Anyway, the point of my post was to ask you what your problem is as you haven't actually posted a question but rather just described the scenario you're currently in. Are you after some general guidelines of how to convert your project or are you facing a specific issue with your code? Without more specifics it is unlikely that anyone will be able to help you...