Recent content by jforero

Hi. This for a standalone computer using Windows XP. How can I add a program to the list of the programs that run when a user login using the Microsoft Management Control? I do not want to put it in the startup folder or the login script. I know that using the MMC you can do it for the...

Crystal Reports XI Pervasive.SQL V8 (SP3) Windows XP Hi. I am getting the error: "Unknown Database Connector Error" when I try to do the preview in the design mode of Crystal Reports. Problem description: I have two tables in a pervasive database. One table is the details of an order...

Hi, My workstation is restarting automatically when I try to run any .exe file. After I log on I receive the following error message: Date: "date" Time: "time" Type: Error User: N/A Computer: MyComputer Source: System Error Category: (102) Event ID: 1003 Description: Error code 1000007f...

Accpac 5.1 (S/M, A/P, A/R G/L) Pervasive V8 Windows 2000 Hi, I have damaged 80 checks by accident. My checks have sequence number preprinted. Now I want to record these 80 checks as avoid in the system. I know that ACCPAC let me put the next check number (skipping the 80 ones) with no problem...

Hi, The CPU usage goes up 100%. This is the scenario: We have ACCPAC program running its database in a server with Pervasive V8. We have some VBA customized programs that use ADO to connect to that database as following: Set oCon = New ADODB.Connection oCon.ConnectionString =...

Mirthel, thanks for answering. I am with GHG. This is the scenario: We have ACCPAC program running its database in a server with Pervasive V8. We have some VBA customized programs that use ADO to connect to that database as following: Set oCon = New ADODB.Connection...

Hi, I have some information in a .csv file. Can I open that file using ADO to manipulate this information? I want to work with the recordset and sort the information in any way to create reports. How would be the code to open a .csv file? Any help appreciated. Thanks, Jose.

Hi, I want to create a table or file to save some information in it and then read this file using ADO object. Is there any way to do that from Visual Basic? How would be the code to create the file, save information on it and read the file? How the format of the file can be? (.csv, .txt or...

Hi, is there any way to change the original value of a field in a SQL statement. Say I have a REFERENCE field with 2 values A and B. Can I change the output value from A to 1 and B to 2? The statement would be something like: SELECT NAME, REFERENCE CHANGE(A TO 1 AND B TO 2) FROM PRODUCT It...

Accpac 5.1 (S/M, A/P, A/R G/L) Pervasive V8 Windows 2000 Hi, wrote a VBA program to change information in APOBL and APOBS. This program works fine. My problem is that the program works fine only when I log in as ADMIN user. If I login with another user I get this error message...

ACCPAC 5.1 Pervasive V8 Windows 2000 Hi, is there any program in the market to change A/P invoice dates similar to the ones that change the A/R customer IDs or G/L accounts? If such program does exist and you can create a program to do that, what are the tables and fields in A/P that you have...

Accpac 5.1 SM-SP3 Pervasive V8 Excel 2002-SP2 Hi, I found a problem with the formulas FRAMT("NETP") and FRAMT("NETP.L1") in my P&L financial report. They work fine for any period from 1 to 11. When I do period 12, they accumulate amounts from period 12 and period ADJ...