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

    Reload form to update msflexgrid???

    Hope someone can help me out. I have FORMA w/msflexgrid on it. person clicks on the grid. opens up a new formB on top of FORMA ,they do whatever on that form then click close. I unload formB, and FORMA shows up as it was behind formB. How can i get it to be where formB closes, FormA reloads so...
  2. vbmorton

    List Box - Check box feature

    Can someone give me some advice. i currently have. Private Sub load() Dim i As Integer lst.AddItem "1 " lst.AddItem "6 " lst.AddItem "7 " lst.AddItem "8 " lst.AddItem "9 " lst.Selected(0) = True End Sub I only want to allow the user to select one of the items, it defaults to item 1, but...
  3. vbmorton

    Stop msg's after closing excel

    Was wondering if anyone can point me in the right direction, using VB6 to open and close a spreadsheet in excel, after the close of the spread sheet a msg pops up.. "Do you want to update file.exl" is there a way to auto reply to this msg or for this msg not to come up??? Thanks VBMORTON
  4. vbmorton

    FSO - Delete Files

    Hi all. What I am trying to do is, Create a folder and enter documents into that folder. I am doing this. fso.CreateFolder (fldr & "\" & Trim$(rsT(2))) Sometimes this folder is already out there. so.. it goes into my error handling. then in my error handling: Select Case Err.Number...
  5. vbmorton

    Print Recordset

    Can someone help.. I like to print data from a recordset, i so far have this, but keep getting an error when i run it, saying invalid property. rsDrawList.Open strsql,g_Conn,adOpenDynamic,adLockOptimistic Printer.EndDoc Printer.PaperSize = 17 Printer.PaperBin = intTray5...
  6. vbmorton

    SQL -Distinct?

    Thought I would post to see if anyone had any ideas of how to do the following. i have this sql statment connecting to as400. Set rsNewTravelers = New Recordset strsql = "select dtdept, dtrsrc, dtjobr, dtseq#, dtpart from " & g_strDataBase & ".CURPX1, " & g_strDataBase & ".CJOBH...
  7. vbmorton

    Auto-Fill Combo Box?

    Does anyone know how to auto fill a combo box ie.. this is my ie list. brady brooks carter cunningham johns johnsen johnson in the combo box, id like to start typing a letter. like.. J auto fills the rest to the first johns name JO no change JOH no change JOHN...
  8. vbmorton

    MsFlexgrid -Searching for String within.

    Hi Everyone, I have a msFlexgrid, in which i am allowing users via a input field to type a value (ie.. new) and what i want it to do, is go into the msFlexgrid col(2) which is a miscellaneous description column so it could have many words in it, and based on the user inputs ie we, it to go thru...
  9. vbmorton

    Multiple SQL to Same RecordSet

    Have a question to see if this is possible or if there is another way to accomplish what i want to happen.using vb6/sql server2000 This is what i have so far. first it goes and get some users roles(dependent on what dept you selected from cbo box)in sql, gets the team members from that dept...
  10. vbmorton

    mshFlexgrid ? column headings

    can anyone tell me how i get the column headings from a grd that has 6 columns and multiple rows. I want the user to select anywhere on the grid, and then take what ever col he's on and resort the grid using that column that he selected showing him the heading of the grid in a seperate...
  11. vbmorton

    stored procedure/Identity field

    Was wonderin if anyone can help me, im trying to retrieve the identity value of a field x while doing an add to the table, in my vb6 code i call this stored procedure using a class module, how could i retrieve the value of my identity (field x) back, its not part of my add to the table its just...
  12. vbmorton

    get @@Identity value back

    Hi, was wondering if anyone can assist me and trying to get a value back from sqlserver2000. my connection is ADODB Dim strsql As String On Error GoTo Proc_error Dim rsTest As Recordset Set rsTest = New Recordset Dim strtest As String With g_clsConnections .Connect End With...
  13. vbmorton

    SENDKEYS

    I am hoping someone can help me out here.. on my form, going left-right.. I have listbox,cbobox,and textfield. what i want to happen is.. allow the user to only get to the other fields if the click on a valid option from list box. if i use sendkeys "{^}+{+}+{HOME}" what happens is.. it...
  14. vbmorton

    Memo in VB6??

    very new to vb6, hopefully someone can give me some great advice here, as Im looking at including in my form something like a Memo box where, the user can type in, a detailed description of project they wanting to do. not sure what the length will be but might be kinda big, should i use a text...
  15. vbmorton

    flexgrid, highlight row after update

    was wondering if anyone can assist me in solving this, first of all, is there away to select a row and it stay highlighted until another row gets selected?? other question is.. after the user updates that record and clicks update, is there away for after it comes back from doing the update on...
  16. vbmorton

    Fill 3 text fields when cell in flex grid clicked or dbl clicked

    Was wondering if someone can assist me, i have a flex grid, that has 3 text fields at bottom of grid, part no, part desc, and location. how do i get those fields to populate with my sql data that has filled the flex grid perfectly into 3 columns. I want to be able to select any cell in grid...
  17. vbmorton

    VB6 looking for help to load from SQL server

    Need help, new to vb, trying to find the code that will allow me to get info from SQL Server on start up, trying to populate a few fields in a small table to allow user to add,delete,update. pfernandez@mortonmetalcraft.com

Part and Inventory Search

Back
Top