Visual Basic Programming

It had been 3 wks since my last blog... well, I was stucked with a project... Few months ago, I was appointed as second chair to the patient safety committee. The was this issue about the passover of doctors requested by the evaluation board. I was learning visual basic then and I took over the responsibility to write a simple program for this passover procedure. The concept was simple - each attending doctor enter the passover note of relevent patient on the computer and the doctor on call log on to the computer and read the passover then print it out and signed it. The concept was adapted from one of the university hospital. Well, just enter, write into file and read it out and print.... Well, the program took me few months to complete and it was very raw ... the was this obsticle keeping our staff to using it - the biodata of pt - > entering the biodata is not a simple task for people who are not good at chinese input....so eventhough it was ready but it was never in use. Until the last attack visit by the local National Insurance Agency officer - the inspector complaint about different handwriting and not so up to date progress note. So I was thinking of writing a Progress Note Program .... this time, I would need to get access to the hospital database. So after a few discussion with the project manager (our hospital computer system is contracted to a software firm), we had worked out a solution. I was reluctant to do in the past because the hospital would be billed for every task done by the firm. 

 After 6 weeks of effort - the program is currently online.... The Nursing Specialist would benefit from it and hopefully some of the doctors would like it......The passover program was integrated to this program and currently on its 2nd days of test run...... I mastered several skill during the process - mapping drive, cutting a long sentence into different line and accessing database. I am learning as an apperentice programmer and trying to evolve...The health department had started to pushed the concept of "paperless" hospital but it is currently governed by the electronic medical record act - 11 hospital had entered the project but I doubt we should follow.... there is one requirement which is strict - each record enter would need to be transferred to the mainframe of health department - electronically signed and stamped with a date and time then sent back to the local hospital computer before it is saved. That means once the progress note/ order sheet/ nursing note / imaging or whatever could not be altered later..... well, which I dont think is executable at the moment.... My next project is currently the order entry system ... I had a deathline of 2 weeks and I intend to make it...

There are lots of books regarding basic of VB2005 but only few of its talked about advance technique, most of the time, I would need to browse the net to found a solution...