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
21.55   Message List  
Reply | Forward Message #3683 of 3839 |
Re: 21.55

--- In ExcelReportingAddin@yahoogroups.com, "bartsmissaert" <bartsmissaert@...>
wrote:
>
> When adding entries and having comma separated Read codes in the Read code box
there would be a dialog saying that this is slow and advising to switch to
SQLite method. This is because by default adding entries was run with the old
method. This has now been altered and this will now always run with the SQLite
method.
> Old method will soon be thrown out as it is not maintained and it will make
the code smaller and simpler.
>
> One .rcf file (ApptsStatsLimitUsersExtraWHERE.rcf) wouldn't run with Firebird
due a bit of SQL it didn't like and have changed this now.
>
> Version 21.55
>
> Bart
>

Hi Bart
thanks, the install error was caused by the Word add-in, now rectified.
The RCF with v 21.55 now works and picks up entries. However, there is a slight
problem

When putting the user id's in the description box it seems to work fine until I
include a longish number i.e. (these are all valid user id's on our system)

11,13,14 works OK

11,13,14,53083455 gets Overflow error

Any ideas?
regards
Mike




Fri Jul 10, 2009 8:18 am

mikehur_2005
Offline Offline
Send Email Send Email

Forward
Message #3683 of 3839 |
Expand Messages Author Sort by Date

When adding entries and having comma separated Read codes in the Read code box there would be a dialog saying that this is slow and advising to switch to...
bartsmissaert
Offline Send Email
Jul 9, 2009
11:12 pm

... Hi Bart thanks, the install error was caused by the Word add-in, now rectified. The RCF with v 21.55 now works and picks up entries. However, there is a...
mikehur_2005
Offline Send Email
Jul 10, 2009
8:18 am

Hi Mike, I think this will solve your problem: Open that .rcf file again Go to code line with number 170 and change the Clng to Val Save the file. Close Excel...
bartsmissaert@...
bartsmissaert
Offline Send Email
Jul 10, 2009
9:00 am

Have tested this now and with that little alteration it runs fine, even with the comma separated users as you described. One other thing you may want to add to...
bartsmissaert@...
bartsmissaert
Offline Send Email
Jul 10, 2009
10:40 am

Yes that seems to work fine now. Thanks for all the help, much appreciated. regards Mike...
mikehur_2005
Offline Send Email
Jul 10, 2009
12:28 pm
Advanced

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