madujr's Profile User Rating: -----

Reputation: 0 Apprentice
Group:
New Members
Active Posts:
7 (0.01 per day)
Joined:
15-July 12
Profile Views:
276
Last Active:
User is offline Apr 04 2013 07:49 AM
Currently:
Offline

Previous Fields

Dream Kudos:
0
Icon   madujr has not set their status

Posts I've Made

  1. In Topic: How to use vb6 text boxes as parameters for date range in access query

    Posted 3 Apr 2013

    Hi,
    Thanks for responding.
    Can you tell me what is wrong with my statement?
  2. In Topic: Passing vb6 option button value to an access field

    Posted 24 Oct 2012

    Hello everyone.

    I think I found a simpler way to send option button value to an access field. It's through the use of a label as handler of the option button's value which is in "true" state(clicked option button). Then the label control will issue that value it received from the option button to the database with the use of of Data or ADO control.

    Here's the sample code:
    Private Sub Command1_Click()
        If Option1.Value = True Then
            genderLbl = "Male"
        ElseIf Option2.Value = True Then
            genderLbl = "Female"
        End If
        
    Data1.Recordset.Update
        
    End Sub
    
    Private Sub Command2_Click()
        Data1.Recordset.Edit
    End Sub
    
    


    With this code, you no longer need to worry about building a connection between the option buttons and the database. I suspect though that this may tend to be a little slower since your option button does not communicate directly to the database. But it works just fine.

    Hope this is helpful to beginners like me.
  3. In Topic: Passing vb6 option button value to an access field

    Posted 24 Oct 2012

    Yes bob, you're right. stating the error line should be helpful. This is my first post, so that should be a good point to learn. I appreciate that as well as your time with this post.

    Anyway, establishing the ADO connection is really my problem. I'll go and check your reference to try to learn it. I'll be back here if I solve the problem.

    Thanks bob.
  4. In Topic: Passing vb6 option button value to an access field

    Posted 23 Oct 2012

    Maybe I need statement/s that would connect my Option buttons to the database, cause it's not bind to the ADO control. And perhaps some initializations.

    It's what I learned so far from readings several forums.
    Can anybody help me on this?
    Any idea is welcome.

    Thanks.
  5. In Topic: Passing vb6 option button value to an access field

    Posted 23 Oct 2012

    The line after the IF statement generates error.
    myRS.Fields!Gender = "Male"
    and
    myRS.Fields!Gender = "Female"

My Information

Member Title:
New D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

madujr hasn't added any friends yet.

Comments

madujr has no profile comments yet. Why not say hello?