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

    Uneditable Form Field

    Hello... I have a Microsoft Word Document containing many form fields. It also contains a couple of Combo Boxes. I want the user to only be able to select the data in the Combo Boxes and not enter in anything else. I am able to lock the combo box so they can't enter in anything free-form...
  2. krindler

    OLE2 R1C1 Reference

    Thanks so much for your help...The statement I ended up using was: =IF(SUM(R[-7]C:R[-1]C), SUM(R[-7]C:R[-1]C), "") Everything seems to be working the way it should now!!
  3. krindler

    OLE2 R1C1 Reference

    Hello... I am using an R1C1 reference to determine the Totals of a few rows. However, if the total of the R1C1 reference comes to 0, I would like to display a Null value instead of the 0. Is this possible? My current statement is below... args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args...
  4. krindler

    Hide Column using OLE2

    Does anyone have any sample code of hiding a column using OLE2. I am using the following code, but it doesn't seem to be working... args := OLE2.CREATE_ARGLIST OLE2.ADD_ARG ( args, 'A:A' ); column:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Columns', args ); OLE2.DESTROY_ARGLIST ( args )...
  5. krindler

    Move Excel Spreadsheet Using OLE2

    Hello... Does anyone have any example OLE2 code that moves an Excel spreadsheet. I am trying to create a report that inserts a new spreadsheet for every new location. What is currently happening, is the new sheet is put in front of the old sheet, and I would like it to insert the sheet after...
  6. krindler

    Creating Matrix Report in Excel using OLE2

    Does anyone know if it is possible to create a Matrix Report in Excel, using OLE2 from Forms 6i? Any help you could offer me would me much appreciated. Thanks In Advance!!
  7. krindler

    OLE2/Windows XP Problem?

    Hello... I am using an OLE2 Package from Froms 6i to insert some data into Excel. Recently, my PC was upgraded from Windows 2000 to Windows XP and now for some reason my form is failing before it inserts the data into Excel. Does anyone know of any bugs with Windows XP when using OLE2? Your...
  8. krindler

    Using Relative References in a Range from OLE2

    Hello... Does anyone have any example code of using relative references in a range? Is it possible? The code I have been using various forms of is listed below, but it doesn't seem to work? args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args, 'RC:RC[23]' ); range := OLE2.GET_OBJ_PROPERTY (...
  9. krindler

    Excel Page Break using OLE2

    Hello... Could anyone help me out in adding an Excel Page Break, using OLE2? I am having some trouble doing this and would appreciate any help you could give me. Thanks In Advance...
  10. krindler

    Carriage Return using OLE2

    Hello... Does anyone have any sample code of putting a Carriage Return, in the Header of an Excel File, using OLE2? I have been playing around with this for a while and am having no luck. Your help is much appreciated...
  11. krindler

    R1C1 References using OLE2

    Thank You soooo much...I must be having one of those days!!
  12. krindler

    R1C1 References using OLE2

    Hello...Can anyone help me figure out why the following Formula reference does not work? It does not put anything into the cell... args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args, v_can_ctr + 7 ); OLE2.ADD_ARG ( args, 10 ); cell := OLE2.GET_OBJ_PROPERTY ( worksheet, 'Cells', args )...
  13. krindler

    OLE2 Loop Problem

    Never mind...I figured out what was causing my problem. I needed to take out the last OLE2.RELEASE_OBJ ( cell ); line and everything now works fine. Thanks Anyway!!
  14. krindler

    OLE2 Loop Problem

    Hello... I have the following code, and for some reason, the Loop will not end. Excel is made visible, but my 'Message 6' that I have marked (which I only receive one time), is the last message I never receive 'Message 7'. I have condensed my code as best I could....Can anyone help me to...
  15. krindler

    Attaching Document to Lotus Notes E-mail using OLE2

    Hello... I want to send an e-mail, with an attachment, from Forms using OLE2. I can get the e-mail to send fine (I have shown the code below), but am having trouble trying to figure out how to attach a document to the e-mail. Can anyone give me some help in adding an attachment to the code...
  16. krindler

    Variables in R1C1 Formulas - using OLE2

    Hello... I have a report that I would like to calculate the percentage of the total. I am listing Vendors that have a certain Classification, their dollar amount for a specific month, and would like to determine the % of the Grand Total for the classification, for each vendor. I was...
  17. krindler

    Subtotals and OLE2?

    Hello... Is it possible to create subtotals in Excel, using OLE2? If so, does anyone have any sample code? Thanks!!
  18. krindler

    Merge Cells using OLE2

    Hello... Does anyone have an example of how to Merge 2 cells together using OLE2? Thanks In Advance!!
  19. krindler

    Dynamic Record Group

    Hello... I am back again. Thanks for your help. I got the above to work in my form, but now I was hoping you could help me a little bit more. From here, I would like to take the vendor information in the record group and insert it into Excel. Do you have any sample code you could help me...
  20. krindler

    Dynamic Record Group

    Hello... Does anyone have any example code of populating a record group with the information selected by a checkbox? I have a form where a user will enter in a vendor's name. From there, another form will appear displaying the vendor id and vendor name of all vendors in our system that...

Part and Inventory Search

Back
Top