connecting to ms access with vb6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dököll
    Recognized Expert Top Contributor
    • Nov 2006
    • 2379

    #31
    I forgot to tell you what to put into About. We want to make Text1 your search field. If you already added something in and you know what it is, forget about the below reply to this post. Or else, add data in the following fashion:

    (1) In Text1, Type 1234 (This goes to UserID field in Access table called Yodamania)

    (2) In Text2, Type Yoda Friend (This goes to Name field in Access table called Yodamania)


    (3) In Text3, Type 12 Bolt Court, Utah (This goes to Address field in Access table called Yodamania)


    (4) In Text4, Type 301-555-5544 (This goes to Phone field in Access table called Yodamania)


    (5) In Text5, Type Yoda@FeelGoodNe t.org (This goes to Email field in Access table called Yodamania)

    Add additional data to reflect different UserID numbers like, 1235, 1236, then add other specific data to each so each name, address, etc, is distinguished.

    You tell me how this works out Yoda, then we'll move on to retrieving this data.

    In a bit!

    Dököll

    Comment

    • yoda
      Contributor
      • Dec 2006
      • 291

      #32
      thanks i'll try out te code.

      yoda

      Comment

      • yoda
        Contributor
        • Dec 2006
        • 291

        #33
        any sry but tht didn't work i there and can u a explain wat about is and how to do it ur confuseing me or we could do it the easy way and wat ever they put in the text box's goes to a txt document like note pad or something i just want this to work.

        Yoda thanks for the help so far. :)

        Comment

        • Dököll
          Recognized Expert Top Contributor
          • Nov 2006
          • 2379

          #34
          No worrries mate...Let's try again.

          Questions:

          (1) Is your Splash Screen working?

          (2) Is your Login form working?

          (3) Do you have a form with 5 Textboxes?

          (4) What is the name of that form?

          Send me answers to the above questions and we will work around that, ok, no problem :-)

          Comment

          • yoda
            Contributor
            • Dec 2006
            • 291

            #35
            Originally posted by Dököll
            No worrries mate...Let's try again.

            Questions:

            (1) Is your Splash Screen working?

            (2) Is your Login form working?

            (3) Do you have a form with 5 Textboxes?

            (4) What is the name of that form?

            Send me answers to the above questions and we will work around that, ok, no problem :-)
            1) i don't know wat a splash sceeen is.

            2) yes i think when u mean it shows up until the code is wrong.

            3) yes but wat if i only wanted 2 text box's User id and password

            4)the form is loginfrm.frm

            Comment

            • Dököll
              Recognized Expert Top Contributor
              • Nov 2006
              • 2379

              #36
              We're off to good start Yoda :-)

              Thanks for letting me know what you have going, this is good. Now what answer the following questions:

              (1) Is loginfrm.frm the only form you have?
              (2) Do you have buttons on this form?
              (3) How many buttons?
              (4) What are they called?

              Answer the above and we'll continue, good job...

              Dököll

              Comment

              • yoda
                Contributor
                • Dec 2006
                • 291

                #37
                Originally posted by Dököll
                We're off to good start Yoda :-)

                Thanks for letting me know what you have going, this is good. Now what answer the following questions:

                (1) Is loginfrm.frm the only form you have?
                (2) Do you have buttons on this form?
                (3) How many buttons?
                (4) What are they called?

                Answer the above and we'll continue, good job...

                Dököll
                1) loginfrm is the only form

                2) yes i have buttons

                3) i have 2 buttons

                4) the first one is "ok" the second one is "cancel"

                Comment

                • Dököll
                  Recognized Expert Top Contributor
                  • Nov 2006
                  • 2379

                  #38
                  Fantastic...

                  (1)Can you go to the properties of these buttons?

                  (2)Is the ok button called command1 in its properties window?

                  (3)Is the cancel button called command2 in its properties window?

                  (4)If you named the buttons yourself, tell me the names that are showing for each?

                  Answer the above and we can go on...Good job Yoda...
                  Last edited by Dököll; Mar 10 '07, 03:41 AM. Reason: error

                  Comment

                  • yoda
                    Contributor
                    • Dec 2006
                    • 291

                    #39
                    Originally posted by Dököll
                    Fantastic...

                    (1)Can you go to the properties of these buttons?

                    (2)Is the ok button called command1 in its properties window?

                    (3)Is the cancel button called command2 in its properties window?

                    (4)If you named the buttons yourself, tell me the names that are showing for each?

                    Answer the above and we can go on...Good job Yoda...
                    1) yes if the porperties are on the side, of vb.60

                    2)the button is called on the form "ok" but in porperties it is called "cmdOK"

                    3) the button is called on the form "cancel" but in porperties it is called "cmdCancel" .

                    4) the buttoms on the form are called OK and Cancel

                    Comment

                    • willakawill
                      Top Contributor
                      • Oct 2006
                      • 1646

                      #40
                      Originally posted by Dököll
                      Fantastic...

                      (1)Can you go to the properties of these buttons?

                      (2)Is the ok button called command1 in its properties window?

                      (3)Is the cancel button called command2 in its properties window?

                      (4)If you named the buttons yourself, tell me the names that are showing for each?

                      Answer the above and we can go on...Good job Yoda...
                      I warned you about this way back on the first page. What I am curious about is this: are you going to do a complete programming tutorial for everyone who asks this question? There are tutorials out there on the web. It makes sense to point people in the right direction. It is not efficient to spend this much time tutoring one person. Of course, as long as it is not an assignment, you can choose to spend your time as you wish :)

                      Comment

                      • yoda
                        Contributor
                        • Dec 2006
                        • 291

                        #41
                        Originally posted by willakawill
                        I warned you about this way back on the first page. What I am curious about is this: are you going to do a complete programming tutorial for everyone who asks this question? There are tutorials out there on the web. It makes sense to point people in the right direction. It is not efficient to spend this much time tutoring one person. Of course, as long as it is not an assignment, you can choose to spend your time as you wish :)
                        he's just trying to help and the tutorial wasn't much help the 1 u gave me, but this is not assignment so don't stop him i need his help cause i'm really new to access and VB.

                        Yoda :)

                        Comment

                        • Dököll
                          Recognized Expert Top Contributor
                          • Nov 2006
                          • 2379

                          #42
                          You are so nice, WillAkaWill, thank you for your thoughts...

                          No, I am not going to do a complete tutorial for everyone; though I did intend to at some point. And to tell you the truth, I think of this site as a global tutorial-friendly site. If one could search right, answers to a number of FAQs would be found. Indeed, a direction to the right/solid source is just and helpful, especially in the case one is just passing through, but hints to likely/right away solutions would make waves for someone in dire need. I have learned to separate from posts that are just to shoot the breeze. With Yoda, we can achieve something. I have a hint, we'll have this one nailed, perhaps learn something, tips and tricks, a treat, something in that kind of a line...It sounds like I have your blessing to continue, hopefully Yoda is here for the long hall :-)

                          Comment

                          • willakawill
                            Top Contributor
                            • Oct 2006
                            • 1646

                            #43
                            You don't need any blessing from me. Post whatever you wish. It is not my business. I haven't read the posts on this thread after the first page. I just noticed that you had reached 4 pages and thought that, perhaps, you may have felt obliged to continue. Post away my friend :)

                            Comment

                            • Dököll
                              Recognized Expert Top Contributor
                              • Nov 2006
                              • 2379

                              #44
                              Blessing is far beyond what I hope to gather, just applauding the fact that you wish I continue if I so choose. You're a kind person, I'll stop spreading rumors :-)

                              Comment

                              • Dököll
                                Recognized Expert Top Contributor
                                • Nov 2006
                                • 2379

                                #45
                                Where are you Yoda? You have yet to respond to my previous post good buddy...

                                Comment

                                Working...