Search results for query: *

Hi tuba007, thanks for the reply, but if i use ARCUSTOMER20detail.Insert() it throws out an error saying that the record already exists.

Hi There, I've updated my customers on AccPac with 4 optional fields but now i need to add values to 1 of these options. I need my code to recognize the option i want to add my value to and insert the value under this option. I cant seem to get my code to locate the option that i want to add the...

Hi Ettienne, thanks for the reply. I have composed the views but i still get the same error. i've composed the views like this : Public Sub OpenCustomer() 'Open Customers View... ARCUSTOMER1header = mDBLinkCmpRW.OpenView("AR0024") ARCUSTOMER1headerFields =...

Hi there, I need to update the optional fileds for existing customers on AccPac. The optional fields have already been defined on AccPac and if I insert data manually, it accepts it, but I'm struggling to get my code to do the same. The Error that I get is "Invalid Input. Optional field cannot...

Hi There, the System.DateTime-1 doesnt seem to work, but i've tried: session.Open("", "", "", "2010 - 6 - 30", 0) and this has worked perfectly. Thank for the reply, its much appreciated...

Hi Guys, I need to insert GL transactions into AccPac but for yesterdays date and period. Since the month has changed (01/07/2010) AccPac by default displays the new months date and period. If i physically change the session date to 30/06/2010 when i open up AccPac, the default date in the GL...

Hi tuba2007, 'description' didnt work but 'message' did. this is how the line of code looks now : MsgBox(session.Errors.Item(lIndex).Message) Many thanks to you and ettienne for the help :-) Take care & God bless...

Thanks ettienne, it seems to be better now, but i still get an error message on line : MsgBox(session.Errors.Item(lIndex)) saying : Argument 'Prompt' cannot be converted to type 'String'. How do i get this to dispaly as string? Below is the code... ACCPACErrorHandler: Dim lCount As...

Hi Tuba2007, I have data in my dataset, that once i try to insert it via my program to AccPac, it will cause AccPac to give me an error. If there is no error handling in my code it would fall over on the line ...

I've got the code to work but it still not doing what i require it to do. If i try to manually insert an invoice into AccPac for a customer that hasnt yet been added to AccPac i get an error saying "Invalid Customer". When i try to add this same invoice via my code into AccPac I want that...

Hi Ettiene, thanks for the reply. I've recorded a macro in AccPac and see that it calls up On Error GoTo ACCPACErrorHandler and then after it runs through some code it use the code : ACCPACErrorHandler: Dim lCount As Long Dim lIndex As Long If Errors Is Nothing Then MsgBox...

Hi There, I'm currently inserting customers, invoices, credits into AccPac and whenever there are any problems with the data or if AccPac throws out an error messages, my code displays an generic error from my try catch statement: Try... Catch SqlExceptionErr As SystemException...

Hi there, I'm currently inserting invoices from a staging table into accpac. The problem i have is that i need to check that if my custnumber field AND docnumber fields in my current datarow is the same as the record i've previously inserted. If it is, i must add just the detail to the previous...

Hi Tuba2007, as i mentioned earlier my code seems to be inserting invoices correctly, but the problem i have now is that when I have 2 or more invoices on my staging table with the same invoice number and same customer number but with different product lines i get an error on my insert again...

Hi tuba2007, thanks a million for this code and advise, my app is now adding invoices to accpac successfully...

The Views are composed in a function just before the button insert code. It looks like this : Public Sub OpenInvoice() ARINVOICE1batch = mDBLinkCmpRW.OpenView("AR0031") ARINVOICE1batchFields = ARINVOICE1batch.Fields ARINVOICE1header = mDBLinkCmpRW.OpenView("AR0032")...

Hi there, I need to insert invoices from a staging table into ACCPAC but seem to be getting the error : "Error HRESULT E_FAIL has been returned from a call to a COM component" on the insert statement. I've coded my app similarly to way the the VBA macro was created. Please can someone help me...

Hi there, I'm trying to update Accpac view from my VB .NET code but seem to be getting an error : Error HRESULT E_FAIL has been returned from a call to a COM component. This error appears on the ARCUSTOMER51header.Update() statement. I'm not sure what i'm doing wrong here. Please help. Below is...