Search:

Type: Posts; User: fishbyname

Page 1 of 2 1 2

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    329

    Re: Image Dimensions

    cheers

    i'll give it a try when i get back from lunch and see how i get on
  2. Replies
    2
    Views
    344

    Re: Search for formatting

    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...
  3. Replies
    2
    Views
    329

    Image Dimensions

    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...
  4. Replies
    2
    Views
    344

    [RESOLVED] Search for formatting

    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...
  5. Replies
    5
    Views
    697

    Re: Range using index numbers

    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...
  6. Replies
    5
    Views
    697

    Re: Range using index numbers

    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...
  7. Replies
    5
    Views
    697

    [RESOLVED] Range using index numbers

    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...
  8. Re: checking values in combo boxes

    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
  9. Re: checking values in combo boxes

    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...
  10. [RESOLVED] checking values in combo boxes

    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...
  11. Re: flexgrid - find column number

    thank you so much, i really need to learn the properties for flexgrid

    cheers
  12. [RESOLVED] flexgrid - find column number

    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...
  13. Re: using flexgrid to make a graph

    cheers for the tip off about lintz, works a treat now

    thanks
  14. Replies
    4
    Views
    425

    Re: flexgrid / access / graph

    thanks for the help everyone

    managed to get it reading from the flexgrid into an rmchart control
  15. Replies
    3
    Views
    673

    Re: open file control?

    thats brilliant, just what i needed

    cheers
  16. Replies
    3
    Views
    673

    [RESOLVED] open file control?

    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
  17. Replies
    3
    Views
    1,811

    Re: find highest value in flexgrid

    awesome, works first time

    thanks
  18. Replies
    3
    Views
    1,811

    [RESOLVED] find highest value in flexgrid

    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
  19. Re: using flexgrid to make a graph

    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?
  20. Replies
    4
    Views
    425

    Re: flexgrid / access / graph

    i am adding data into the grid from various different databases and by using data to make calculations then adding them into the grid
  21. Replies
    4
    Views
    425

    [RESOLVED] flexgrid / access / graph

    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...
  22. Re: using flexgrid to make a graph

    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
  23. Re: using flexgrid to make a graph

    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...
  24. [RESOLVED] using flexgrid to make a graph

    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...
  25. Re: listview v datagrid v flexgrid

    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
  26. Replies
    3
    Views
    543

    Re: flexgrid format data/cells

    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?
  27. Replies
    3
    Views
    543

    flexgrid format data/cells

    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...
  28. Replies
    37
    Views
    48,314

    Re: something color with MSFlexGrid

    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
    ...
  29. [RESOLVED] listview v datagrid v flexgrid

    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...
  30. Replies
    9
    Views
    920

    Re: checking item in combo box

    thank you... thank you... thank you

    works first time
  31. Replies
    9
    Views
    920

    Re: checking item in combo box

    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...
  32. Replies
    9
    Views
    920

    Re: checking item in combo box

    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...
  33. Re: using variables to call functions

    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...
  34. Re: using variables to call functions

    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,...
  35. Re: using variables to call functions

    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)
    ...
  36. [RESOLVED] using variables to call functions

    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...
  37. Re: checking listboxs for entries

    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...
  38. Replies
    9
    Views
    920

    Re: checking item in combo box

    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
  39. Replies
    9
    Views
    920

    [RESOLVED] checking item in combo box

    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...
  40. Re: checking listboxs for entries

    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...
Results 1 to 40 of 43
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width