Recent content by cjac

Hi all, I'm attempting to wrap my flexgrid header text with no luck. I've had a search on the net and found the following property which is not documented within vb help: .ColWordWrapOptionHeader(-1, -1) = 1 However vb does not recognise this as a valid property of the flexgrid. Is there any...

Thanks for the response but this isn't quite what I'm after. The change event is too late - I want to be able to identify which item in the combo box list (not the combo box itself) the mouse hovers over - ie. when the selection is marked by a blue background on the list. I don't think it's...

Hi, is there anyway to identify which item you are currently hovering over in a combobox - I want to use this to retrieve relative data - ie. not on the on_click event but just when the user hovers mouse over the item within the drop down combo box? Or is there any other objects that would be...

Hi, I don't know if this is possible but is there any way to display data at the side of a focussed row within a combo box? ie. I have a code and a price to display in the list although I don't want the price to appear unless the row has focus. I hope this makes sense as it's pretty difficult...

cheers hmckillop - the recordset field name was TRUNC(SYSDATE) although if you attempt to reference a field in that way VB assumes the content of anything within brackets is a variable. I've just renamed the field name within the SQL statement as you suggested. Thanks for the help. Much...

thanks Zemp for the response but I've tries both methods and still the item is missing from the collection. Not sure what fieldname is being assigned!? Is there anyway or querying the recordset to see exactly what the fieldname is in the recordset?

Hi, does anyone know how to view what field names are available in a recordset, ie. I am trying to access the sysdate from the following query: SQLstring = "select trunc(sysdate) from dual" I then execute this SQL using an ado connection to an Oracle DB. What I want to do now is read the result...

Cheers PHV - that'll do the trick nicely. Don't know why I'd got the ampersand in there! Have a star.

Hi, I seem to be having trouble referencing Excel cells from vba. I'm basically trying to run down one column picking up the content for each row until the column is blank(ie. a one column list of references). However, my code runs through the following test once and then trips out. There are...

Strongm - thanks for the documentation. Still seems a bit inconsistent though.

Cheers Mat - that seems to work fine. I would have expected the change event code to fire when a value in the combo box is er...changed! Does this seem illogical? Seems a bit inconsistent to me! C'mon microsoft - sort it out!

Has anyone else found that Change events do not always fire off? I have just inserted some code into the change event of a combo box. When I run my app and select different options from the combo box - my code in the change event is not run. Any ideas why VB disregards this event?

Anyone know if it's possible to lock nodes on a treeview to prevent the user from changing the node text? Cheers, cjac

Thanks to all for the responses. I have found you can actually redim a global array in one procedure and then use the array in another procedure without loss of contents. So I can: ReDim myref(adomyRS.RecordCount) to get the number of elements I need, then: For i = 1 To adomyRS.RecordCount...

Afternoon all, I want to declare an array to hold a varying amount of strings which is dependant on results in a recordset. The problem is that I want the array to be global so I can pass the contents onto other procedures yet I will only know how many elements I need at runtime. If I redim...