Fingers crossed - let you know over w/e or Mon ... From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of...
Yes, hope it works. McAfee considers the following methods as possible viral actions: 1. VBComponents.Add 2. VBComponents.Remove 3. VBComponents.Import 4....
Hi Bart When I run some reports, i only get the summary sheet - the data sheet (with patient details) is missing. Any clues? Have I unwittingly selected an...
Hi Les, Is this with the new SQLite method? I think this could happen if there was no change in the report setup compared to the previous search and I will...
Hi Les, Have tried this and I can reproduce the same, so run report, run same report and no new main table sheet. I am not sure it is a problem as a new main...
Thanks Bart I actually closed excel and started again and it worked. I mentioned it because it has happened a few times, but not able to give any indication...
Hi Les, Closing Excel will force a new search, so will add the big table. As far as I can see the big table is only omitted if you run a search and directly...
Does that mean that if the big table is not produced the first time, I'm best to close excel and start again rather than running the report again? Les ... -- ...
If the big table is not produced when you run the report first time then that is a bug that needs fixing. I haven' seen that though. You don't have to close...
As mentioned by Les T when running a search when there was no change in any of the nodes could in certain situations not produce the large table output. Maybe...
Three further fixes. With SQLite method the F, L, A radio buttons need to remain visible in the single patient report as they make a difference. Note that they...
Fixed a bug in the mailmerge (introduced recently) where xxxPatientxxxxx etc. wouldn't be replaced with the right text. Also made it now so that you can have...
Bart, I've changed my default setting in debugging to use SQLite method, but when I run a batch of reports it run in old mode and prompts me individually to...
In about a weeks time, I have been asked to show RepAid to our local user group. East Sussex Downs and Weald, Can any of you just let me know what sort of...
Paul, The way to do this is to set the run type for all the reports involved. This is done with a right-click in the report node description box. There is a...
Bear in mind that reports written with old method in mind may not work OK if there are macro's involved as the output fields will be different. Bart...
You can set to always run SQLite method and it will work with reports run with the reports scheduler. To set to run always with SQLite do: Options, Debugging,...
Hi Bart Some progress - it seems like it is nearly going to work but then stops at the following OK box. This is new & is not normally what I see. Something ...
Hi Patrick, Looks we are making progress. Could you have a look if code has been taken out? This is the ThisWorkbook modole (in Microsoft Excel objects) of ...
Sorry Bart - how do I do this bit? How would I know? ... From: ExcelReportingAddin@yahoogroups.com [mailto:ExcelReportingAddin@yahoogroups.com] On Behalf Of ...
Get in the VBE by doing Alt + F11 in Excel then in the VBE press Ctrl + R, then open the project VBAProjectMainAddin (on the left) look in Microsoft Excel...
Patrick, I have figured out now where that error message came from. It is from the external dll CustomMsgbox.dll Will have a better look later, but this looks...
Some minor fixes. Some cosmetic changes to the 2 websites. In the main website the Stats link now works. Still on course to get in the Guinness book of records...
One further fix to do with the custom messagebox. This had a serious bug in that it could go off the screen at the bottom plus also the dialog text was...