Search results for query: *

Hello, Is it possible to sign out users through code? Can someone please share if there's any? Thanks in advance!

Hi, What may cause the .Fetch to not to move to the next record in the view? ds.Init ds.Browse "", True Do While ds.Fetch Debug.Print ds.Fields("ORDUNIQ").Value Loop The ORDUNIQ value stays the same on the next iteration. Please help. Thanks in advance.

Hello again, I'm trying to insert a lot number allocation on an order detail but I'm getting this error. Can someone please point out to me what I'm doing wrong? Thanks! Private Sub adsOEORDDL_OnRecordChanged(ByVal eReason As AccpacCOMAPI.tagEventReason, ByVal pField As...

Hi, I have this code where I want to insert an optional field on an order detail but it won't let me set OEORDD.ORDUNIQ when I try to retrieve the order detail record: adsOEORDH.Order = 0 adsOEORDH.Fields("ORDUNIQ").Value = adsXMBPICK.Fields("ORDUNIQ").Value If adsOEORDH.Read...

Hi, I'm trying to add a new line item for an existing order but I'm getting an "Operation not allowed" error on OEORDD.Insert() line. Can anyone please check my code? public string EditOrder(Order order, string orderID) { string result = ""; bool...

Hi, Is there a way to check programmatically if a module is active without using SQL queries? Thanks in advance!

Hi everyone, In an AccpacViewList, I noticed that if the fields were declared as primary keys in the table/view, they seem to be INEDITABLE even if you set them as editable in the custom property. Is there a way to make it editable? I tried to set them to editable in code but it won't work...

Hi, I'm trying to update the datasource location of a custom datapipe report but everytime I add the DLL from v63, Crystal report designer crashes. Anyone experienced this? Everything's normal with earlier Accpac versions. Thanks in advance.

Hi everyone! A client is having a problem connecting to SQL Server from Accpac v62. It's in conflict with their MIS reports connection. They have setup 2 System DSNs (C:\Windows\SysWOW64\odbcad32.exe), 1 for the MIS reports and 1 for Accpac. MIS and Accpac are connecting to 2 different SQL...

Hello all, I recently upgraded my work PC to Windows 10. However, when I try to edit a VBA macro, I'm getting the attached error. I have ran Windows update and regacc as admin but to no avail. I can run the macro in Sage desktop though. Any thoughts? Thanks in advance.

Hi, Anyone who has encountered a "Failed to export the report." error when trying to export to Excel from Preview from a terminal server? I created a custom FR report for a client that contains less than 10,400 lines when exported to Excel. Preview and export to Excel work fine when running the...

Hi, I'm using Sage 300 ERP 2014 PU3 and I have a VBA macro that prints a report that accepts a parameter longer than 256. Is there a fix for this? When I run the report in the designer it works fine. How is the Accpac Crystal report runtime different from that of the designer? Any help will be...

Hello, Anyone who had encountered and resolved this error on a Windows 10 machine? The VB.NET program works fine without problems on earlier Windows OS versions but not on Windows 10. System.FormatException: Invalid character in a Base-64 string. at System.Convert.FromBase64String(String...

Hello, What may be the reason why pay advice attachments were blank? I did a couple of test in my local workstation but could not recreate the issue. Is this something to do with the data? If so, what might that be? Thanks in advance!

Hello, I have a .NET program that prints OE Accpac reports based on an input CSV file. I noticed that the memory allocated by the program grows after printing the report and not released. How can I release the memory so that the program won't crash/stall when more and more CSV files are to be...

Hello again! Anyone who had an experience printing Accpac forms from a Windows service? I am able to print the forms from a windows form application but can't print it from the windows service. Connection between Windows service and Accpac was successfully established. Any thoughts? Below is my...

Hi, Anyone had experience opening an Accpac session from a Windows service. I created a windows service that monitors a folder for new CSV files. The service will read the file and prints either an Order Confirmation, Quote, Picking slip or Invoice depending on the document type indicated for...

Hi, Is there a way to print completed POs using the datapiped report (POPOR01.RPT)? Thanks in advance!

thread631-1420246 Hello! I am just new to Accpac and I'm trying to insert new customer optional field. I have checked threads related to this but I can't seem to make this work. Here is the code snippet. The code runs without errors but no records are inserted to ARCUSO in the database. Any...