Recent content by joeschoe

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

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

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.

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

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.

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

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

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

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

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

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

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

I want to create a table and add data to it. I am coding in VB6 and the database engine is MSDE. I created the table with one field, no indexes. I then tried to insert one record, I get the following error message Run-time error ‘-214721833(80040e57)’: String or binary data would be...

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?

I don't understand the line I found in a sample program. Can someone please interpret for me the line: rs!Vfield = Vdata It appears in the second last line of the sample code below. Sub ADOXAddRecord(Tab_name As String, Vfield As Variant, Vdata As Variant) Dim cat As New ADOX.Catalog Dim...