Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SMI168
  • Content: Threads
  • Order by date
  1. SMI168

    Updating Optional Fields With Values

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

    Optional Fields update

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

    log onto AccPac with previous days date via VB .NET code

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

    Passing the actual accpac error message to display in my program

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

    Browsing 2 different Fields in SQL using VB .NET to update Accpac

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

    AR Invoice insert from staging table to ACCPAC

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

    Updating Accpac views in VB .NET

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

Part and Inventory Search

Back
Top