As requested some changes to the items under Options, Referrals. Main referral list routine is now done via SQLite (as that is a lot faster) and this is under...
Some changes to the code that let you pick up the currently selected problem of the patient loaded in Synergy. There were situations where this failed and if...
Bart I don't use to the Word Entries add-in (or not yet) but wondered if this code could pick up the selected problem for the relinking routine Paul _____ ...
Paul, It can do that, but it will be much easier to do this directly in the Word Macros add-in. This has an interface like Synergy, so 2 listviews With on the...
Hi Bart Seem to have been having a lot of problems recently with the version check utility. It runs & runs (shows as active in task Man) but fails to complete...
Hi Mike, Will have a look at that. What you could do in the meantime (although I don't think it will make a difference) is make sure you have the latest...
Some minor fixes. Running a report with a node with no Read code would give a warning and a suggestion to tick the Loop checkbox, even if this was ticked ...
Hi Bart Yes, pointing to correct file & version. I updated this morning from the prompt when starting rep-aid, and it loaded almost instantly! If I get...
Doing a plain SQL (right-click SQL box in SQL node and doing Run plain SQL) did put the sheet auto-filter buttons in the wrong row. Fixed this. DB Browser now...
Had one customer today who found a problem after moving to Synergy 1.9. This has to do with the reference to clinic.tlb, but not sure why this is a problem...
I'm still claiming to be relatively new to Rep-Aid and I just can't get my head around this one. Lets say I run a report for all Read Code G3 patients. Out of...
Hi Dennis, Simplest way to do that is with a report as attached. Not the FLNo (filter on last node) ticked in the report node. Regards, Bart _____ From:...
... I meant: note the FLNo _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of RB Smissaert Sent: 07...
Some minor improvements, one of them handling the situation where clinic.tlb or LoginServer.exe is missing from C:\medapps\S6000\ Never anticipated this, but...
Thanks for that. I had a filter too few and the other filter in the wrong place. Now I will have to work out how that works but home time beckons. I'm pleased...
Dennis, No problem. Best is always to post the report that you are having trouble with. It will need to be a zipped file as otherwise Yahoo will put it in the...
New version of the file WordEntriesFB.zip. The Word entries add-in (the simple list) in the .dot file now has the option to edit the .csv with an editor,...
There is a Registered/Usual GP option with drop down list but what about one for Staff? And especially their initials. I tend to need this a lot. I tried using...
Hi Den, The up button will show staff. This is in the ID node. Not sure what your idea is here as patients are normally only registered with GP's. The XTR box...
This file has a new .dot file again that now has the formatting options fixed. This formatting is explained in the help that you can see with: Show text file...
What I want to do is search by initials (those that appear on the right hand side of Syn) or in some cases those are not on the right hand side. There are...
Hi Dennis, OK, I see now what you are trying to do. Simplest is perhaps to change the user output to initials by doing: Options, General search settings, Set...
Here an example of how this would work in a SQL node: select e.patient_id, e.entry_id, e.read_code, e.term_text, e.added_date, e.start_date from entry e inner...
That sounds complicated and looks as if it would need to be changed every time I run it. However, I dumped the practice parameters and so I can now convert the...
Hi Bart Just tried to run the rcf report ListReferrals.rcf, but I get a runtime error 1004 The macro ListReferrals cannot be found. I have installed the latest...
... Maybe the SQL node report is best then. ... A and D represent? A is STAFF_ID and D is ROLE_TYPE Basically this is the same information as in the dumped...
... Yes, second row is an identical twin of first row. All the doctors are duplicates, perhaps it reads the Reg and Usual and enters them twice. DB Browser.......