Search results

  1. W

    Excel CheckBox help

    Hello everyone, I was looking for some help with programaticaly changing the CheckBox's in an excel program. I've looked at the com viewer for help, but couldn't quite understand it. Here is what I've tried: DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chWorkBook AS...
  2. W

    Fill-in from view-as-text to native?

    Thanks for the advice, but what I am looking for is a method of changing the labels of a fill-in field. What I was doing was using two fill-in fields, one for the label and one for the actual fill-in. I want to be able to change the label of a fill-in and store the new "Label" in a database...
  3. W

    Fill-in from view-as-text to native?

    Hello everyone, I need some help changing the object properties for a fill-in. What I have is a fill-in where the view-as-text and read only are checked. At run time the field looks like a label. What I want to do is at run time, right click on the fill-in and change the properties back to...
  4. W

    Tab Strip - OCX

    Ok that helped... Thank you. Next... How do I snap objects each tab of the OCX where if I click on the first tab it sees one set of objects and the next tab sees a different set of objects? Should I use frames to hide and view when the ocx returns which tab it's on or is there a better...
  5. W

    Tab Strip - OCX

    I need some help using OCX tab strip in a progress window. I have never used OCX before and would like to know where to find the object names to use with it. I am using Microsoft TabStrip Control, Version 6.0 does anyone have examples on how to change tabs and add objects to each tab? Any...
  6. W

    Excel text box & lines

    I am trying to interact with excel and need some help getting some code to work correctly. I can create the text box, but I am unable to enter any text to it. Also I can create a line, but can not create the arrow on the end. Does anyone have any idea how the code works? Example: DEFINE...
  7. W

    Excel PrintOut() Help

    I figured it out...... If anyone was intrested here was the fix: DEFINE VARIABLE ch-Excel AS COM-HANDLE. DEFINE VARIABLE ch-Worksheet AS COM-HANDLE. CREATE "Excel.Application" ch-Excel NO-ERROR. ch-Excel:WorkBooks:OPEN ("P:\P2000SQL\Forms\WARRANTY CLAIM FORM.xls"). ch-WorkSheet =...
  8. W

    Excel PrintOut() Help

    I have look at the examples in other posts, but still don't quite understand what I'm doing wrong. Can someone look at this and tell me what I'm doing wrong? DEFINE VARIABLE ch-Excel AS COM-HANDLE. DEFINE VARIABLE ch-Workbook AS COM-HANDLE. DEFINE VARIABLE ch-Worksheet AS...
  9. W

    extracting data from Progress

    Depending on what you are trying to do, this may help you get strated: define stream coitem-strem. output stream coitem-strem to "c:\temp\exp-coitem.csv". export stream coitem-strem delimiter "," "CO Number" "CO Line" "Stat" "Item" "Item...
  10. W

    ODBC Auto login

    I am having problems with connecting to a SQL Database. When I setup the ODBC connection where I specified to use the SQL Server authentication for Login and Password on a client workstation. I entered the user name and password to use for this connection and when I tested the connection...
  11. W

    problems to print boxes

    Here is an example of what you can do with pclbox.p. Make sure you compile pclbox.p before you run this example. DEFINE STREAM rpt. DEFINE VARIABLE t-pcl-cmd AS CHARACTER. OUTPUT STREAM rpt TO PRINTER. PUT STREAM rpt CONTROL "~033&a90P". ASSIGN t-pcl-cmd = ""...
  12. W

    problems to print boxes

    See if this will help you, def input parameter vert-pos as integer. def input parameter hor-pos as integer. def input parameter vert-size as integer. def input parameter hor-size as integer. def input parameter shade-lvl as integer. def input...
  13. W

    Serial Port read

    Do you rally want to read directly from the serial port? Barcode scanning is really keyboard emulation. If you have a field for part number and someone scans the barcode, the wand will emulate the keyboard and put the information in the field and do an auto return. Unless there is some...
Top