Search results for query: *

Hi I have a Crystal Report v10 where in my detail line I am displaying many records based on the Itemcode and Itemdesc fields. Inside my Detail a/section expert/suppress/x-2/ I have this code: ({UXDETAIL.ItemDesc} = next({UXDETAIL.ItemDesc})) Everything works fine unless I have this senerio -...

Hi, I have a Crystal Report v10 report where i have two running totals (i.e. #Total1, #Total2) I need to divided these totals by each other within my @Sales formula located on the detail line: #Total1/#Total2 When i try diving them i get an error saying: A running total cannot refer to a...

Hi, I have a detail section which prints many duplicate records. I have a running total on the detail section to show how many duplicate records are printing. ie: linecount#: 1 IC Item Code 00112X25000023 2 IC Item Code 00112X25000023 3 IC Item...

Hi Everyone, I'm using Crystal Reports 10, and I have a range parameter set up with default values. This parameter is being used in my Record selection. The problem is if i dont select any of the values from this parameter selection (AR Salesperson Code) it wont allow me to enter other...

I need to create a formula in crystal reports with the following condition: select sum(quantity), itemnumber from uxdetail where fiscalyear = '2006' and fiscalperiod between 1 and 4 and itemnumber = '00112X25000023' group by itemnumber The quantity field is on the Detail line and the...

Hey Everyone, I have an application that was created in a Windows XP SP2 environment. My client didnt specify that she was using Windows 2000. Now that I have installed the program on her machine the program doesnt even open up. Could someone please let me know if this is a Windows 2000...

Is it possible to sum a formula within another formula in Crystal Reports 10??? Thanks.

Does anyone know how to load a csv file into a table with the Maintenance Load button in Pervasive v9. I keep getting this error: An error occurred during the access of the sequential file. Thanks.

Hi help? Error at Set dsDet Code: Dim WithEvents dsDet As ACCPACDSControl Dim strManfItem As String Dim strCompName As String Private Sub AccpacOE1100UICtrl1_OnUIAppOpened() MsgBox "Opened" Set dsDet = AccpacOE1100UICtrl1.UIDSControls("adsOEORDD") MsgBox "dsDet Set" strCompName =...

Hi Everyone, I am trying to connect to Microsoft Sql Server 2000 with in my Visual Basic 6 application, I cannot test it on my computer because I dont have sql server i have Pervasice. So I am testing out the program on the Virtual PC where my client has Microsoft SQL Server 2000, however my...

Hi Everyone, I have a function which is suppose to get the manufacturing item number under the specified item, but my fetch is always false, this is no brainer im sure, i just have little time to figure this out and im running out of ideas, here is my code: Sub Main(ByRef strManfItem As...

Hi Everyone, Is it possible to hack into a PO button on the PO Accpac application? If so let me know please, thanks a bunch. Regards, Irena

Hi Everyone, I need to pre-populate the first manufacturing item number from Accpac ERP v5.4 P/O. This is my code i'm just curious as to why this function never gets triggered? Could someone please help me understand this. Here is my code: Private WithEvents dsOEORDD As...

Is it possible to connect to an Accpac DLL through Crystal Reports version, because when i try to run my Crystal report which is connect to a A4WUDP.DLL it tells me the database DLL 'crdb_p2bpipe.dll' could not be loaded. I have tried registering the dll and it wont allow me says the...

Hi Everyone, I am creating a function that gets the Accpac User ID. I cant seem to get it work properly, I am very new to VBA Accpac programming so I'm not sure if its my code that wrong or something else because I dont get any errors: Here is my code, any help will be greatly appreaciated...

Hi All, I have a program GLAccounts which on button click is suppose to pull up another VB application - Notes.exe. I copied these programs over to my clients computer. The problem is I have an INI file for the configuration of the database and a path for where to pull the Notes.exe program...

Hi I have a visual basic program that i have created for my client on my machine which of course works wonderful. Now that i have copied the executable program on my client machine, it gives me the Runtime error 429 ActiveX object cannot be created. I have all the correct dlls on my clients...

Hi, I'm new to Accpac programming as well. I find it pretty basic and simple since its basic VBA programming with Accpac databases. I was recently creating an application with Accpac v5.3B. Everything was working fine until i switched the application to run as Accpac v5.4A. This is the code...