• Durban
  • South Africa

Collen's Friends

  • Stephen Coull
  • Nic Hanafey

Collen's Groups


Collen's Page

Latest Activity

Leo Demarce replied to Collen's discussion How to create a Windows basic task scheduler
"Hello, thank you for this excellent post. I was wondering if you could elaborate. In this part of your tutorial you show the arguments section. What I would like to do is pass through todays date as the date parameter. In this example shown below in…"
Mar 27, 2012
Collen replied to Albert's discussion Message Box in Excel
"Hi Albert   This an example from a search engine:   Sub Simplemacro()'show dialog boxDim nResult As LongnResult = MsgBox( _Prompt:="Really run this macro?", _Buttons:=vbYesNo)If nResult = vbNo ThenExit SubEnd IfEnd…"
Apr 13, 2011
Collen replied to Simon Davis's discussion Parameter date format
"Hi Simon   The date format is control  by the operating system regional & settings option and it what BI5.5 will inherit those settings. Once date format is reflect correctly, then inside Report you may specify @Date@ parameter and…"
Mar 25, 2011
Collen replied to Ken Gibson's discussion Error in Sage ACCPAC Intelligence
"Hi Ken  Please can you try performing the following the below steps to resolve this issue:  Check on the windows directory c:\Program Files\Common Files\BIComponents whether the DLL file exists If yes,  browse to…"
Mar 2, 2011
Collen replied to Jing Han's discussion Can a SMI Designer report be deployed to a client who does not own Designer
"Hi Jing Yes, the report can be deployed successfully; SMI Report Designer can be run out although the problem will come whereby when clicking on the BI Tools ribbon it will show “Genie not licensed” resulting in the report layout not…"
Feb 15, 2011
Collen replied to Jörg Reinecke's discussion Missing Resource : Unable to set the Interactive property of the Application class
"Hi Jorg   Please can you run the report in design mode then create &  link the template back and then re-ran the…"
Feb 3, 2011
Collen replied to Vincent Simelane's discussion SAI COM SERVER ERROR ON WINDOWS 7
"Hi Vincent   Please can you confirm the[instDir]\  SAI Component files installed by default successfully and the local user is part of Administrator group. Something else that could prevent the program from running is the Windows UAC…"
Jan 11, 2011
Collen replied to Jaqyc Niemandt's discussion Can you write BIC reports for Evolution without having it installed?
"Hi Jagyc   Does the machine have Alchemex stand alone (with Administrator licence) on it local?, if yes, then you can connect directly to the database via Administrator within Alchemex standalone and if not, then BIC needs to be…"
Jan 10, 2011
Stephen Coull and Collen are now friends
Dec 29, 2010
Collen replied to Alexander Toufexis's discussion HELP! evBICActiveX.clsBIC is either not installed or not registered.
"Hi Alex Please can you try to register .dll file and then Launch the Pastel ERP Application. How to register: > regsvr32 /u "C:\Program Files\Pastel Evolution\evbicactiveXe.dll" > regsvr32 "C:\Program Files\Pastel…"
Dec 6, 2010
Collen replied to Casey's discussion An error occurred while attempting to run the macro [PLPLUGA.B.TBSync2(Sheet1,MasterSubAccount,Lookup,Lookup_GL,LookupFormuae,StartRow)]. The error was [Overflow]
"Hi Casey Please can you try performing the couple method on the workbook, run the out the report in BIC, click on lookup worksheet, select from the start to end of the account to clear and then go into BIC select the option to create and link…"
Dec 2, 2010
Collen joined Ruth Gray's group
Nov 29, 2010
Collen replied to Leonard Fungai Chirongo's discussion Incorrect Syntax near keyword 'LEFT'
"Yes that it's correct the container & the expression syntax needs to be changed be changed simpler to the database engine the report needs to on. The report which you needs to change is it a standard report which is shipped with the ACCPAC…"
Nov 25, 2010
Collen replied to Kelly Hummel's discussion SAI DLL error
"Hi Kelly Please can you perform a Windows search to see if the file does exist on ACCPAC directory, the permission on folder has been granted administrative rights. if the a4wapi file does exist on the folder run ( regsvr32 /u /r "c:\ sage…"
Nov 24, 2010
Collen replied to Leonard Fungai Chirongo's discussion Incorrect Syntax near keyword 'LEFT'
"Hi Leonard The problem you are experiencing when running the report is related to pvsql vs ms sql syntax statement is different. An example will be PVSQL e.g. Select * from "tablename" and with MS SQL e.g. select * from tablename , you…"
Nov 24, 2010

Profile Information

Where did you hear about us?
Alchemex Site

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service