Page 2 of 3 FirstFirst 123 LastLast
Results 41 to 80 of 100

Thread: Ok, DB connection.. What gives?

  1. #41

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Quote Originally Posted by SamOscarBrown View Post
    Then you code your EDIT form and your INFO forms. It is very simple to do both, but I don't know what you want them to look like.
    Ofcourse you don't, I haven't designed them yet - (tho i do have the INFO form that i'm working on) - form3 which you have.. I know I have to rename the forms. I see it getting confusing.

    I'm just not understanding the hostility about how one designs their projects. Great, I'm glad you have all that background.. However, This is a simple project not for testing or military grade or anything else. This is for and dedicated to my younger sister. I am doing this for her.. Maybe later I'll upgrade it for other coins or not. I just want it to look and work the way I design it and you should atleast see that. Someone's desgin doesn't have to be military or client related. I really do appreciate yer help and all I really do, but please don't force someone to change thier design.. just respect / deal and help with it in it's designed form.

    I "could" possibly try to play with frames and such.. I didn't think that far out.. I was just thinking seperate forms.. 1 for INFO READING and 1 for EDITING - Hence the LEFT and RIGHT clicking on an entry
    Last edited by Mongoose_MHS; Jun 6th, 2024 at 05:05 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    It's not hostility...c'mon. I am offering ADVICE. Take it, or not....no offense to me. Let me see your DESIGN of your info and edit forms and I'll try to help you.

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

  3. #43

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Maybe the word "hostility" was a lil strong of a word.. K, give me a bit and i'll upload it..
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    I'll be away from this most of this evening...will relook stuff in the morning (I'm already working on how your info form will be populated from your table2.)
    Sam I am (as well as Confused at times).

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

    Re: Ok, DB connection.. What gives?

    Took 10 minutes and took your form3 (renamed it frmInfo) and when you left click on the grid, something like this shows. I am sure you want more information...and that is easy to do.

    Name:  coinAbout.jpg
Views: 161
Size:  21.5 KB
    Sam I am (as well as Confused at times).

  6. #46
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    or better yet?????
    Attached Images Attached Images  
    Sam I am (as well as Confused at times).

  7. #47

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    LOL, yer getting ahead of me but yes, that's where i'm going EXACTLY with that form.. That would be the LEFT click on an entry to show the INFO for that entry. But yes, exactly what that form is suppossed to do. Now yer getting me

    i'll upload soon.. Yer not at all far off from what i'm doing for that specific form by any means! There might be a summary note but otherwise you nailed that form!

    And, yes I am working on the images for the bottom right corner.. like I did for the banner.. Yes, I am working on more than 1 thing at a time because I want it to work and look the way I intend it to be seen and used.. So, yes it takes me a bit to upload current progress.. A lot going on behind the scenes.
    Last edited by Mongoose_MHS; Jun 6th, 2024 at 09:28 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  8. #48
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    okay.....but just so that we don't get too far apart....here is the current version of your project that I have.
    If you make changes to the code OR THE Database, re-send everything back in a zip file. And let us know what changes you made (because some changes may affect other parts of the project without you knowing it).

    NOTE: I added a module so I could have some project-wide variables to 'pass' between different forms.
    Attached Files Attached Files
    Sam I am (as well as Confused at times).

  9. #49

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Ok, so I added 2 forms and added a menu option to the main form, but it doesn't effect anything - It just opens the add entry form. I also removed the unneeded comments.

    The only error I get, is when I want to see the info of a coin that doesn't have a release date yet as they have not been released yet, so there is no date to put there. So, I get the error of EOF - because all the fields need something in them.

    Updated attached:
    Attached Files Attached Files
    Last edited by Mongoose_MHS; Jun 7th, 2024 at 10:18 AM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    In your circulation field, you have "Circulated" for all entries.
    Is the only other option "Uncirculated"?
    If so, I am going to change the field type for that column to be Yes/No. Then when I query the DB, if there is a "Y", I'll populate a field/cell with "Circulated", otherwise I'd populate it with "Uncirculated". That way, why a NEW entry is added, the user will have an option, Yes Or No in a combo box.

    Let me know before I "fix" that.

    I already fixed your 'date' error with IsNull or ""
    Sam I am (as well as Confused at times).

  11. #51

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Well, there will be other values other than circulated and uncirculated. There could be mint-circulated and other values.. I'll have to do a little more research on circulation values. However I don't think that was the cause of the null error cause it only happened whenever I clicked on a coin with no release date.

    So far, I have come across this: However I have also come across circulated mint condition.. So, I don't really know all the real options to circulation yet.
    The Mint makes the quarter for circulation, as well as uncirculated and proof finishes for collecting. The Denver and Philadelphia Mint facilities make the circulating and uncirculated coins and the San Francisco Mint makes the proof coins.
    Found here at the bottom of page: https://www.usmint.gov/coins/coin-me...-coins/quarter

    As far as mint marks: Denver(D), Pensylvania(P), San Franciso(S) - Hover there are coins with no mint mark, so, i'll use Blank(B) for the value and tbd for those not yet released because there is no info for unreleased coins. You'll see that in the 2 forms I added in the cobobox lists.
    Last edited by Mongoose_MHS; Jun 7th, 2024 at 02:46 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    Here is the latest....LOTS of undone checks that have to be made once you start adding to a database with textboxes, etc.

    Those checks are your responsibility.

    ANyway, you will see that this latest program WILL allow you to insert a new record.

    And, as I said, I fixed your 'null date' thingy.
    Attached Files Attached Files
    Sam I am (as well as Confused at times).

  13. #53

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Thank you.

    My first check, was I noticed it's not writing to table 2 the release date, name, etc - But I did notice that in your notes.. I'll work on the checks tomorrow.
    Last edited by Mongoose_MHS; Jun 7th, 2024 at 07:45 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  14. #54

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    @Sam

    So, I'm trying to work on a module due to coding and check menu.. So, when the INFO form loads, I want it to display certain coin images.. atm, I am just working on "American Women" coin set.. However, I will obviously be adding a lot more sets. So, How do I go about this as far as setting up the module so that I can just call it upon form load? Is what I am doing even close?

    Code:
    option explicit
    
    Public Sub coinselector()
    
    'LOAD COIN IMAGES
    'based on coin set.. ATM, it's just for the "American Women" coin set, However.. I want to add more sets/names. So, I asssume there is going to a very big list of cases or is there another way of doing this?
    
    if lblCoinSet.caption = "American Women" then
            Select Case frmInfo.txtCoinName.text 'I know this isn't completely right.. Just throwing it out there..
            Case "Maya Angelou"
                frmInfo.Image1.Picture = ImageList1.ListImages(1).Picture 'Maya Angelou coin image
            Case "Dr. Sally Ride"
                frmInfo.Image1.Picture = ImageList1.ListImages(2).Picture 'Dr. Sally Ride coin image
            Case "Wilma Mankiller"
                frmInfo.Image1.Picture = ImageList1.ListImages(3).Picture 'Wilma Mankiller coin image
            Case "Nina Otero-Warren"
                frmInfo.Image1.Picture = ImageList1.ListImages(4).Picture 'Nina Otero-Warren coin image
            Case "Anna May Wong"
                frmInfo.Image1.Picture = ImageList1.ListImages(5).Picture 'Anna May Wong coin image
            Case "Bessie Coleman"
                frmInfo.Image1.Picture = ImageList1.ListImages(6).Picture 'Bessie Coleman coin image
            Case "Edith Kanaka?ole"
                frmInfo.Image1.Picture = ImageList1.ListImages(7).Picture 'Edith Kanaka?ole coin image
            Case "Eleanor Roosevelt"
                frmInfo.Image1.Picture = ImageList1.ListImages(8).Picture 'Eleanor Roosevelt coin image
            Case "Jovita Idar"
                frmInfo.Image1.Picture = ImageList1.ListImages(9).Picture 'Jovita Idar coin image
            Case "Maria Tallchief"
                frmInfo.Image1.Picture = ImageList1.ListImages(10).Picture 'Maria Tallchief coin image
            Case "Rev. Dr. Pauli Murray"
                frmInfo.Image1.Picture = ImageList1.ListImages(11).Picture 'Rev. Dr. Pauli Murray coin image
            Case "Patsy Takemoto Mink"
                frmInfo.Image1.Picture = ImageList1.ListImages(12).Picture 'Patsy Takemoto Mink coin image
            Case "Dr. Mary Edwards Walker"
                frmInfo.Image1.Picture = ImageList1.ListImages(13).Picture 'Dr. Mary Edwards Walker coin image
            Case "Celia Cruz"
                frmInfo.Image1.Picture = ImageList1.ListImages(14).Picture 'Celia Cruz coin image
            Case "Zitkala-Å a"
                frmInfo.Image1.Picture = ImageList1.ListImages(15).Picture 'Zitkala-Å a coin image
            Case "Ida B. Wells"
                frmInfo.Image1.Picture = ImageList1.ListImages(16).Picture 'Ida B. Wells coin image
            Case "Juliette Gordon Low"
                frmInfo.Image1.Picture = ImageList1.ListImages(17).Picture 'Juliette Gordon Low coin image
            Case "Dr. Vera Rubin"
                frmInfo.Image1.Picture = ImageList1.ListImages(18).Picture 'Dr. Vera Rubin coin image
            Case "Stacey Park Milbern"
                frmInfo.Image1.Picture = ImageList1.ListImages(19).Picture 'Stacey Park Milbern coin image
            Case "Althea Gibson"
                frmInfo.Image1.Picture = ImageList1.ListImages(20).Picture 'Althea Gibson coin image
                
            End Select
    end if
    'There's probably a lot more to this "IF" statement for every set
    
    End Sub
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    Well, I have decided to make my own Quarters Program...I have all the images for the Women Quarters, and they DO, in my program, get displayed in the 'info' form. I started from scratch as I was not in favor of your form designs, nor your database configuration.

    Anyway, I am still working on mine...if you are interested in the future to see MINE, let me know....I'll be adding more functionality tomorrow. I also have downloaded (with the help of ChatGPT) all the women, us state, and US State Proof data.

    And no, I didn't have all those loadpicture lines like yours...I have TWO!
    Sam I am (as well as Confused at times).

  16. #56
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    Sorry. For YOU, all you have to do is either have a global variable for your coinname (mine is gCoinName Declared in a module) (or because you already have your coinname in a label on your info form, you could use that instead of gCoinName. It would be like this (Note, I have an image of the front of a quarter with N/A overlaid on it in case I didn't have all the images (I don't yet have all the state images loaded, but do have them)).

    Note, because one of the Women Quarters has an apostrophe in it, I had to add that Replace function. Also, that woman with the name with a character over the S, I changed it to be just a plain S. (I COULD look up what that character is and 'replace' it once all database calls are completed, but I didn't want to do that at this time.)


    Code:
             
             Dim tempCoinName As String        
             tempCoinName = Replace(gCoinName, ".", "")
             Dim imageExist As String
             imageExist = Dir(App.Path & "\images\American Women Images\" & tempCoinName & ".jpg")
             If imageExist = "" Then
                    Picture1.Picture = LoadPicture(App.Path & "\images\American Women Images\Not Available.jpg")
             Else
                    Picture1.Picture = LoadPicture(App.Path & "\images\American Women Images\" & tempCoinName & ".jpg")
             End If
    Sam I am (as well as Confused at times).

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

    Re: Ok, DB connection.. What gives?

    Example: (I also simplify MY program a lot by using the info form as an edit/delete form as well.)
    Attached Images Attached Images  
    Last edited by SamOscarBrown; Jun 11th, 2024 at 09:44 AM.
    Sam I am (as well as Confused at times).

  18. #58

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Quote Originally Posted by SamOscarBrown View Post
    Well, I have decided to make my own Quarters Program...
    I might as well throw my hands in the air and give up cause I am not gonna compete with your copy of the same exact program doing the exact same thing.. Showing the same exact info and images..

    Well, i'm not using a folder to store my coin images because I don't want them to be altered/replaced.. That's why I am using an imagelist.. The image folder will not be incuded in the end. You should make a different banner as I edited 2 different images to make that one. I was actually thinking of using the info form as an editor as well, just wasn't sure if I wanted to re-design the form.
    Last edited by Mongoose_MHS; Jun 11th, 2024 at 01:54 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    Don't give up....I'll assist you (after all, this is YOUR project for your daughter, right?). I'm just saying that is seems like a worthy project. I (remember "I") just don't prefer the way you set up your database, nor your thought processes on form development.

    I'm also tracking (not finished yet) numbers minted at the three mint locations, as well as comments for the 6 Territory sets of 'state' quarters. Just fun doing it, that's all.

    Continue with what you have, and as you run into problems, let us (ALL of us) know how you need help.

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

  20. #60

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    So, why are you making a different copy instead of a like a co-op app? It really is the same exact app in the end.. I can always adjust the design to my liking, my own fonts and all that.. If we are working on the same app why not just make it 1 app for both of us? why have 2 different copies? I can always change my copy design and layout.. It's just getting there. I use a different font for 1, i may have a splash screen and you don't, etc.. Just still the same exact app in the end that I started. Do you even collect quarters? Maybe I want to go beyond quarters.. That just becomes a matter of copy/paste.. It's for and dedicated to my younger SISTER. Something easier for her in her adventures collecting quarters.. I dunno why she is so into it.. However I can't judge because I collect wheat pennies and $2 bills.. I guess I know where she gets it from LOL..
    Last edited by Mongoose_MHS; Jun 11th, 2024 at 03:54 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  21. #61

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Just saying.. Taking someone's idea/project and making it your own is NOT original as well as discouraging to the person who came up with it.. If you were willing to make it a collaborative I could see yer point, but to outright say that you don't agree or like my design doesn't make it right or fair for you to make it your own as it does EXACTLY the same thing. Feeling a little pissed off and project stolen from me and my younger sister. Do you even collect quarters? I bet not.. I'm sure that this is NOT what this forum is about.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  22. #62

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    In my school, taking someone's work and taking it on yer own and claiming credit is a "no go" and can even get you expelled from the class or the school altogether - (Depends on the offense). You don't see me doing that on here. I had a genuine program and it wasn't even for me, it's a dedication to someone I love and trying to encourage her to continue on. Whatever, kinda expected this once you start sharing projects.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    So, why are you making a different copy

    Because I want to. I just think it is a good app to give to folks who might BE coin collectors (at least quarter collectors). I've added information about US State PROOF (San Francisco mint) Quarters and US Park Quarters. As I may have stated above, I'm adding production numbers from the three mint sites.

    I am not in 'competition' with you or anyone else. I have created new images for my main form (which has a frame to simply show the overall picture at the beginning). I got my database (four tables - one for each set of quarters (Women, State, State Proof, US Park)) by using ChatGPT to create Excel spreadsheets for me with all the data I need for each of the tables. I then imported those Excel files to MS Access. So, yeah, you gave me an IDEA, and I just want to run with it. And I didn't get all hung up on that (IMO) 'convoluted' menu system that you have...I like to keep things simple. It may take a few more lines of code, but I can follow my code very easily.

    I will repeat what I said....if you want help with YOUR program, let US know what help you need.

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

  24. #64

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Quote Originally Posted by SamOscarBrown View Post
    I just think it is a good app to give to folks who might BE coin collectors (at least quarter collectors).
    Sammi
    I made the very FIRST copy.. Why are YOU making a different copy? Still the same EXACT app.. That I came up with. Why am I going to ask for help when you obviously have all the answers to the same EXACT app? Why can't we make this a collaborative project instead of his/my way thing? If you're not willing to collaborate then i'll consider you a thief because you couldn't / didn't do it BEFORE I came up with it.
    Last edited by Mongoose_MHS; Jun 11th, 2024 at 09:58 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  25. #65
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Ok, DB connection.. What gives?

    Guys, guys, guys..... simmer down... this isn't something to get your knickers in a twist over.

    Mongoose - WhT Sm's done isn't theivery - ethiclly it may be in a grey area - You posted the entire source code online... in a public forum... At that moment, you basically lost control over it. There's nothing wrong with someone then downloading that, modifying it, and then producing a complete program. At least Sam had the guts to look you in the eye and say right to your face "hey, Im going to take this, make some changes and update the code with what I'd consider better practices." There's nothing in your code or data that is proprietary. Nothing secret.

    As for who came up with the idea... ideas are a dime a dozen. You can't protect an idea. And it's not like yoiu're the first to come up with a Coin Collector app.... there's at least a dozen (all for a dime! ) Google apps out there. And they have more functionality than yours or Sam's does. Do you think Excel just appeared out of no where from Microsoft one day? Pffft! Nope. They plagiarized and raided Lotus 1-2-3... and Word? They pulled that from the classic WordStar.

    As for collaboration... if you want that, might I suggest posting in the Projects area. But I think Sam has tried that... several times in this thread alone, but you're either unable or unwilling to follow through with it and jump from one thing to another fairly arbitrary -- all in one thread, which goes against the "one thread, one topic" mantra (for a lack of a better word) of the forums. It's confusing and things I think are getting lost. I've lost (nearly) all interest in this trhead becausse I can't follow it any more. I'm sure Sam's just as frustrated with it. He sees the potential here and wants to make it better.


    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  26. #66
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    So, why are you making a different copy

    Because I want to. I liked the idea of this project, but have taken it in a different direction. I created my OWN database (with the help of ChatGPT which created excel files for me with the data for the women quarters, the state quarters and the US Park quarters. (I have 3 tables in my database, one for each of the type of quarter. My menu system is very simple (I like simple). I have my own graphics (not using yours). I have images of all the Women quarters, front and Back, as well as all the 50 state and 6 territory quarters. I have still to add the 56 images of the US Park quarters.
    I added the three mint location data (currently including the production numbers from each of those mint sites).

    Here is what MY information form looks like.


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

  27. #67
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    @tech Thanks for jumping in. But, if you look at their first posting of his project, there were very few lines of code....95% was all about their menu system. I took their code and wrote many, many lines for them. I gave them the loading of data from their database (skimpy as it was at the time), and added functionality after functionality that they wanted. As I progressed to assist, I became more aware of the complexity of how they set up their menu, their database, as well as confused about why all those forms they created (I use 2).

    Now, that having been said, I am still willing to 'collaborate' if they desire. What I mean, is I will help them with their project, OR, as I did state earlier, I would send them my project if they wanted it. Ya know, a lot of folks here, like me, know very little about coding in VB6. But, I try to help them LEARN with the limited knowledge that I have. I don't MIND writing these simple projects for them, but in general, I like to offer advice (what little I can) to help them LEARN how to code instead of, like many, who just come to this forum to copy-paste from others.

    @OP---are you in this project to LEARN or do you simply want a project to pass on to your sister? If the latter, I will post mine in the future. However, if the former, please continue to try to complete your project, and ask for help when you get stuck. Sound fari?

    EDIT: that word should be 'fair'. The VB6 IDE would have thrown an error if that mistake had been in code, but this forum doesn't seem to automatically use spell check===="The person who invented autocorrect has died. The funnel will be tomato." :-)

    Respectfully,

    Samuel Oscar Brown (an alias, however...most of you know this!)
    Last edited by SamOscarBrown; Jun 12th, 2024 at 08:08 AM.
    Sam I am (as well as Confused at times).

  28. #68
    Super Moderator Shaggy Hiker's Avatar
    Join Date
    Aug 2002
    Location
    Idaho
    Posts
    39,837

    Re: Ok, DB connection.. What gives?

    Heck, I have the old school version: A book with slots for quarters from each state and mint combo. I'm not sure what the point of a DB is, considering you can populate it with so little effort. I don't understand the book, either (it was given to me, already filled out), but it takes some real effort to collect all the coins. It was Pokemon Go before Pokemon Went. Now I have a book full of quarters, somewhere.

    This is not a new or original idea, and can't be sold as such. Work on it together, work on it separate, but it is only what it is.
    My usual boring signature: Nothing

  29. #69

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    @Sam

    #66

    Referring to the image.. Some quarters/coins do NOT have all 3 mints AND some quarters/coins do not a have mint mark - (which would be "B" for blank OR "P" for a proof and some actually have 4 or all 5 fields. So, is each coin going to have 4 fields instead of the 3 you currently have? Also, are those fields such as value, count, etc.. editable or are you just calling the info from the DB?

    Last thing on the image that I see, is that yer coin images are actually "Proof" images and not the actual CIRCULATED/UNCIRCULATED coin images. Those ARE actual coins, but those you would buy from a dealer or from a mint or catalog/online purchase. Those were never minted and put into circulation, hence why they are PROOFS. I'm not saying that somewhere along the line some people have bought them and then used them and those few coins didn't switch hands). They just weren't meant to be circulated but still legal tender. Rare to come across in general without actually buying them tho.
    Last edited by Mongoose_MHS; Jun 12th, 2024 at 06:08 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  30. #70
    PowerPoster
    Join Date
    Nov 2017
    Posts
    3,515

    Re: Ok, DB connection.. What gives?

    Quote Originally Posted by Mongoose_MHS View Post
    @Sam

    #66

    Referring to the image.. Some quarters/coins do NOT have all 3 mints AND some quarters/coins do not a have mint mark - (which would be "B" for blank OR "P" for a proof and some actually have 4 or all 5 fields. So, is each coin going to have 4 fields instead of the 3 you currently have? Also, are those fields such as value, count, etc.. editable or are you just calling the info from the DB?

    Last thing on the image that I see, is that yer coin images are actually "Proof" images and not the actual CIRCULATED/UNCIRCULATED coin images. Those ARE actual coins, but those you would buy from a dealer or from a mint or catalog/online purchase. Those were never minted and put into circulation, hence why they are PROOFS. I'm not saying that somewhere along the line some people have bought them and then used them and those few coins didn't switch hands). They just weren't meant to be circulated but still legal tender. Rare to come across in general without actually buying them tho.
    I would recommend against using P for Proof and B for a blank mint mark. A blank mint mark almost always (or perhaps always) means that it was minted in Philadelphia, which to me would appropriately have a database documented mint mark of P.

    If I were designing this, I would have two fields - a field for mint mark, and a yes/no field for proof.

  31. #71

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    NOT always and that's a fact! Denver has definately minted blank mint mark and San Francisco has minted very little but has done it as well on very rare occassions. Depending on the quantity and demand as well as the specific coin. Again, "PROOF" coins have a certain color design as shown in #66. Also we haven't even gotten to the silver outer and gold centered quarters/coins OR all the fancy multi colored quarters.. The DB will be very big/extensive to accomplish this project. This is NOT a so "simple" project if one really wants to go that far. I was just trying to make a simple project for my little sister.. However, I do not know how far she will go with her collecting. There is just so many things that can go into this and again, the DB will not be small by any means nor will all the coin images to be displayed will be a small project in itself.
    Last edited by Mongoose_MHS; Jun 12th, 2024 at 07:20 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  32. #72

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    You "could" do "PR" OR "PF" for a proof.. I would STRONGLY using the "B" for blank for the simple reason, without some serious research for every coin as to where it was minted one will never know. So, "B" for blank just makes sense as well as it just makes easier for the end user to select. Not everybody is that knowledgeable or wants to invest in that kind of time. They just know what they have in their collection just simply trying to collect. So, if someone has 4 all 5 of the same coin.. D,P,S,B, PR - They really won't go looking for where or why there is no mint mark. They just know they have it. Tho, the PROOF is very distinctive as for it's colors as I have already mentioned.

    But then, here starts another thing.. WHERE was the PROOF minted? Back to where we just started....
    Last edited by Mongoose_MHS; Jun 12th, 2024 at 06:55 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

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

    Re: Ok, DB connection.. What gives?

    I am not sure where you (mongy) are getting your information...probably from some expert coin collector (which I am not). HOWEVER, what I found that indeed all those coins (Women, State, and US Park ARE minted at Denver, Philadelphia AND San Francisco. Maybe there are some unmarked ones (I really don't care).

    And THAT having been said, I am going to attach my program...you can look at it, use, modify it, 'steal' from it, or delete it...don't care. BUT, in it you will see quantities for ALL those coins from each of the three places I mentioned in the paragraph above. I also did a quick 'my collection' form which summarizes all those that I might currently have in my collection. I have images for all those coins as well. But, who cares. Throw it away if you want...I really don't care.

    If you need to have "B" codes, that is fine, but all proofs come from SF as far as I could tell, hence the mint "S".

    Outa here.

    EDIT...actually, the zip must be too big (with all those images) to upload...sorry. Have fun with your program.
    Sam I am (as well as Confused at times).

  34. #74

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    can always can do 2 zips..

    Also, like I said NOT always true... Just as YOU just stated that YOU read SF and optionbase1 says:
    A blank mint mark almost always (or perhaps always) means that it was minted in Philadelphia
    Am I only one really doing research for the program?
    Outa here.
    yep, I thought you would say that when someone is right.. tho you said you willing to help with mine and share yers.. So, steal my idea and turn yer back when i'm just pointing out facts and you don't wann go that far into detail with the program.. Yet, you say it has potential and what not.. but refuse to listen to me.
    Last edited by Mongoose_MHS; Jun 12th, 2024 at 09:26 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  35. #75
    PowerPoster
    Join Date
    Nov 2017
    Posts
    3,515

    Re: Ok, DB connection.. What gives?

    A blank mint mark almost always means that a coin was minted in Philadelphia. Whether or not Philadelphia minted coins are marked with a P or not varies. For example, wheat pennies minted in Philadelphia have no mint mark. For the first 30 years, Jefferson nickels (with the exception of war nickels minted from 1942 through 1945) that were minted in Philadelphia have no mint mark.
    Last edited by OptionBase1; Jun 12th, 2024 at 09:45 PM.

  36. #76

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Quote Originally Posted by OptionBase1 View Post
    A blank mint mark almost always means that a coin was minted in Philadelphia.
    ALMOST.. but not always! As I have mentioned before.. I've done my research on it and have contacted a few coin experts both online and in person.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  37. #77
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,539

    Re: Ok, DB connection.. What gives?

    Quarters1.zip
    American Women Images.zip
    US Park Images.zip

    So, yeah......someone once commented that you (mongo) must be a new alias for elRuffsta. I believe that now--if not, you're his brother. SO negative and SO ungrateful! Geez.

    So, here IS my project....you will need to put the two directories AmericanWomen and USParkQuarters under the directory in the first zip (Quarters1) called Images. Hence, you will have a directory called Images with three (unzipped of course) directories under it.

    I really am out of here now...so ungrateful. So negative. Amazing I have hung around this long.

    Maybe if you were nice, maybe someone else will help you with YOUR project (what I attached you can simply throw away---but you can't say I didn't TRY to help.)

    Adios

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

  38. #78

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    I don't know who "elRuffsta" is, nor am I connected to him/her.. I'm in high school so I don't know what you are talking about.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  39. #79

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    I think I have been pretty nice.. I may not go around kissing everyone's ass for something they did for me, However I think I have been nice for the most part thank you very much! I even helped somone on images for their Roulette project.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

  40. #80

    Thread Starter
    Addicted Member Mongoose_MHS's Avatar
    Join Date
    May 2024
    Posts
    187

    Re: Ok, DB connection.. What gives?

    Anyways.. I can't get yours to run:

    method or data not found
    Code:
    Private Sub grid1_Click()
            gCoinYear = grid1.TextMatrix(grid1.Row, 0)
    The other question where did you get those images because every image I get, I have to edit.. Would be nice to not have to, that would save me a lot of time.

    Also, the images are not the same exact size.. I would use the following and make all the images in 1 shot the same size - (just a suggestion):
    https://www.iloveimg.com/resize-image


    Side note: your state quarter images are "PROOF" coins as I said you would have to buy them.. They are not the actual circulated coins everyone gets day to day in change/spending.. Just saying. There is a difference proof VS ciruculate/circulated coins. However, I know you don't care about the specs.. Just mentioning it is all. and this would help you in stop making images stetch value true.. Place an image box, put an image into it so it auto sizes and then delete the image while the box keeps it's size automatically. There is no need at all to have the image box stretch by any means. Sorry, but images is one of my things. I fix personal photos pixel by pixel if need be and all. I don't use special software and all that crap..
    Last edited by Mongoose_MHS; Jun 12th, 2024 at 11:34 PM.
    Monroe High School.. GO HORNETS!

    If I've help you, please add to my reputation level! Each reply has a "STAR" icon followed by: "Rate this post".. click that

Page 2 of 3 FirstFirst 123 LastLast

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