Bart Rep-Aid is not picking up that loaded reports are "read only" so changes are not saved I loaded a report and got a message that it was an old style report...
Paul, I never had anticipated dealing with read-only report files, so this doesn't surprise me. Will have a look at this and fix it. Bart _____ From:...
Paul, I loaded your report. Got the message about old style etc. Saved the report as it was, so with the = button. Opened the same report and no message, so it...
Bart I changed the read only attribute during the time I was writing the email and after adding the attachment. Try making one of your reports "read only" and...
Paul, All fixed now. I took it that if the file was read-only to start with it should remain read-only. So what happens now is: Open read-only file. Alter it,...
Bart I now have my list of un-issued medication and I would now like to discontinue them all. You showed me how to do this abiyt a year ago but I did not keep...
John, I will have a look right now and come back in a bit. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On...
John, I needed to check as I have made this difficult to do for obvious reasons. This is how you do it: 1. Run Options, Database writing utilities, List...
All went according to plan until Repaid checked for other users logged in. First method failed and in the second method it was unable to find the "Location...
John, What do you mean by first method failed? How did you login? You could try a different login. If you tell me your personal e-mail I can mail some other...
I not at surgery at the moment but from memory: It searches for other users and then a box comes up something like: Unable to use method to to find users would...
Mainly some work on the new SQLite method. Can now do secondary ID nodes and NOT ID nodes and also collection nodes. As the drug node can be used as a...
Bart I am trying to find patients being prescribed more than 28 days of CDs as per the new regulations, but am disappointed by my efforts I have created a...
Paul, This never will be very simple, but maybe it can be done with some macro actions (using sheet formula's) added to the report you got now. If you send me...
Paul, If you can delegate then that might be a good move. Will let you know if I have a good way to determine the number of supplied days. As this is a useful...
Paul, Had a look at this and I think the simplest way to do it is by making a dosage lookup list. This is how you would do that: Run your search as you got it...
Hi Bart Bit of a dummy question here. What is the logic behind the text colours in the read code browser? Many appear in red, others blue. the only option i...
Hi Mike, The colours are there to make it easier to see the logic of the different sub-groups. For example if I browse for bd in Read codes then I get this...
Paul, Had a look on our system and we have over 6000 different dosages. Many of them can't be used for a lookup table, but you could ask one of your...
See - told you I was having a 'thick' day! Its something I'd never really taken any notice of before, but recently had been searching on terms rather than...
Even when you search on a term the colour coding will make sense. Just noticed a bug. When you use the S option (using a SQLite DB) and right-click an item to...
... A workaround for this is to tick the D checkbox and then right-click the item and show the keyword(s). After having done this once you could set it back to...
Fixed a bug in the Read code browser where right-clicking a list item to see the keywords would cause an error if there was no connection with the live...
... Forgot to mention drug nodes there. Bart _____ From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
Some further fixes/additions to the new SQLite method. 2 fixes to do with the Read code browser: Searching on keyword (K checkbox checked) wouldn't find any...
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.
