Bart I am using 19.04 but cannot convert OEN to PID Paul _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf...
Paul, I had another message about this, but works fine here. What error(s) do you get? Could you send me the list of OEN numbers you were trying to convert? ...
This is the version that is only at http://www.rbs-software.pwp.blueyonder.co.uk/ and which I kept for testing for now, although it seems all fine. Fixed a...
As I found a potential bug with the old 18.97 I have now uploaded the latest, 19.09 as a regular download file, so this is available as normal and the...
This file addresses a possible problem to do with the ADO version on your system. All this has to do with having moved code away from Excel to an external dll...
Dear Bart, Since upgrading to v 19.1 I noticed that when having an ID node as a child of an ID node it returns nothing. I have e mailed the report to your...
Hi Paul, All fixed now and new file, 19.13 uploaded. In you wanted to know all was due to this one line of code missing in the procedure that handles the ID...
Fixed a bug, spotted by Paul Nederlof where a secondary ID node would produce (wrongly) nil patients. Must have been a recent thing and not sure how it could...
Hi John, Thanks for confirming that. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of John...
No updates for a while and that is because I have been working on something big and it is not quite finished yet. As I found a bug to do with the drug node....
Hi Bart This isn't all that important, just something that Bart or group members may have an idea on. Without going into SQL, is there any way to set up...
Hi Mike, It should be no problem to do what you want, but just 2 questions to make sure: Are you on the iSoft appt system? It sounds you are, but just to make...
Hi Mike, Attached a .rcf file that shows a simple way to do what you want. I have done it for our GP's and this is the bit: AND " & _ "A.USERID IN(16, 18, 19,...
Yes, sorry I should have made that clear - we are using the standard Synergy appts system, and the appointmentstatistics.rcf file. Ideally (if feasible) it...
Attached a .rcf file that will give you a bit more flexibility as you can type the users you are interested in in the report description text box, eg: 16, 18,...
As this file seems fine (needed to make sure as there is a whole new SQLite engine) I have uploaded this now as a regular download. Uploaded to both sites and...
Thanks for that Bart (got the file from the mail you sent to my yahoo mailbox directly) It doesn't run unfortunately. Put the unzipped copy into the code files...
Hi Bart Yes, I ran it exactly the same as the original appts..stats.rcf file (which still works fine) If I come out of the 'prepare search2.preconnect message'...
Hi Mike, Yes, that help and what has happened was that I saved that imported code with the main .xla file, causing the problem as you described. I will upload...
Hi Mike, Have now uploaded a new file, 19.17 (will need running on all machines, due to a new dll) and hopefully now your .rcf file will run. Bart _____ From:...
Fixed 2 minor bugs I was alerted to today and have uploaded a new file, 19.17. Due to a new dll this will need running on all machines. Version 19.17 Bart...
Yep, that seems to work 'a treat'! Appears to collect data for all the desired 'workers' as listed in the description field: Just what I needed. Will do a bit...
One minor fix and one fix (has to be confirmed) to do with a possible ADO problem. This last one would show as a VBA error directly after trying to login. This...