Recent content by muhaidib

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...