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!

  • Congratulations bkrike 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: Salmano
  • Content: Threads
  • Order by date
  1. Salmano

    Report Group

    Hi. I have a report in foxpro 2.6a with this sections: - header - group (start) - detail - group (end) - footer My problem is that I have a 200 length field in the "group(start)" section and I do not have the "Stretch vertically" option for that field, as I have in "detail" section, so on the...
  2. Salmano

    TreeView Control

    Hi ! I use VFP6 and TreeViewControl 6. Do you know how could I disable the tooltips that appear when the text is larger than the tree width ? Thank you.
  3. Salmano

    PCL Codes

    Hello ! Does anyone know where could I find an PCL codes archive ? Thank you.
  4. Salmano

    SQL expression too complex

    Hello all ! I get this error when I run the following sql: SET ANSI ON Select distinct ff.firma as Firma, iif(isnull(ob.obco), ' ', ob.obco) as ObAct from rec\firma as ff left join br_firma as bf on str(year(ff.dinrf), 4) + str(ff.nrinrf, 6) = bf.codu left join br_obiect as ob on bf.codu =...
  5. Salmano

    Treeview control

    Hi all ! I have a treeview control with checkboxes for each node. When I check a node, vfp60 does not select the entire row, the selected row remains the last row that user selected. Is it possible that when the user checks a node, to autoselect the entire row ? Thank you. Salmano.
  6. Salmano

    Treeview search

    Hi all ! I fill a treeview control with some values. The user searches in the .text for some value. I want to select the found node, expanding the parent nodes. The code looks like this: with thisform.treeview for i = .SelectedItem.index to .nodes.count node_text =...
  7. Salmano

    Data in grid

    Hi ! In a form I have a grid with data based on sql statement and a button that launches another form. When I click the button, the form launches ok, but when I close it, the data in the grid is lost. Does anyone know how could I keep the data in the grid ? Thank you. Salmano.
  8. Salmano

    Menu incomplete

    Hello all ! I have a big (!) problem with a project in VFP5: I have a top-level form menu and a top-level form and also a main program to start the form. In the beginning, the menu had 2 pads each of 3 bars; I runned the program, and it looked ok; I extended the menu to 4 pads, I saved it, I...
  9. Salmano

    Grid to Report

    Hello ! In Vfp50, I have a grid control populated by a sql statement (cursor) changed by users' various selections; there could by 1 up to 19 fields in the cursor, at user decision. The problem is that I want to programmatically generate a simple form (that look as a browse for example) from the...
  10. Salmano

    Grid on SQL Statement

    Hello ! I want my grid to be populated by a SQL statement; the code looks like this: selectul = "Select firma, local, st, nr, bloc from firma into cursor cursorul" with thisform.tabprinc.pag_rezult.grd_rezult .recordsourcetype = 4 && SQL Statement .recordsource = selectul endwith The...
  11. Salmano

    Connect to FP 2.6 DBF in Vb

    Hello ! I have the code: Dim db As Database Dim rs As Recordset Dim sql As String sql = "Select clasa, denumirea from ram" Set db = OpenDatabase("D:\SALV\NOMEN\", dbDriverPrompt, True, "FoxPro 2.6; DATABASE=D:\SALV\NOMEN\RAM.DBF") Set rs = db.OpenRecordset(sql...
  12. Salmano

    Update table join linkedtable

    I have an update query like this: UPDATE tmp_final LEFT JOIN INSTIT ON tmp_final.COD_INSTIT = INSTIT.COD_INSTIT SET tmp_final.DEN_SCURTA = INSTIT.DEN_SCURTA; tmp_final is a table created in Access and INSTIT is a linked table (.DBF) When I run this query, Access asks me "You won't be...
  13. Salmano

    Access to Word using vba

    Hi ! In Access (97), I have a linked table (DBF)... In Word (97), using VB code, I open the access database and make a record set from the linked table. The data resulting is included in a combo box (in a form) but, here is the problem, the recordcount of the record set is not the record count...

Part and Inventory Search

Back
Top