Page 2 of 2 FirstFirst 12
Results 41 to 78 of 78

Thread: listview table colors

  1. #41
    PowerPoster wqweto's Avatar
    Join Date
    May 2011
    Location
    Sofia, Bulgaria
    Posts
    5,121

    Re: listview table colors

    When you hit a road block best would be to research the issue at hand in a *separate* smaller side-project so that it's faster to compile and tear apart without breaking your main project and second, it becomes easier to share this side-project as well.

    Large projects (years of development) always grow either by impl daily tasks or by incorporating side-projects that are fleshed out and debugged outside main development. This way the newly added components have better decoupling to the rest of the code as they are developed outside of main project.

    cheers,
    </wqw>

  2. #42
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    I must agree with wqweto.
    1-The first attachment you PM'd me does not show your PROBLEM. Have NO idea how to use that program you sent. A one-form project with an example of what you are trying to do (DB included) would be ever-so-helpful. If we had had that early on...this thread would have been done days ago.
    2-I received a Virus warning on the second attachment (12 year old one) when I started to download (so I did not do so).

    Everyone here would LIKE to help you, but you have to help US...make a small project, put in either a listview or a flexgrid ("I" prefer the latter, but others, like you, may opt for a listview), a call to your database, some images, and based upon your image in post31, I am positive we can solve this quickly.

    Sammi
    Sam I am (as well as Confused at times).

  3. #43

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    2-I received a Virus warning on the second attachment (12 year old one) when I started to download (so I did not do so).
    Sammi


    that's just absurd.. nothing i have ever made, worked on or even shared ever contained a virus in my entire life.

  4. #44
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Don't blame me...my Virus Defender stated it.
    Sam I am (as well as Confused at times).

  5. #45
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Ok...so I have in MY little example, using a VFlexGrid control, an Access DB and two Imagelists, a grid that looks like this.

    What now do you wish to do with it to make it look different?

    Name:  Capture.JPG
Views: 391
Size:  14.4 KB
    Sam I am (as well as Confused at times).

  6. #46

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    Ok...so I have in MY little example, using a VFlexGrid control, an Access DB and two Imagelists, a grid that looks like this.

    What now do you wish to do with it to make it look different?

    Name:  Capture.JPG
Views: 391
Size:  14.4 KB
    you are on the right track!

    in front of the card number - there will be a red x - for unowned by default.. but when they right click the card - no matter where in that card row the edit form will open and there they can click own/unowned.. which if owned the red x becomes a green check.. to look like this...

    Name:  untitledfffff.GIF
Views: 375
Size:  3.7 KB


    also there will be 2 other columns that have pics...

    own/unowned icon & card number
    card name
    type 1 - pic
    type 2 -pic
    rarity - pic
    psa - pic
    value: - $0.00
    *some of these can be edited by the user in MY EDIT form... hence "multiple" forms for different uses and calling to the database on just about every form...


    but i am sure you are using 1 form in your example.. where my project REQUIRES multiple forms for different things/info called from the database... here's my demo project i just made - included is the actual database i want to use...
    Attached Files Attached Files
    Last edited by Maximillion; Jan 18th, 2021 at 12:19 PM.

  7. #47
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    What do you expect to see in EACH OF these columns? Text/images?

    If text, what text (per column--based upon your db fields)
    If images, give me an example of the images...are they related to your db column Type 1, Rarity, or PSA? (or something else?)

    IOWs, create a jpg with my attachment, adding in sample text and/or images...from there, I can probably finish this up

    Name:  Capture.JPG
Views: 335
Size:  14.1 KB
    Sam I am (as well as Confused at times).

  8. #48

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors


    own/unowned icon & card number
    card name
    type 1 - pic
    type 2 -pic
    rarity - pic
    psa - pic
    value: - $0.00

    as edited in my previous post





    Name:  sssss.GIF
Views: 373
Size:  11.0 KB
    Last edited by Maximillion; Jan 18th, 2021 at 12:26 PM.

  9. #49

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    i have other forms that need to connect to the database.. so can you include a couple of forms in your example? or use the demo one i attached? but using my database...


    the other thing i am concerned about and dunno how to do.. is my database.. there are cards with numbers like 1-100 and such.. but OTHER cards of certain sets are not but ARE part of that set... ie:
    CardNumber

    127
    128
    129
    130
    SH4
    SH5
    SH6


    so i wouldn't know how to include them in their set they are listed in... you'll see that they are in the same SET in the database... i didn't make them this way - that is how they are listed OFFICIALLY in their sets.. so in the above set example - there is actually 133 cards but the last 3 are NOT numbered normally... so calling these instances i have no idea.. even tho the set has 133 spots before the next set... i don't think it would be that hard... if you do like amount of enteries in each set or something? i dunno...
    Last edited by Maximillion; Jan 18th, 2021 at 12:54 PM.

  10. #50
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    okay...next step...using your database and your imagelists, I have come up with this.
    Attached Images Attached Images  
    Sam I am (as well as Confused at times).

  11. #51
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    I have a two-form project as an example. I only loaded three Type 1's in the grid (Lightning, Fire and Water)--I have NO idea if the images I selected from your imagelist match those Type 1's. I also put an X in that first column (which I titled 'Owned?')...but I would think you would have some table somewhere that would tell the program if it is owned or not (I am assuming by some 'USER'????).

    Anyway, I will share my example if you think you can take it from here.
    Sam I am (as well as Confused at times).

  12. #52
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    As far as the cardnumber is concerned, when I put them into the grid, they are TEXT. It is easy to COUNT by going through the grid and incrementing some sort of counter variable if you need to count certain cards within the set. Or, if you are returning ALL cards within a set (remember, my example only returned three types to keep it simple), the total number of cards will be the number of rows in the grid, minus 1 (header).
    Code:
    Debug.Print VGrid1.Rows - 1
    Sam I am (as well as Confused at times).

  13. #53

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    I have a two-form project as an example. I only loaded three Type 1's in the grid (Lightning, Fire and Water)--I have NO idea if the images I selected from your imagelist match those Type 1's. I also put an X in that first column (which I titled 'Owned?')...but I would think you would have some table somewhere that would tell the program if it is owned or not (I am assuming by some 'USER'????).

    Anyway, I will share my example if you think you can take it from here.
    yes,yes, yes - that is exactly what i was looking for! awesome! tho, value will be in the format of $0.00 and rarities will be icons not text - but i can manage that... ty ty ty

    i believe i can, ty very much for your time and effort! very much appreciated! i will enjoy working on this..
    Last edited by Maximillion; Jan 18th, 2021 at 02:33 PM.

  14. #54

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    I have a two-form project as an example. I only loaded three Type 1's in the grid (Lightning, Fire and Water)--I have NO idea if the images I selected from your imagelist match those Type 1's. I also put an X in that first column (which I titled 'Owned?')...but I would think you would have some table somewhere that would tell the program if it is owned or not (I am assuming by some 'USER'????).

    Anyway, I will share my example if you think you can take it from here.
    yes in the EDIT form.. that when you "RIGHT CLICK" on a card entry... so as mentioned, must be able to "right click" - to show the EDIT form and "double click" on a card entry to view the DETAILS form... but the EDIT form is where the user can change/edit certain things... hence why more than 1 form to/from the database is needed...
    Last edited by Maximillion; Jan 18th, 2021 at 02:31 PM.

  15. #55
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Well, I currently put in a Right-Mouse ONLY TO CHANGE THE OWNER>...you can 'fix that' to bring up an Edit screen and make changes throughout the Grid.

    Attached is what that one form looks like, and my sample....q's? FlexGrid_with_Images.zip
    Attached Images Attached Images  
    Sam I am (as well as Confused at times).

  16. #56

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    i will look into this.. and ty again! i'll let you know if i have any struggles ty again!


    it won't run... got error after error

    Name:  1111.jpg
Views: 405
Size:  19.2 KB

    Name:  2222222.jpg
Views: 375
Size:  28.2 KB

    Name:  333333.jpg
Views: 376
Size:  25.2 KB
    Last edited by Maximillion; Jan 18th, 2021 at 02:41 PM.

  17. #57
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    did you unzip it?
    Sam I am (as well as Confused at times).

  18. #58
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    I can't see the errors
    Sam I am (as well as Confused at times).

  19. #59
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    open, don't run, Form2...take a snapshot of it...does it have a picturebox on it, or a grid?
    Sam I am (as well as Confused at times).

  20. #60

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    I can't see the errors
    you can right click on the images and open in a new tab...






  21. #61

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    open, don't run, Form2...take a snapshot of it...does it have a picturebox on it, or a grid?

    picturebox

  22. #62
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Correct....you don't have the Vgrid OCX loaded/registered.

    That's why I asked you to send an image of FORM2 (in IDE). You should probably see a Picturebox which should be a Vgrid. You need to try this:

    Got Components and see if "VB FlexGrid Control X.XX" is in the list. If it is, add it.
    Sam I am (as well as Confused at times).

  23. #63
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    was it there?
    Sam I am (as well as Confused at times).

  24. #64
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Sam I am (as well as Confused at times).

  25. #65

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    Correct....you don't have the Vgrid OCX loaded/registered.

    That's why I asked you to send an image of FORM2 (in IDE). You should probably see a Picturebox which should be a Vgrid. You need to try this:

    Got Components and see if "VB FlexGrid Control X.XX" is in the list. If it is, add it.
    it's not in the list... bound grid and msflexgrid is all i see in the list.... why not using just a normal msflexgrid?????

  26. #66

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    Quote Originally Posted by SamOscarBrown View Post
    oi, i think this getting to be more work than i need on my plate...

  27. #67

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    nvm, ty anyways for your hard work and effort - but i can't be bothered installing new stuff.. i just have too much going on at once and i have to go to work in a few minutes... but ty again

    sorry this didn't work tho it looked promising...

  28. #68
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Never mind then...let's use an MSFlexGrid instead. Select THAT from the list of components.

    Add 1 to your form and set # of columns to 9. Set number of Fixed Cols to 0. Delete the PictureBox. Rename your MSFLEXGrid to 'vGrid1'. THEN, you should have no problem (you will have to set the width of the grid as appropriate once you run it.
    Sam I am (as well as Confused at times).

  29. #69
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    It is just that the VBFlexGrid is more versatile, but in your case, the MSFlexGrid will work just fine.
    Sam I am (as well as Confused at times).

  30. #70
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Oh, one more change, as the MSFlexGrid does not recognize the same Constants as the VBFlexGrid,

    change this line

    VGrid1.CellAlignment = FlexAlignmentCenterCenter

    to VGrid1.CellAlignment = 4
    Sam I am (as well as Confused at times).

  31. #71

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    i'll have to get back to this after work... another 11hr shift here i come.. sux...

  32. #72

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    did all that you said.. but then i get an error cause of no imagelist... you have pictureboxes instead...


    Private Sub sMnuBaseSet_Click() 'highlighted in yellow
    Form2.Label1.Caption = "Base Set"
    Form2.Image1.Picture = Form2.logos.ListImages(1).Picture 'error
    Form2.Show
    Unload Me
    End Sub



    k, off to work.. feel free to update a new dl if you want.. i'll get to it after work...

  33. #73
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    not sure why you are getting only PBs...could have been caused when you first tried to open the project and got the error about the VGRID.

    I'll modify it a bit and send you a new one (including bringing up the edit form and a couple of mods to IT).
    Sam I am (as well as Confused at times).

  34. #74
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: listview table colors

    Ok---I'm done...will answer questions as you have them. Please run this program (you do NOT need VBFlexGrid!). The 'second' form looks like this, and right-clicking on it will bring up your edit form. I added code to that form as well so that when changes are made, they are used to update the database, and then reshow your 'second' form with the grid, showing the changes.

    Hopefully this answers all your PREVIOUS questions and addresses your concerns so far on this Thread.

    Sam
    Attached Images Attached Images  
    Attached Files Attached Files
    Sam I am (as well as Confused at times).

  35. #75

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    when i close form 2 - the app doesn't end correctly.. i always have to go to RUN/END the program....


    i had to comment out/change some of your code in the main form in order for form 2 to close correctly

    Code:
    Option Explicit
    
    
    
    Private Sub sMnuBaseSet_Click()
        gCardSet = "Base Set"
        Form2.Image1.Picture = Form2.logos.ListImages(1).Picture
        Form2.Show
        'frmMain.Hide - not needed
        Unload Me 'added
    End Sub
    
    Private Sub sMnuExit_Click()
    
    'NOT NEEDED - I NEVER EVER USED THIS BEFORE
        'Dim f As Form
        'For Each f In Forms
            'Unload f
        'Next
    
    
        
        Unload Me 'added
    
    End Sub
    
    Private Sub sMnuJungleSet_Click()
        gCardSet = "Jungle"
        Form2.Image1.Picture = Form2.logos.ListImages(2).Picture
        Form2.Show
        'frmMain.Hide - not needed
        Unload Me 'added
    End Sub
    also, when i try to change owned in the EDIT page - i get the following error: - but fixed when i added No and Yes to "cboOwn" list


    and why are we doing this in the form load??? why not just put the options in it's list?? there's just no need to do it this way
    Code:
     cboType2.AddItem ("Metal")
        cboType2.AddItem ("Rainbow")
        cboType2.AddItem ("Darkness")


    omg, so many issues with this example... i can't get type 2 and rarities to work.. nothing is in their designated lists - everything is hard coded.. it's all confusing... just getting frustrated at this point... after 11 hrs of work and this - i'm getting annoyed...




    i need a break from all this cause i'm just confused and getting really upset at this point..

    it's error after error..
    Last edited by Maximillion; Jan 19th, 2021 at 07:16 AM.

  36. #76

    Thread Starter
    Lively Member
    Join Date
    Dec 2020
    Posts
    99

    Re: listview table colors

    @ ADIMIN: topic is dead... lock it or delete it cause nobody is gonna say anything more.. and you removed the last few comments anyways!

    this guy only makes you believe in his "coding skills" - but in reality he just confuses the hell out of people and doesn't use their examples.. instead creates his own "theory" of things... "Sam I am (as well as Confused at times)" - yep, his signature speaks loudly!!!! he's a bully on here i see that.. no wonder why he has to go to bible study.. at least he admits he has a problem.. but even i don't think god himself can help him... he should change his name to "Dr. Seuss Stuck In My Own Madness"!



    EDIT: i am done with him and this topic.. since there are no real coders.. this guy took me being tired after an 11 crap shift at work and dying to see and learn from this.. and all i got was error after error... i was tired and he took it personally and called me un grateful tho i thanked him 2x... yeah, i don't think this is the place to get help! One card lset lists correctly but the second one doesn't and he he said "if i was a coder i would caught HIS mistake on HIS demo".. what a crock of crap!


    if he is one of the people helping out around here.. people are screwed! so will be this forum be!
    Last edited by Maximillion; Jan 20th, 2021 at 09:50 PM.

  37. #77
    PowerPoster
    Join Date
    Jun 2013
    Posts
    7,219

    Re: listview table colors

    Quote Originally Posted by Maximillion View Post
    ...he should change his name to "Dr. Seuss Stuck In My Own Madness"!
    What a friendly soul you are...

    And quite funny (coming from a "grown man, who still plays with Pokemon-cards")...

    Olaf

  38. #78
    Administrator Steve R Jones's Avatar
    Join Date
    Apr 2012
    Location
    Largo, FL.
    Posts
    1,826

    Re: listview table colors

    Quote Originally Posted by Maximillion View Post
    @ ADIMIN: topic is dead... lock it or delete it cause nobody is gonna say anything more.. and you removed the last few comments anyways!
    You asked for it

    I'd advise you to take a few months off from posting here.

Page 2 of 2 FirstFirst 12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width