Search results for query: *

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

If you would like to query 2 seperate db's and hold the results in just the one recordset you could ask your DBA to set up a link from one db to the other. I use this method when querying on more than one db - it also saves on connections as I only need to establish one connection to hit both...

Try using the client side cursor, ie. Set ad = New ADODB.Command Set ad.ActiveConnection = mobjCnn ad.CommandText = "sp_procedure" ad.CommandType = adCmdStoredProc Set rs.CursorType = adUseClient

Have a star Zemp! Std combo box now in place and I don't get the problem. I have multiple combo boxes available in my toolbox installed by my predecessor - not sure of the purpose as a combo box is a pretty simple thing in itself. I thought the properties were odd for a combo! Anyway, thanks...

I think we may be getting somewhere now. I'm using control arrays because of the number of controls on my form - basically doing a tree view and then using frames for each branch on the view - hence lots of objects on my form. Although I don't think the fact that my combo box is a control array...

Zemp thanks for the post but vb will not allow me to directly add a string value that way. It produces the compile error: "Assignment to constant not permitted."