Search the web
Sign In
New User? Sign Up
ExcelReportingAddin · Rep-Aid
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 3809 - 3839 of 3839   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
3809
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...
bartsmissaert@...
bartsmissaert
Offline Send Email
Sep 30, 2009
9:49 am
3810
Hi Mike, Replace this bit: 170 If Replace(Replace(strUsers, Chr(32), ""), ",", "") = _ CLng(Replace(Replace(strUsers, Chr(32), ""), ",", "")) Then with...
bartsmissaert@...
bartsmissaert
Offline Send Email
Sep 30, 2009
10:21 am
3811
Attached the fixed file. Bart...
bartsmissaert@...
bartsmissaert
Offline Send Email
Sep 30, 2009
10:33 am
3812
Yes that works fine. many thanks for your usual prompt & effective reponses! all the best Mike...
Mike
mikehur_2005
Offline Send Email
Sep 30, 2009
10:45 am
3813
No trouble. I know this was fixed before and not sure how it came back to the faulty code. Regards, Bart...
bartsmissaert@...
bartsmissaert
Offline Send Email
Sep 30, 2009
10:49 am
3814
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...
bartsmissaert
Offline Send Email
Oct 1, 2009
12:47 pm
3816
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. ...
bartsmissaert
Offline Send Email
Oct 2, 2009
1:21 pm
3817
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...
Stenton, Mark
markstenton
Offline Send Email
Oct 5, 2009
4:41 pm
3818
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 ...
Graham Gibson
grahamcgibson
Offline Send Email
Oct 7, 2009
7:58 pm
3819
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...
bartsmissaert
Offline Send Email
Oct 7, 2009
8:59 pm
3820
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),...
bartsmissaert
Offline Send Email
Oct 11, 2009
9:41 pm
3821
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...
anrigby
Offline Send Email
Oct 13, 2009
3:55 pm
3822
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 ...
Paul Smith
drpsmith1957
Offline Send Email
Oct 13, 2009
4:19 pm
3823
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...
bartsmissaert@...
bartsmissaert
Offline Send Email
Oct 13, 2009
4:38 pm
3824
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...
bartsmissaert
Offline Send Email
Oct 13, 2009
10:10 pm
3825
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...
bartsmissaert
Offline Send Email
Oct 14, 2009
10:40 pm
3826
Thanks very much to you and Paul for the info - I do seem to remember this . . . Andrew...
anrigby
Offline Send Email
Oct 15, 2009
7:22 am
3827
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...
bartsmissaert
Offline Send Email
Oct 18, 2009
11:12 pm
3828
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...
bartsmissaert
Offline Send Email
Oct 19, 2009
7:47 am
3829
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...
bartsmissaert
Offline Send Email
Oct 19, 2009
8:28 am
3830
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...
bartsmissaert
Offline Send Email
Oct 22, 2009
11:06 pm
3831
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...
bartsmissaert
Offline Send Email
Oct 29, 2009
10:46 pm
3832
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 ...
Richard Trueman
drrichardtru...
Offline Send Email
Oct 30, 2009
7:30 am
3833
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...
RB Smissaert
bartsmissaert
Offline Send Email
Oct 30, 2009
8:26 am
3834
I agree: I think Dormant should be ticked by default. 2009/10/30 Richard Trueman <richardtrueman@...> ... -- Regards, John L. I agree: I think Dormant...
John Lockley
wjohn.lockley
Offline Send Email
Oct 30, 2009
9:50 am
3835
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...
RB Smissaert
bartsmissaert
Offline Send Email
Oct 30, 2009
10:07 am
3836
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...
bartsmissaert
Offline Send Email
Oct 30, 2009
12:30 pm
3837
Thanks Bart, I'm trying to work out how you can speed up your response time! J Richard From: ExcelReportingAddin@yahoogroups.com ...
Richard Trueman
drrichardtru...
Offline Send Email
Oct 30, 2009
6:21 pm
3838
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...
bartsmissaert
Offline Send Email
Nov 1, 2009
9:43 pm
3839
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: ...
bartsmissaert
Offline Send Email
Nov 4, 2009
11:51 pm
Messages 3809 - 3839 of 3839   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help