Search results for query: *

This problem is sorted out as follws: wrong statement: rsUnReconCb.Open "SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '" & "*" & rs121Tag!cbtag1 & "*'" & " Or CBTag Like " & "'*" & rs121Tag!cbtag2 & "*' ) , AdoCon, adOpenDynamic, adLockOptimistic" correct statement...

Hi, I am getting error "The connection cannot be used to perform this operation. It is either closed or invalid in this context" due to LIKE OPERATOR while trying to open a recordset as follows: rsUnReconCb.Open "SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '" & "*" &...

Hi, I am getting error "The connection cannot be used to perform this operation. It is either closed or invalid in this context" due to LIKE OPERATOR while trying to open a recordset as follows: rsUnReconCb.Open "SELECT * From CBRECON WHERE CBReconciled = False AND ( CBTag Like '" & "%" &...

Is it programatically possible to extract info regarding count of different program execution throughout a day, and/or over a range of days? Any window API to support? I had placed this query in Desktop softwares forum but could not get answer.

Is it possible to extract info regarding count of different program execution throughout the day? Is it readily available in some registry?

Thanks a lot, lbass Your solution worked beautifully. Meanwhile I continued to work and succeded with following formula: If {?Area} = "ALL" then GroupName ({sum.Year1}) = {?Year} else if {sum.Area}={?Area} and {?Member} <> "ALL" then GroupName ({sum.Name})={?Member} else if {?Member} = "ALL"...

Hi Everybody, I have 3 groups in a crystal 8.5 report as YEAR, AREA, MEMBER. I have to display following results: 1. All the REGIONS with their MEMBERS for a given YEAR 2. All the MEMBERS for a given AREA for a given YEAR 3. Particular MEMBER for a given AREA for a given YEAR My following...

Thanks for reply. I did reconciled all the transaction before Jan09. But those are visible. I want to see transactions Jan09 onwards. Secondly is there .txt/.csv to .ofx converter available? as all the banks gives either .csv/ .txt or .xls format.

Using ACCPAC 5.5A with all upgrades MSSQL database. I want to use bank reconciliation from Bank module. 1. Before starting to work on data Jan09 onwards I want to mark all the data before 01Jan09 as reconciled. How to do that? 2. Secondly withdrawal tab is not showing any data for some of...

As you come across first match with reference to Date and Amount, the matched records should be dropped from further matching. Hence when the first record from BK ZAFD-00257,20090101,-500.000 and first records drom CB 912101-001,20090101,-500.000 should not be considered in next iteration...

Reference fields in the tables has no relevance to each other. Both the tables are sorted on Date and Amount. I want to start from table Bk. Take a record and match with records with CB. If match is found Mark/ Extract both the records else pickup second record from table BK and repeat the...

Thanks a lot. It did not give error. I need to run the query on following data Table BK BkRef,BkDT,BkAmt ZAFD-00257,20090101,-500.000 ZAFD-00258,20090101,-500.000 ZAFD-00259,20090101,-500.000 ZAFD-00260,20090101,-500.000 ZAFD-00261,20090101,-500.000 ZAFD-00262,20090101,-500.000 Table CB...

Thanks for reply. Somehow I am getting error at "where" Individual SELECT statements lists desired records. but Join statemet generates error.

Cursors OpenBkCrsr and OpenCBCrsr contains as follows: OpenBkCrsr: Select BkRef, BkDT, BkAmt from BK where bkdt >= '20090101' and bkdt <= '20090131' OpenCBCrsr: Select CbRef, CbDT, CbAmt from CB where cbDt >= '20090101' and cbDt <= '20090131' These are like 2 recordsets, ref fields has no...

Hi All, I have created a crystal report (version XI) based on a excel sheet and opening through VB6. It is linked to an excel file in application path. I want to change the datasource file path during runtime. I have defined Private Rep As CRAXDRT.Report I could not think of a...

Hi All, I have created 2 cursors in a 2 stored procedures. I want to search records of 2nd cursor with each record of 1st cursor. Somehow I am stuck with structuring the procedure. Can someone help me with it? My current procedure looks as follows: DECLARE @CrsrBankVar CURSOR DECLARE...

I sorted out the problem as under: (courtsey Cthang from it.toolbox) To do this goto to your field explorer and right click and select new Running Total. Give it a name (RecNumber) and then select the field to summarize (in my case part-payments) and select Count from the type of summary. You...

I am using Crystal 8.5. I have generated a report for Invoice and Payments. The report is grouped on Invoice. Thers are more than one payments (part-payments) against an invoice. My report detail columns are PayDate, PayNo, PayAmt, AmtPaidUpdate. I am calulating "Amt paid sofar" i.e...

One of my colleague (resigned) whoes project includes two files as xx_ocx.lib and xx_ocx.exp gives error on opening the project as "Line 13: Class xx_OCX.RYS of control RYS was not a loaded control class". The instruction in the project is as - "there is one .ocx file first To include it" I...

I need help on How to create templates in Peresoft Cashbook RecXpress templates. I scanned its help file with no success. Thanks in anticipation