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 Chriss Miller 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: joeschoe
  • Order by date
  1. joeschoe

    Cant find MS CHART

    I have never used the MS CHART control and I need it urgently. I scanned my disk and the closest i found was MSCHART02.OCX in the system32 folder. I tried running regsvr32 "C:\windows\system32\MSCHRT20.OCX" to register the OCX and it replied "successfully loaded". The application based on the...
  2. joeschoe

    starting a long display at a specific row in MSHFLEXGRID

    Johnwm , You are right, I did not test properly. Thanks to both you and guitarzan for your help.
  3. joeschoe

    starting a long display at a specific row in MSHFLEXGRID

    guitarzan, Thanks for trying. Your suggestion wont work as the rows above the ones modified have to be visible too, by scrolling up or down.
  4. joeschoe

    starting a long display at a specific row in MSHFLEXGRID

    I allow user modifications in a long MSHFLEXGRID which affect the formatting of a group of adjacent cells. I then regenerate the grid display which can be many screens long. It would be useful to be able to have the changed cells at the top of the display. At present the user has to use the...
  5. joeschoe

    textheight from VB6 not recognized in vb.net

    You are correct, chrissie1. The program is only the first part of a larger system. I want to train new programmers to help me in the future development and they don't want to start learning vb6 when vb.net seems to be the vb of the near future.
  6. joeschoe

    textheight from VB6 not recognized in vb.net

    Techsmith: Thanks for your code. I have added your code to my system, but I still have a list of 100s of errors to clean up before I can know if the routines do what I need. Chrissie1: I am still using MSHflexgrid, there was so much to learn in the converting to vb.net that I changed as little...
  7. joeschoe

    textheight from VB6 not recognized in vb.net

    I am converting an application using mshflexgrid from vb6 to vb.net. I had used a routine to resize the row height. It originally had the text: 'Get the height of the text in the textbox HeightOfLine = frmGrid.TextHeight(frmGrid.Text1.Text) vb.net complains that textheight is not a valid...
  8. joeschoe

    MSHFLEXGRID RIGHT MOUSE FOCUS

    Nice logic vladk, I like the " >= " which caters for the stupid numbering of column and rows from 0.
  9. joeschoe

    MSHFLEXGRID RIGHT MOUSE FOCUS

    When right clicking in a cell, I require the cell to change background color. If the cell is already selected, the color change works well. If I right click on any other cell, the change still happens to the originally selected cell. If I use the left click, the cell selection changes to the...
  10. joeschoe

    extract data from SQL table

    I am developing in VB6 and using MS SQL 2000 as the database engine. My shipping SQL table has the following fields 1. ContainerReference 2. BoxSize 3. Product 4. BoxReference For the query I want to know how many of each Box-Size is scheduled for a specific container. Each box has a unique...
  11. joeschoe

    sql error not coming back to VB for handling

    David, thanks for your suggestion. I used to use a general error trap, but I found it not flexible enough for specific error handling. I often find I have to respond differently to the same error such as "file not found" depending on the usage of the file. I would be happy to discuss this in a...
  12. joeschoe

    sql error not coming back to VB for handling

    I have placed a constraint on a table to avoid inserting duplicate records. When I create a duplicate I get an unfriendly error message box complaining about the constraint violation. I would like to trap that error event, give a nice 'please be careful' message to the operator and then carry...
  13. joeschoe

    sql insert syntax

    ...& _ "Data Source='JOESNBOOK\CITYTRACKER';" & _ "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384 connDB.Open Set rs = connDB.Execute("SELECT * FROM " & "CitiesIndex", , adCmdText) Do Until rs.EOF Debug.Print rs.Fields(0).Value Loop Dim qstr As String qstr = "INSERT INTO CitiesIndex (CityName)...
  14. joeschoe

    expression with !

    Thanks for your quick reply. So the ! means "assign value to"? You are right, I did get an error runtime error 3265 Item cannot be found in the collection corresponding to the requested name or ordinal Do you have a sample code of what the append query would look like?
  15. joeschoe

    expression with !

    ...New ADOX.Table Dim arData() As String Dim x As Integer, y As Integer Dim i, j Dim rs As ADOdb.Recordset Set rs = New ADOdb.Recordset Set cat.ActiveConnection = connDB rs.Open "SELECT * FROM " & Tab_name & " Where 1=0", connDB, adOpenStatic, adLockOptimistic rs.AddNew rs!Vfield = Vdata...
  16. joeschoe

    CCRP DateTimePicker not in object toolbox

    Thanks for replying, I tried that and got an error message saying "name conflicts with existing module, project or object library" Any Suggestions
  17. joeschoe

    CCRP DateTimePicker not in object toolbox

    For a VB6 program I need a datetipepicker object and the CCRP one seem to fit the bill precisely. I downloaded the sample code with the OCX files. When I open the sample VBP file in the development environment I see the DTPicker object in the tool box for inclusion in a form. I then opened a new...
  18. joeschoe

    How to start a program on shutdown

    Tsuji, Changing the parameter made no difference to the sequence of the execution. Myprogram only gets launched when windows applications including desktop are terminated.
  19. joeschoe

    How to start a program on shutdown

    Tsuji, I tried using gpedit.msc, Local Computer Policy User Configuration Windows settings Scripts Logoff I inserted the pointer to my vbs script When I then requested a shutdown, it still shut down everything before executing myprogram. Have I missed out...
  20. joeschoe

    How to start a program on shutdown

    tsuji, I tried your example and although it did execute myprogram.exe, it did so after closing the desktop. I wanted to display a checklist of user activities and give him the option to abort the shutdown. so 1. can I execute myprogram before anything else is closed? 2. If yes, can I abort the...

Part and Inventory Search

Back
Top