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

It's working now. Thanks!

Thanks for your inputs! Makes sense because on another project, I manually compose the views and it's working perfectly.

Hi DjangMan, I'm using the Accpac data source control for OEORDH, OEORDD and OEORDDO with Auto Compose set to true. Do I have to add all the data sources linked to those 3? Thanks.

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

Thanks DjangMan! That worked.

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

Thanks ettienne.

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

Thanks ettienne for the confirmation.

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.

Agreed, exactly my point.

Hi tuba, Client can't rename the DSN used for their MIS reports because they have to modify and rebuild all their reports to use a new DSN. And they have tons so they opted to create a new DSN for Accpac and just setup the DSN on each workstation that's using Accpac.

Found a solution for this: modified all Accpac company profiles in Database Setup to use Sage300 DSN instead of the server name. Found out that Accpac automatically creates the DSN <servername>32 if company profile is set to server name in database setup.

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

Thanks DjangMan, it worked! :)

I can't, keeps getting above error when trying to edit from File Explorer even when Accpac desktop is open.