I have never been able to use the facility to input
an “absolute date range” (as opposed to a relative date range –
which works well) into my searches (using the Calender function); I invariably
get a Microsoft Visual Basic error message, where the “debug”
option flips me into a debug programme (which I have no idea how to use!), and the
“end” option dumps me out of the Add-in altogether.
An example of the error message might be
“Run-time error ‘-2147417848 (80010108)’
Method ‘Value of object ‘ICalendar’ failed”
Is this a known problem (although no-one else appears
to have complained) or can you help?
The file comes with the Access
installation, so if you have Office Proffessional then installing Acces will solve
it as well.
Bart
From:ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of hazle stuart Sent: 03 February 2006 16:45 To:ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Bart,
I have never been able to use the facility to input
an “absolute date range” (as opposed to a relative date range
– which works well) into my searches (using the Calender function); I
invariably get a Microsoft Visual Basic error message, where the
“debug” option flips me into a debug programme (which I have no
idea how to use!), and the “end” option dumps me out of the Add-in
altogether.
An example of the error message might be
“Run-time error ‘-2147417848
(80010108)’ Method ‘Value of object ‘ICalendar’
failed”
Is this a known problem (although no-one else appears
to have complained) or can you help?
Noticed from the .ini file that you might
still be on Office 10.
This text from the old Readme.txt file
describes all about this ocx file:
On some systems there might be a missing
file called MSCal.OCX. This is a file for the calendar control used by the
add-in.
If the calendar control works fine you can
forget about the next bit.
If the calendar control doesn't work you
will have to do as follows:
Put the file MSCal.OCX in the folder where
your Windows system file.
Register the file by doing:
Start
Run
regsvr32 C:\WINDOWS\SYSTEM32\mscal.ocx or
similar depending where the mscal.ocx file is
Start Excel
Alt F11
Tools
References
Find Microsoft Calendar Control 10.0 and
tick it
You may have to restart Excel to make it
work.
Some systems may need the older version of
the mscal.ocx file, version 8.0. This should be somewhere on the C drive or
on the Office installation disk. I think
this file comes with Access, so if you have Office Standard, you may have to
download this file from the internet.
All the different versions of the calendar
control are available from this website:
http://www.fontstuff.com/vba/vbatut07.htm
Click on the link in the top left in the
box Get the Calendar Control.
Bart
From:ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of hazle stuart Sent: 03 February 2006 16:45 To:ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Bart,
I have never been able to use the facility to input
an “absolute date range” (as opposed to a relative date range
– which works well) into my searches (using the Calender function); I
invariably get a Microsoft Visual Basic error message, where the
“debug” option flips me into a debug programme (which I have no idea
how to use!), and the “end” option dumps me out of the Add-in
altogether.
An example of the error message might be
“Run-time error ‘-2147417848
(80010108)’ Method ‘Value of object ‘ICalendar’
failed”
Is this a known problem (although no-one else appears
to have complained) or can you help?
On at least one machine I know of there could be a problem with the
mail-merge routine due to a bug in Excel. For who is interested in it,
this newsgroup thread discusses it: http://tinyurl.com/73tyv
I think this has been fixed now.
On some machines the absolute date picker wouldn't work due to not
having this control, due to not having installed Access. It is easy to
download and install this control, but as it is a bit of a hassle I
have done this now with another control that always should be
available. All works the same as before, so clicking on the date or
pressing the return button will enter that date in the particular textbox.
As requested have uploaded a Word .doc file to:
http://www.rbs-software.co.uk/
with the full help file in one Word document. This is for if you
wanted to print the help file.
Keep in mind that it is about 245 pages and also that there will be
corrections coming.
As requested added another database writing utility. This one will
relegate problems on a global basis. It will first move the items
linked to the problem to a different specified problem and then
optionally relegate the problem itself and link it to the same
specified problem. This utility works on data in the Excel sheet so it
is a 2-stage process.
It will need a report with at least 2 morbidity nodes, both with
problems only ticked and both with Show ENTRY_ID in the Entry flags
box. Also they both should produce a single entry, so the A option
button should not be checked.
The first morbidity nodes of these 2 will produce the problem entries
that will be relegated (and items linked to those problems re-linked)
and the second morbidity node of these 2 will produce the problems the
first problem will be relegated to. It will only deal with the
patients where an entry was found in both these morbidity nodes. Any
number of any kind of nodes can come before these 2 morbidity nodes,
but any nodes after them (below them in the treeview) won't make a
difference.
After this report has run and you are happy with the data in the sheet
you can run the actual routine
that does the relegating/re-linking. Before you do that you could
delete rows in the sheet of patients that you don't think should be
included in this.
Running the actual utility goes like this:
Close the add-in, move to a different sheet, type in cell A1: xxx,
start the add-in, move back to the sheet holding the data you just
produced. Then do: Options, Database writing utilities, Relegate
problems. It will check if the data is right, it will ask for
confirmation and it will ask if you want to relegate the actual
problem of the first of the 2 morbidity nodes. If you say no there
then it will only re-link the items linked to the problem of the first
morbidity node.
Apart from relegating and re-linking this will also put the current
date in the field UPDATED_DATE and it will put the user who is logged
in with the add-in in the field UPDATED_BY.
As this routine doesn't involve any inserts it can be run while other
users are connected.
Bear in mind that this routine could move a lot of entries and you
will have to make sure you fully understand what it precisely will do.
Best to try it first with a very small amount of patients and see what
it does.
Version 12.95
Bart
It would be easy to download and install
this control, but I have now replaced this control with another one that
always should be present. So, downloading
and installing 12.95 should solve this.
Bart
From:ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of hazle stuart Sent: 03 February 2006 16:45 To:ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Bart,
I have never been able to use the facility to input
an “absolute date range” (as opposed to a relative date range
– which works well) into my searches (using the Calender function); I
invariably get a Microsoft Visual Basic error message, where the
“debug” option flips me into a debug programme (which I have no
idea how to use!), and the “end” option dumps me out of the Add-in
altogether.
An example of the error message might be
“Run-time error ‘-2147417848
(80010108)’ Method ‘Value of object ‘ICalendar’
failed”
Is this a known problem (although no-one else appears
to have complained) or can you help?
Importing nodes from the sheet (after dumping a report setup in the
sheet) wouldn't work if row(s) were deleted, because it would mess up
the relations between the different nodes. Fixed this.
In certain rare situations with lots of NOT nodees the first row
(below the fields) in the big table could be blank. Fixed this.
Version 12.96
Bart
With the week-end in the way I just managed
to access your last few e-mails, and this solution was of course an absolute doddle.
It works fine after downloaded.
Thanks again for your first class service!
Stuart
-----Original Message----- From:
ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com] On
Behalf Of RB Smissaert Sent: 05 February 2006 10:38 To:
ExcelReportingAddin@yahoogroups.com Subject: RE: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Hazle,
Forget
about my previous reply to this.
It would
be easy to download and install this control, but I have now replaced this
control with another one that
always
should be present. So, downloading and installing 12.95 should solve this.
Bart
From:
ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com] On
Behalf Of hazle stuart Sent: 03 February 2006 16:45 To:
ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Bart,
I have never been able to
use the facility to input an “absolute date range” (as opposed to a
relative date range – which works well) into my searches (using the
Calender function); I invariably get a Microsoft Visual Basic error message,
where the “debug” option flips me into a debug programme (which I
have no idea how to use!), and the “end” option dumps me out of the
Add-in altogether.
An example of the error
message might be
“Run-time error
‘-2147417848 (80010108)’ Method ‘Value of object
‘ICalendar’ failed”
Is this a known problem
(although no-one else appears to have complained) or can you help?
No trouble. This new control has some
benefits as well compared to the old one, so it was worth the switch.
Note that clicking on the month in the
title will bring up a year spinner.
Bart
From:ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of hazle stuart Sent: 06 February 2006 13:19 To:ExcelReportingAddin@yahoogroups.com Subject: RE: [ExcelReportingAddin]
Microsoft Visual Basic error - when usingcalender for date entry
Thanks Bart,
With the week-end in the way I just
managed to access your last few e-mails, and this solution was of course an
absolute doddle. It works fine after downloaded.
Thanks again for your first class service!
Stuart
-----Original Message----- From:ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com]
On Behalf Of RB Smissaert Sent: 05 February 2006 10:38 To:ExcelReportingAddin@yahoogroups.com Subject: RE: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Hazle,
Forget
about my previous reply to this.
It would
be easy to download and install this control, but I have now replaced this
control with another one that
always should
be present. So, downloading and installing 12.95 should solve this.
Bart
From:ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of hazle stuart Sent: 03 February 2006 16:45 To:ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin]
Microsoft Visual Basic error - when using calender for date entry
Bart,
I have never been able to
use the facility to input an “absolute date range” (as opposed to a
relative date range – which works well) into my searches (using the
Calender function); I invariably get a Microsoft Visual Basic error message,
where the “debug” option flips me into a debug programme (which I
have no idea how to use!), and the “end” option dumps me out of the
Add-in altogether.
An example of the error
message might be
“Run-time error
‘-2147417848 (80010108)’ Method ‘Value of object
‘ICalendar’ failed”
Is this a known problem
(although no-one else appears to have complained) or can you help?
Found a bug thanks to the persistence of John Farrell.
This would show if there was a collection node on a NOT node and that
NOT node found all the patients that are in the parent node of that
NOT node (for example looking for Read code 00001) and the parent node
of that NOT node held a large number of patients. Rather than
collecting all the patients of that NOT node it would collect nil.
Fixed this.
Version 12.97
Bart
Bart
I am a bit confused about how to upgrade my single licence for v12.97 of the
add in to a full practice licence.
The helpfile says to install it first an then send a copy of the .ini file
to obtain a licence. But the info when I upgraded my single version to 12.97
said best to get the licence first, before installing. I presume this is the
more up to date advice.
Can you tell me how to make the £200 cheque to and where to send it and what
I should do now - I wish to install it on two other PCs.
Thank you
Dan Jeffery
GP
Stanley Surgery
Wakefield
Hi Dan,
This is how it goes:
Send a cheque for £200 to:
RB Smissaert
80 Tyninghame Avenue
Tettenhall
Wolverhampton WV6 9PW
West Midlands
Send me the add-in .ini files of any PC's you want to install the
software on.
Once I got the cheque I will then send the licence files. If you
want I can send temp licence files now for those machines.
Once you have the licence files put them in:
C:\RBSSynergyReporting\Program\
of those PC's.
Run the latest install file on all those PC's.
I can make you temp licence file(s) right now if you want.
Regards, Bart
> Bart
>
> I am a bit confused about how to upgrade my single licence for v12.97 of
> the
> add in to a full practice licence.
>
> The helpfile says to install it first an then send a copy of the .ini file
> to obtain a licence. But the info when I upgraded my single version to
> 12.97
> said best to get the licence first, before installing. I presume this is
> the
> more up to date advice.
>
> Can you tell me how to make the £200 cheque to and where to send it and
> what
> I should do now - I wish to install it on two other PCs.
>
> Thank you
>
> Dan Jeffery
> GP
> Stanley Surgery
> Wakefield
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Only a very minor change to hopefully fix an installation problem with
an unusual network setup. Only difference is that Excel version will
now be written to add-in .ini file on starting up Excel and not on
loading the add-in and this version will have one decimal number, so
11.0 instead of 11.
Version 12.98
Bart
Bart,
Mailmerge is now working fine on both laptop (Office 2003) and surgery
(Office 2000) setup.
Thanks.
Paul.
--
______________
Dr Paul J Maddy
paul.maddy@...
Paul,
Thanks for confirming.
Bart
-----Original Message-----
From: ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of Paul Maddy
Sent: 08 February 2006 07:49
To: ExcelReportingAddin@yahoogroups.com
Subject: [ExcelReportingAddin] mailmerge
Bart,
Mailmerge is now working fine on both laptop (Office 2003) and surgery
(Office 2000) setup.
Thanks.
Paul.
--
______________
Dr Paul J Maddy
paul.maddy@...
Yahoo! Groups Links
There could be an installation problem when it is a first time install.
This is fixed for Synergy systems, but not sure it is for S6000.
As there often is a problem uploading the installer file to Yahoo I
have left this off Yahoo now and you will have to go to:
http://www.rbs-software.co.uk/
This is also the automatic download site.
Version 13.01
Bart
Due to using a new inputbox that can handle less prompt text 2
routines didn't work anymore:
converting dates to QOF year and quarter.
List un-issued medication.
Fixed both.
With the All option (show all entries) the filter buttons would go
past the last field in the sheet. Fixed this.
Got rid of the Bart Simpson icon as I understand I could get sued for
using it.
Version 13.02
Bart
Dan,
I will put it back in if you pay me the potential legal bill.
Bart
> Bart
>
> That's s shame.
>
> Dan
> -----Original Message-----
>
> Got rid of the Bart Simpson icon as I understand I could get sued for
> using it.
>
> Version 13.02
>
> Bart
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Hmmm.
Dan
-----Original Message-----
From: ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com]On Behalf Of
bartsmissaert@...
Sent: 10 February 2006 09:22
To: ExcelReportingAddin@yahoogroups.com
Subject: RE: [ExcelReportingAddin] 13.02
Dan,
I will put it back in if you pay me the potential legal bill.
Bart
> Bart
>
> That's s shame.
>
> Dan
> -----Original Message-----
>
> Got rid of the Bart Simpson icon as I understand I could get sued for
> using it.
>
> Version 13.02
>
> Bart
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
Yahoo! Groups Links
Just to remind you if you do point your add-in at the MIQUEST tables they have to be refreshedI I believe this can be scheduled. They are an extract of the main DB and not automatically refreshed.
The regular VB MessageBox didn't have enough flexibility, so make one
with the Windows API. Still this wasn't good enough, for example
difficult to
get a fourth button.
Now made a custom MessageBox in a dll file.
As this is an extra file on the local PC the installer will need
running on every PC.
This dll can in fact be used by any VB or VBA developer who needs a
better MessageBox.
Version 13.03
Bart
Forgot to say, to update the file CustomMsgBox.dll (in
C:\RBSSynergyReporting\Program\) the old file will need
deleting, before running the installer.
Bart
Wil have a look into it.
Is there any easy GUI - type interface available to
write/edit Miquest queries?
Bart
--- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@...>
wrote:
>
>
> Bart
> Just to remind you if you do point your add-in at the MIQUEST
tables they
> have to be refreshedI I believe this can be scheduled. They are an
extract
> of the main DB and not automatically refreshed.
> Cheers
> John
>
I have tried running the flu report put on the addin site by David
Cowen but when I try running it, it comes up with an error saying that
a collection node above needs to be ticked, but I am not sure which
node to tick – can you advise me please.
This is a reasonably complex report and the only person that
will know for sure is David.
Maybe it is the node J61 and all the other node above on the
same level.
Just tick the nodes you want to collect from perhaps.
Bart
--- In ExcelReportingAddin@yahoogroups.com, "mjdoyle007" <mjdoyle@...>
wrote:
>
> I have tried running the flu report put on the addin site by David
> Cowen but when I try running it, it comes up with an error saying that
> a collection node above needs to be ticked, but I am not sure which
> node to tick – can you advise me please.
>
Which is why it has never taken off. There is the MIQUEST editor 4.2 or some such which shuld be freely available. I have it unloaded on my machine as I was told it was so full of errors that it crashed peoples PCs! SO I write them directly.
John
-----Original Message----- From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com]On Behalf Of bartsmissaert Sent: 13 February 2006 15:46 To: ExcelReportingAddin@yahoogroups.com Subject: [ExcelReportingAddin] Re: MIQUEST tables
Wil have a look into it. Is there any easy GUI - type interface available to write/edit Miquest queries?
Bart
--- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@...> wrote: > > > Bart > Just to remind you if you do point your add-in at the MIQUEST tables they > have to be refreshedI I believe this can be scheduled. They are an extract > of the main DB and not automatically refreshed. > Cheers > John >
John,
Thanks for that information.
I just got the Miquest editor after requesting it from the website.
I think it is 4.2 and I had in mind to install it today.
Maybe give that a miss then.
It would be a nice if it were possible to set up a Miquest query
from my add-in interface. It probably is too complex and I don't
know anything about Miquest queries. I have got the documentation
though (the 6 or so Word .doc files) and will have a look if there
is any chance of that.
Bart
--- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@...>
wrote:
>
> Simple Answer NO.
> Which is why it has never taken off. There is the MIQUEST editor 4.2
or some
> such which shuld be freely available. I have it unloaded on my
machine as I
> was told it was so full of errors that it crashed peoples PCs! SO I
write
> them directly.
> John
> -----Original Message-----
> From: ExcelReportingAddin@yahoogroups.com
> [mailto:ExcelReportingAddin@yahoogroups.com]On Behalf Of bartsmissaert
> Sent: 13 February 2006 15:46
> To: ExcelReportingAddin@yahoogroups.com
> Subject: [ExcelReportingAddin] Re: MIQUEST tables
>
>
> Wil have a look into it.
> Is there any easy GUI - type interface available to
> write/edit Miquest queries?
>
> Bart
>
> --- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@>
> wrote:
> >
> >
> > Bart
> > Just to remind you if you do point your add-in at the MIQUEST
> tables they
> > have to be refreshedI I believe this can be scheduled. They are an
> extract
> > of the main DB and not automatically refreshed.
> > Cheers
> > John
> >
>
>
>
>
>
>
> SPONSORED LINKS Email software program Medical software program
> Maintenance program software
> Backup software program Cad software program Wedding program
> software
>
>
>
----------------------------------------------------------------------------
> --
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "ExcelReportingAddin" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> ExcelReportingAddin-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
----------------------------------------------------------------------------
> --
>
Actually on the disk I got it says Miquest Enquirer 4.5
Should I get a Miquest editor as well?
Bart
-----Original Message-----
From: ExcelReportingAddin@yahoogroups.com
[mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of bartsmissaert
Sent: 14 February 2006 10:28
To: ExcelReportingAddin@yahoogroups.com
Subject: [ExcelReportingAddin] Re: MIQUEST tables
John,
Thanks for that information.
I just got the Miquest editor after requesting it from the website.
I think it is 4.2 and I had in mind to install it today.
Maybe give that a miss then.
It would be a nice if it were possible to set up a Miquest query
from my add-in interface. It probably is too complex and I don't
know anything about Miquest queries. I have got the documentation
though (the 6 or so Word .doc files) and will have a look if there
is any chance of that.
Bart
--- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@...>
wrote:
>
> Simple Answer NO.
> Which is why it has never taken off. There is the MIQUEST editor 4.2
or some
> such which shuld be freely available. I have it unloaded on my
machine as I
> was told it was so full of errors that it crashed peoples PCs! SO I
write
> them directly.
> John
> -----Original Message-----
> From: ExcelReportingAddin@yahoogroups.com
> [mailto:ExcelReportingAddin@yahoogroups.com]On Behalf Of bartsmissaert
> Sent: 13 February 2006 15:46
> To: ExcelReportingAddin@yahoogroups.com
> Subject: [ExcelReportingAddin] Re: MIQUEST tables
>
>
> Wil have a look into it.
> Is there any easy GUI - type interface available to
> write/edit Miquest queries?
>
> Bart
>
> --- In ExcelReportingAddin@yahoogroups.com, "John Robinson" <john@>
> wrote:
> >
> >
> > Bart
> > Just to remind you if you do point your add-in at the MIQUEST
> tables they
> > have to be refreshedI I believe this can be scheduled. They are an
> extract
> > of the main DB and not automatically refreshed.
> > Cheers
> > John
> >
>
>
>
>
>
>
> SPONSORED LINKS Email software program Medical software program
> Maintenance program software
> Backup software program Cad software program Wedding program
> software
>
>
>
----------------------------------------------------------------------------
> --
> YAHOO! GROUPS LINKS
>
> a.. Visit your group "ExcelReportingAddin" on the web.
>
> b.. To unsubscribe from this group, send an email to:
> ExcelReportingAddin-unsubscribe@yahoogroups.com
>
> c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service.
>
>
>
----------------------------------------------------------------------------
> --
>
Yahoo! Groups Links