Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

match

Discussion in 'Information Technology' started by Chey, Jul 28, 2006.

Tags:
  1. Chey

    Chey
    Expand Collapse
    Guest

    I have a combo box with a list of months-text
    I alos have date field that only shows month. When the form opens I want
    the two fields to match. However I have one in a date field and one in a
    text field. I don't know what to do. When I choose my month from the combo
    box, it filters my form. I would like for it to do that. The current code I
    have is
    Private Sub Combo87_AfterUpdate()
    Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    Me.FilterOn = True

    End Sub

    tblGrantCompletion.theMonth is a text field. I can not at this time change
    it to a date field. I gives me error messages and won't perform the task.
    Thanks
     
  2. Loading...

    Similar Threads Forum Date
    GurmatChanan Updates Gurbani Download Aug 27, 2011
    India Manmohan invites Zardari, Gilani for India-Pakistan match Breaking News Mar 26, 2011
    Harbhajan hits his maiden test century,saves match for India Sports & Fitness Nov 9, 2010
    Arranged marriage? Or Love-match? Insights, Prospects for the future Love & Marriage Oct 11, 2010
    Wimbledon tennis epic ends in games (183 of them), set and match Sports & Fitness Jun 26, 2010

  3. default105

    default105
    Expand Collapse
    Guest

    try
    Private Sub Combo87_AfterUpdate()
    Me.Filter = "[tblGrantCompletion.theMonth] = #" & Me.Combo87 & "#"
    Me.FilterOn = True


    "Chey" wrote:

    > I have a combo box with a list of months-text
    > I alos have date field that only shows month. When the form opens I want
    > the two fields to match. However I have one in a date field and one in a
    > text field. I don't know what to do. When I choose my month from the combo
    > box, it filters my form. I would like for it to do that. The current code I
    > have is
    > Private Sub Combo87_AfterUpdate()
    > Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    > Me.FilterOn = True
    >
    > End Sub
    >
    > tblGrantCompletion.theMonth is a text field. I can not at this time change
    > it to a date field. I gives me error messages and won't perform the task.
    > Thanks
     
  4. Chey

    Chey
    Expand Collapse
    Guest

    I tired this and nothing happened. I actually want it to go under on open.
    So the drop down box will choose the month that matches my date field, and
    filter I want to leave the combo box alown when it comes to the filtering
    part. I still want to be able to choose a different month and it filter. I
    use the months to log in billing forms. That is why I would like to match my
    date field. I have it formated to make the current billing month visiable.
    Thanks

    "default105" wrote:

    > try
    > Private Sub Combo87_AfterUpdate()
    > Me.Filter = "[tblGrantCompletion.theMonth] = #" & Me.Combo87 & "#"
    > Me.FilterOn = True
    >
    >
    > "Chey" wrote:
    >
    > > I have a combo box with a list of months-text
    > > I alos have date field that only shows month. When the form opens I want
    > > the two fields to match. However I have one in a date field and one in a
    > > text field. I don't know what to do. When I choose my month from the combo
    > > box, it filters my form. I would like for it to do that. The current code I
    > > have is
    > > Private Sub Combo87_AfterUpdate()
    > > Me.Filter = "[tblGrantCompletion.theMonth] = '" & Me.Combo87 & "'"
    > > Me.FilterOn = True
    > >
    > > End Sub
    > >
    > > tblGrantCompletion.theMonth is a text field. I can not at this time change
    > > it to a date field. I gives me error messages and won't perform the task.
    > > Thanks
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page