VBA - Report Problems with Code

[UNAB]

http://rapidshare.com/files/976557196/TEST%20Infection%20Control%20Report%20Ver%201%203.xlsm


Hello!


I am very new to learning VBA and attached is a worksheet that I would like someone to take a look at and see what may be wrong with the code because I am having trouble completing the following report: (rapid share file attached)


1. When I add a new report under the In Progress and complete the sections it does not save under 'In Progess" and I get run time errors.


2. When I want to "Save and Lock" a "Completed Report" I get run time errors as well.


I would sincerely appreciate any help in getting this report to run correctly - saving the "New" and Sign and Locking a completed report.


Una

 

[shrivallabha]

Hi,


It looks like an application built by experienced programmer / developer. Why not ask the source to check and update?


If you are going to maintain it then you will have to spend some time understanding it.


The first error [when you hit save button] that comes is from module [Formfunctions] and it comes in a logic for 'Pneumonia algorithm' and more specifically,

[pre]

If .Item("chkNegPneu") = True Then
intScore = 0
Else

[/pre]
There must be some reason why the control [If loop] was defined so you will have to find it out to resolve it correctly.

 

[UNAB]

The person who built this is no longer with our company, so I am trying to learn. I will try to start at the beginning then.

 

[shrivallabha]

Very good. I am sure it will help you a lot in the long run if you like coding.


You can come back anytime, when you find it difficult to work out on your own. But then I am sure you will have more specific doubt and better control on things.