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 Chriss Miller 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: *

  1. dichetdi

    Capture created PO number in code

    Yes, I was querying the header table but that's not the best way to get the PO Number when I have multiple users creating PO. That's why I was wondering if it's possible to capture the created PO number return when post.
  2. dichetdi

    Capture created PO number in code

    Hello, Does anybody knows how to get the PO number that just got created/inserted? I ran the recorded vba code and it ran with no errors, but how do I know what's the PO number? I would like to put up a message box to show the created PO number that just got inserted. Thank you.
  3. dichetdi

    AccpacSessionManager vs. AccpacSession confuse

    Hello, Can somebody explain to me and provide some snippet code on AccpacSessionManager vs. AccpacSession. I am a little bit confuse between the two in converting vba to .net. I know the AccpacSession uses: Session.Init("", "XY", "XY0001", "60A")...
  4. dichetdi

    Accpac session connection

    Ok, I figured it out. We actually passing in the accpac database id to the COM. Thanks tuba2007 again for my newbie questions. As you can see. I am really new at Accpac. Your help is greatly appreciated! Thanks.
  5. dichetdi

    Accpac session connection

    Yes, but if I recall correctly. Accpac uses DNS to log into SQL Server. My setup has multiple companies that have two DNS one DNS for each company. So when I pass in the my database name DSDAT. Which DNS will Accpac use to connect to SQL Server? Maybe I am not asking the right question. But my...
  6. dichetdi

    Accpac session connection

    Hello, Can someone please clear a few things up for me when we're converting vba to .NET on how to handle/log in Accpac? Here's the setup. Accpac is install on APP_SERVER1 and a backup APP_SERVER2, the data is on SQL_SERVER and back a on SQL_SERVER2, and 10 users are connected via RDP to...
  7. dichetdi

    Error HRESULT E_FAIL on creating PO

    Cool. First time converting VBA to anyting and from Accpac does not help either. I figured out the problem by postponing the update. Thank you for your help and input. Greatly appreciated.
  8. dichetdi

    Error HRESULT E_FAIL on creating PO

    Oh, that's cool. But from your experience, why would the recorded macro ran fine in Accpac but converted version in the same order error out because of the update before insert? Now I am not sure where and which insert to run first before the update. If I convert vba to VB6. I am guessing the...
  9. dichetdi

    Error HRESULT E_FAIL on creating PO

    Yes, that's how I started. I recorded a bunch of macros and study the what it does. After that I attempted to convert the macro to .NET. The recorded macro runs fine in Accpac for creating a PO in the same order. But converting the vba to VB in the exact order it gave me that error. So that's...
  10. dichetdi

    Error HRESULT E_FAIL on creating PO

    So are you saying I should do my inserts like line numbers, header first before I update? Also, does the order of the insert matters? POPOR1detail1.Insert() POPOR1header.Insert() POPOR1detail5.Update()
  11. dichetdi

    Error HRESULT E_FAIL on creating PO

    Hello all, Can somebody please point out what I am doing wrong with the below code. Why am I getting the error "Error HRESULT E_FAIL has been returned from a call to a COM component." when I hit that line "POPOR1detail5.Update()" when trying to create a PO in Accpac 6.0 POPOR1header.Order = 1...
  12. dichetdi

    .Net C# conversion

    Please ignore the question. I found my answer. It's in the way of calling the AccpacCOMAPI.
  13. dichetdi

    .Net C# conversion

    Hello all, I was ping with a task to convert some vba process to C#. I am fairly new to Accpac and how it works. I am on Accpac 6.0 and I've recorded a vba to create a PO. I've been reading this forum on learning how to convert vba to C# and I am stuck at these lines and hoping someone can help...

Part and Inventory Search

Back
Top