Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: muhaidib
  • Order by date
  1. muhaidib

    Use of LIKE operator

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

    Use of LIKE operator

    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 '" & "*" &...
  3. muhaidib

    Use of LIKE operator

    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 '" & "%" &...
  4. muhaidib

    Count of execution of program

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

    Count of program activation.

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

    Using 3 parameters

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

    Using 3 parameters

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

    Bank Reconciliation

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

    Bank Reconciliation

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

    Comparing 2 cursors in a stored procedure

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

    Comparing 2 cursors in a stored procedure

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

    Comparing 2 cursors in a stored procedure

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

    Comparing 2 cursors in a stored procedure

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

    Comparing 2 cursors in a stored procedure

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

    Crystal Report datasource

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

    Comparing 2 cursors in a stored procedure

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

    How to determine First Record of a group

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

    How to determine First Record of a group

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

    Including .ocx file

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

    Cashbook reconcilation templates

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

Part and Inventory Search

Back
Top