Hi Mike, For starters try changing: Dim lUser As Long to Dim lUser As Variant Save the file (the .rcf file), close Excel and try again. Will have a better look...
This fixes a bug that had crept in in 22.01 when the option was taken out to run normal reports against a full SQLite "shadow" database. The result of this bug...
As requested the routine that analyzes generic prescribing(in Options, One-Click Reports) now has the option to only look at authorisations added by GP's. ...
Hi I would like to do an audit to produce a list of patients with an out of date epipen. The shelf-life is 18 months. I want to search for all the patients...
Hi Mark I think this should be OK in Rep-aid but if struggling would also be not too much problem in Synergy Reporting. We can look at this on Monday! Graham ...
Hi Graham and Mark, I think I somehow overlooked this mail and attached a report that does this. What you could do instead is make the first node issued before...
Some improvements to the DB writing utility to discontinue medication that hasn't been issued for x months. This utility is under Options (new Options menu),...
Bart You may have already been asked this in the group, and if so I apologise. Is there a way the current heading attached to a note entry can be displayed...
Andrew You add a drug node, change the entry type to note, put the letter read codes in the read code box(es) and the linked problem code in the box below ...
Hi Andrew, Yes, this can be done. Use a drug node and in the entry type drop down put Note entry. Then in the Link RC box, bottom right put a % character. Let...
Some minor fixes. 1. Firebird can do in SQL: SELECT FIRST 100 FROM TABLE and also: SELECT FIRST 100 SKIP 1000 FROM TABLE This could be used fine in a plain SQL...
As requested a little addition to the routine to find medication that hasn't been issued for x months. This is the option to specify the user who added the...
New file dhRichClient3.dll (thanks to Olaf Schmidt) with some minor fixes. DB writing utilities, Find un-issued medication now has the option to only find the...
Avoiding copying the credentials when the user hasn't logged into Synergy yet now has disabled the API login when the user has logged into Synergy. Had tested...
This fixes the API login (copying credentials from a running Synergy) as mentioned in the previous post. It now simply looks at the copied username and if it...
Two minor fixes: 1. New Options menu missed the option to specify for the vertical output report if the ID data (apart from PATIENT_ID) was repeated for the...
One fix and one addition: When setting up a report with an inter-node date comparison and later altering that report so that the date comparison was not valid...
Hi Bart I know this was discussed a while ago as I have been caught out by not ticking "include Dormant" as well. Should include Dormant be the default ...
Hi Richard, You can make Include dormant (so a tick in that checkbox) the default by doing this: Add a morbidity node Select that morbidity node Tick Include...
I agree: I think Dormant should be ticked by default. 2009/10/30 Richard Trueman <richardtrueman@...> ... -- Regards, John L. I agree: I think Dormant...
It will vary from practice to practice and in my practice it makes sense not to have this ticked by default. In any case, it is easy to alter the default and I...
Added the option to alter the node default to the node right-click menu. This makes sense as it saves a few clicks, plus the node default always applies only...
In the new Options menu, if you had specified to start with a different node than the first one (right-click node and Make this the startup node) then that...
This adds two SQLite UDF's (user defined functions) that make it simpler to pick out phone numbers that have non-numeric characters. These function are: ...