Robert Srna - his programs with source codes

»eskŠ verze

All programs here are free. They can be distributed as they are or modified. Author is not responsible for problems established with using this software. If you want to contact me, send me an e-mail If you like art there is http://srna.virt.cz. If you want see my other activities in Czech visit http://publikuj.virt.cz

IntHelp - universal help launcher utility
English
Available:Yes
After long time I got a good idea to write an utility. It helps you acces any documents from any program after you press a favorite key. Utility simple listens to your keystrokes and where it reaches a defined conditions it runs a query in Windows Desktop Search. Conditions can be configured so it queries only specific index items. You can read more and download it on http://inthelp.ic.cz

Extending SQL Server Management studio
English
Available:Yes
The work with new management stidio is litle bit awkward. I missed the possibility to search object on databases so I wrote a small program. You can read more here

Win Crash
Czech
Able:Yes
This joke is writen in JavaScript and when you mail it to your friens like HTML message - watch out not only like a html file attachment - they will love you. The best effect is with a preview set in their mailers. Code will be activated after mail delivery. You can send it directly from Internet Explorer here.

Booklet
English/Czech
Able:Yes
Program can print a word document in book order. All you need is a bothside printer and of course an MS Word 97. Firstly it takes side by side from your word document and saves it like a picture. Secondly it prints these pictures in user driven order. You can download my program (1.7MB) with source code in VB6 in 4 archives 1,2,3,4.

Financial accounting
Czech
Able:Yes
Download this program (1.8MB) with source code in Delphi 1 in 4 parts 1,2,3,4. There is my OMT documentation in MS Word and case study too. It uses Borland Database Engine.
Access documentor
Czech
Able:Yes
Download (0.1MB) source code in VB6 with EXE here - you need to have MDAC/Access and Excel drivers installed on your PC. In several Excel/Access tables you'll find a lot of about your MDB file.
Bank risk management system LIS2
Czech
Able:No
This system is not free. I just want to show you some elements from this program. It runs in one Czech bank. It uses three tiers: VB6 EXE, in-process dll and MS SQL 7 which is through ADO accessed.
On the right part you can see report of measuring the interest and duration risk of the USD02 (02 is an accounting parameter) portfolio. There is a detail of the cell (M1, A-VOL TOT) i.e. 81 857k USD in it. On the left part of this picture is a detail of an operation (FX-Swap) and of its partner.

You can see WinCVS administrating the source codes of LIS2. The red text shows a query in ADO using MS Jet provider (Access). New code (blue color) was changed because of missing order clause in views of MS SQL server.

You can see LIS2 in MS Visual Basic 6. How ease I'm calling the COM server (dll) for the credit analysis?

A part of contents of the programming documentation in a MS Word document (there are some UML diagrams too).

LIS2 saves reports in excel sheets. It's possible to prepare reports with a variable row and column count.