Doing Med11 and Med12 report from Frontdesk and then using Repaid to search on the excel sheet I find that seems Frontdesk produces OEN not PID. Just have to...
Quite a few improvements, but no new features. These improvements are mainly to do with the way SQLite optimizes it's searches, so it has to do with the SQL...
Fixed a bug where a date column in a BP node would not get a specified custom date format (eg 5/Feb/2008) if the first row in that date column had no date. ...
Dear Bart Our server is terminal server so we can do remote sessions. We now have Excell 2002 installed on there, is is possible to install repaid on there as...
Hi Paul, Yes, can't see any problem with that. We run it on terminal server, although I don't access the terminal server from home. Just run the installer on...
After seeing a SQL + timings dump where a SQLite table analyze took 2 minutes I have added some code that will avoid a table analyze when it is not needed....
I have worked out how to it . Memory cells have kicked in. From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
OK, was just about to answer. Answered Steve West today (off-list) for exactly the same question. Bart _____ From: ExcelReportingAddin@yahoogroups.com ...
One minor fix. Doing node right-click, SQLite, SQLite table of this node > sheet would pick up the global setting about not showing or showing the ENTRY_ID...
Better handling of the SQLite connection. This could avoid possible errors, but normally it will make no noticable difference. Fixed 3 bugs to do with the...
Forgot to mention the third bug and this had to do with the re-naming of a SQLite table in the reminder node, causing a message about an index already being...
Just noticed that one more fix is needed with this and that is that the reminder entries from the table ENTRY will need to have START_DATE. Will upload a fixed...
Fixed the bug mentioned before to do with the reminder node, so SQLite method will now handle START_DATE (applies from date) and ADDED_DATE. Version 18.62 Bart...
Mainly coding improvements that won't give any noticeable difference. One minor bug fix to do with the non-SQLite handling of the reminder node. Version 18.63 ...
Quite a few additions. In the Drug node the At least box can now be combined with the NOT checkbox being ticked. So, for example you could see who had not at ...
The option not to repeat the ID details in the vertical table seriously messed up all kind of macro actions and this has been fixed now. Dumping potential...
Fixed a bug that would show as an error (error message, so not a VBA error or a crash) with a search with the following conditions: Drug node with Notes...
Fixed a serious bug to do with the house-hold re-linking utility that was introduced about 2 weeks ago. Will explain this further after talking to Paul Smith,...
Hi Not sure if its something I'm obviously doing wrong - If so, can't see what it is. Ran standard report on diabetics on Insulin (I think its one that you ...
Angus, It is quite simple to do that, but obviously it will give you wrong or multiple NHS numbers. How do you have your list of DOB's? Bart _____ From:...
I had a list sent from a home and it will take forever to go through them for names they are in excel as 09.06.1855 Regards Angus _____ From: RB Smissaert...
Angus, Might as well explain now to do this. You will need to run a search with one ID node only and with any registration type and in the output you only need...
OK, in that case you may have to replace all the dots to forward slashes as otherwise it may not be recognized as dates. You can do that with Edit, Find,...
Audit trail search (Options, Search Audit Trail) now includes searching the table ADDRESSLINK. This is useful for if you have zero's in the field ADDRESS_ID of...
Fixed a bug (introduced a few days ago) where there would be an error message in a single patient report with a morbidity node with Free text ticked. Thanks to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
