Search:
Type: Posts; User: fishbyname
Search:
Search took 0.04 seconds.
-
cheers
i'll give it a try when i get back from lunch and see how i get on
-
cheers for the advice
got it to work in the end
because of some conditional formatting on a previous sheet it wasn't finding the cell properly when i looped through them
used 'step -1' to...
-
i have a nice little bit of code that as set a comment on on a cell to be a picture so that the user can see a preview of the file
at the moment i have set the picture to be a certain size but...
-
does anyone know a way of looking across a row starting from a particular column until it finds the first cell formatted in a specified way
then do the same but search right to left to find the...
-
you can refer to cells using ("A6") or you can say (6, 1)
it helps when you don't know what letter the column is but you can work out it's position
i have finally cracked my problem, the code i...
-
don't think that will work as i would still have to use the index numbers to define the range
all i need is something that:
-->selects an area (defined by index numbers)
-->copies it...
-
I am trying to copy a range of cells from one sheet to another
the position of the range may change due to people inserting and deleting columns to the left
up till now i have just need to set...
-
brilliant that works
sorry forgot to mention about writing into them, been a while since i changed anything on this form and forgot about it
cheers for the help everyone
-
ah i see, did not know about that property
there is a problem though as when a user selects an item in listbox i would like to the combo box's text to be set to values relating to the item in the...
-
i am trying to add validation to my form and i have two combo boxes that the user can select values from
i am trying to stop them typing in a new value so that they can only select a value from...
-
thank you so much, i really need to learn the properties for flexgrid
cheers
-
i am trying to find the column position of a column where the heading is the selected value in a combo box
my code at the moment is this...
For i = 1 To number_of_columns
If...
-
cheers for the tip off about lintz, works a treat now
thanks
-
thanks for the help everyone
managed to get it reading from the flexgrid into an rmchart control
-
thats brilliant, just what i needed
cheers
-
is it possible in VB6 to use openfiledialog? or is it just in .net?
if not is there another way to select a file?
thanks
-
awesome, works first time
thanks
-
i need to find the highest value in my flexgrid
is there an easy way to loop through each column and find the highest value for each?
thanks in advance
-
it does look good, had a play about with it, can't find a way to link it to my flexgrid though
has anyone else used this control with a flexgrid?
-
i am adding data into the grid from various different databases and by using data to make calculations then adding them into the grid
-
i have a flexgrid on my form and i would like to use the contents to produce graphs
i have tried searching for an example of linking a flexgrid to a graph but have had not luck
is this...
-
thanks jcis, that works great
don't suppose you have used mschart before, i'd like to use something which i can customise quite a lot
-
how do you get the data from the flexgrid into the chart though
do you link put a link in somewhere?
or is there an insert statement that takes each cell and inserts their value into a data...
-
is there a way to use the data stored in a flexgrid?
i some simple data inserted into the flexgrid and it would be great if i could produce a graph from it, and even better than that would be if i...
-
thanks for the advice, i managed to find an article about the different controls and i've decided to use flexgrid because i don't need the user to be able to change the data
-
thats great, thanks for the help
got some bits working now
does anyone have any nice code to loop through all the items in each column and format the highest and lowest values in each column?
-
i have just learned how to create and insert data from a database into a flexgrid.
what i would now like to do is format (change the colour, make bold etc) certain cells if they are above or below...
-
i've just used the export to excel code (works great) and i've modified it to include the column and row headings
Dim q As Long
Dim p As Long
Dim newCell As String
Dim xl As Excel.Application
...
-
i am trying to display data from a database stored in various tables in my form
i have managed to use the listview control to dynamically add the correct number of columns, rows etc and populate...
-
thank you... thank you... thank you
works first time
-
i have added in the line now to remove the selected item
it is still loading SelectStat
here is my current code
For item = 0 To Combo1.ListCount - 1
If Combo1.List(item) <> Combo1.Text...
-
LoadView.Load_View is a function which populates a listbox on the main form from which DeleteStat is called
DeleteStat is the form that the combobox is on
i tried adding combo1.removeitem...
-
just realised why it wasn't working after i put it in the form
the value i had stored in the database was "Run Per Over" (no underscores) and the name of the function is "Run_Per_Over"
such an...
-
ok i have created a form where i can store the different functions i have
the form is called 'formula' and the function is called Runs_Per_Over
if i run the code
RPO = CallByName(formula,...
-
the public function called 'Runs_Per_Over' is stored within a module called 'RunsPerOver' so I tried the following...
RPO = CallByName(RunsPerOver, "Runs_Per_Over", VbMethod, result_query_id, n)
...
-
i have a several functions set up that all work fine when i call them
what i would like to do is call one of them by using a value in variable
i have read somewhere about CallByName being the...
-
thanks for the help, i managed to get it working
i stepped it through and realised that the rsViewStats wasn't going back to the start for each entry in rsStats
i added in rsViewStats.MoveFirst...
-
nope still the same problem
here's the full code...
Private Sub Command1_Click()
Dim item As Integer
For item = 0 To Combo1.ListCount - 1
If Combo1.List(item) <> Combo1.Text Then
-
i am deleting an entry from a database and have a little problem
the following code checks to see if the text in the combo box exists in the list of items in the combo box, if so deletes the entry...
-
thats great, it adds it in properly in some cases but for others it just adds them all to list2
i stepped through the code and for the ones which aren't working it is getting to the line
Do...
|
Click Here to Expand Forum to Full Width
|