Search results for query: *

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?

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

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

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

What is difference between Database dump and database Copy? I have to create 4 companies. Only difference in these companies is Name of company. Hence I created the first one and activated all the required modules and updated with all the setup information. I feel that I have two options to...

Is it possible to export the POSTED AP or AR batches and import them as OPEN batches? What changes in exported .xls are required to show the status as OPEN? Due to some problem I have to restore couple of days old data and hence this exercise.

I am facing a strange problem. A simple code like: msgbox "The process is over" in procedure does not yield results during runtime in one computer but works well in another computer. The statement gives result in procedure of command1_click() in both the computers. Both the computers are with OS...

I have two exactly same databases meant for 2 regions. I have designed a report which can work for both. But I had to make two copies of the report with two DSNs to cater to two databases. My question is: How can I use only one copy of report with both databases? During run time the report...

To create backup thru VB6 I am using following code and facing problem. Dim BACKUP As New SQLDMO.Backup2 Dim SERVER As New SQLDMO.SQLServer2 Private Sub Command3_Click() On Error Resume Next Dim oDevice As New SQLDMO.BackupDevice With oDevice .Type = SQLDMODevice_DiskDump .Name =...

I have created a sub report based on stored procedure and linked to the parent report with relevant fields. But it is not appearing when the parent report is executed. Only the report header is visible. I have not suppresed or hidden any section. Sub report preview on its own appearing well...

accpac advantage series 5.2 I have created an VB project in which I have included reference of A4WComex.dll. The compiled exe gives desired results on computer where ACCPAC Advantage Series 5.2 is installed. It gives error "Activex component cant create object" on computer where ACCPAC is not...

thread631-1458025 Dear Bluejay07, I am trying to use your code to access the view finder. *************************************************** Dim oFind As AccpacFinder.ViewFinder Set oFind = New AccpacFinder.ViewFinder oFind.Session = cmSess oFind.DisplayName = CSCOMPANY.Name oFind.ViewID =...

Dear all, I am using Advantage Series v5.2. How can I avoid display income statement for department with zero balance?

I have created following SQL view for the sake of report. I have made use of 2 case statements for fields dbo.ICSHIPD.SHIPQTY and dbo.ICSHIPD.EXPRICEHM. SQL Enterprise manager saved the view with first case statement but when I add second case statement it flashes the message as "View definition...