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.
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.
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?
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...
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...
Last edited by Maximillion; Jan 18th, 2021 at 12:19 PM.
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
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.
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.
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).
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.
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.
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
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.
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...
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.
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
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.
@ 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.