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 dencom 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: joechan
  • Content: Threads
  • Order by date
  1. joechan

    Capturing Exception of oleobject operation

    Hi all, I need help on how to trap exceptions within the same procedure/function and display customed message when dealing with oleobject operation. Code (within button click() event) oleobject ole1 ole1 = create oleobject : : ole1.application.activeworkbook.worksheets.Add...
  2. joechan

    SQL Query

    Hi all, I got 2 tables : Account_Header and Account_Transaction with the following fields : Account_Header : ACCT_CODE, ACCT_NAME Account_Transaction : ACCT_CODE, TXN_AMT I want to obtain the a view of the each account with top 3 transactions like this: ACCT_CODE TXN1 TXN2 TXN3 001...
  3. joechan

    PB7 datawindow saveas function to Excel cannot exceed 255 characters

    Hi all, I tried to export data from a datawindow to Excel using SaveAs function and found that first 255 characters can be exported when the column size is over 255. I tried to split the columns and merge it using OLE automation but the performance greatly decreased. Any suggestion to solve...

Part and Inventory Search

Back
Top