Welcome to SPN

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

Sign Up Now!

Set focus

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

Tags:
  1. Chey

    Chey
    Expand Collapse
    Guest

    Hello,
    I have a combo box with a list of the month and year in it. This is a text
    field. So I don't know if this will work.
    I would like it to go to the current month and year. I have tried turning
    this field into a Date field and have not been sucessful. I hope you can
    still help.
    Thanks
    Chey
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Settlement Leads To Peaceful Transition At Sikh Temple Breaking News Sep 10, 2016
    Sikhi Langar-Aid - Sikhs Have Set Up A 'Langar' In The ISIS Territory of Syria To Feed Refugees Sikh Sikhi Sikhism Oct 31, 2015
    A set back or a step forward Blogs Oct 17, 2015
    USA Sikh Cartoonist Sets Out To Fight Racial Bias Breaking News Mar 9, 2015
    India Who says we have skeletons only in our closets? Breaking News Aug 22, 2014

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi

    There are many way to do this

    You can either add a second column to the combo and next to each month put
    the number - Jan = 1, Feb = 2, Mar = 3, etc. Then sort the combo by this

    Or

    Create the combo from a date field and set the combo's format to mmmm yyyy

    Or

    Create a table called month add an ID field (auto number) and then insert
    the months in order Jan, Feb, Mar etc. Then base your combo on this

    Ect,

    Etc


    You need to have the combo

    --
    Wayne




    "Chey" wrote:

    > Hello,
    > I have a combo box with a list of the month and year in it. This is a text
    > field. So I don't know if this will work.
    > I would like it to go to the current month and year. I have tried turning
    > this field into a Date field and have not been sucessful. I hope you can
    > still help.
    > Thanks
    > Chey
     
  4. Chey

    Chey
    Expand Collapse
    Guest

    Okay I don't know how I should ask this part so I will try by best.
    When I choose my month and year, it filters my form. Which method below
    would still allow me to filter my form properly?

    "Wayne-I-M" wrote:

    > Hi
    >
    > There are many way to do this
    >
    > You can either add a second column to the combo and next to each month put
    > the number - Jan = 1, Feb = 2, Mar = 3, etc. Then sort the combo by this
    >
    > Or
    >
    > Create the combo from a date field and set the combo's format to mmmm yyyy
    >
    > Or
    >
    > Create a table called month add an ID field (auto number) and then insert
    > the months in order Jan, Feb, Mar etc. Then base your combo on this
    >
    > Ect,
    >
    > Etc
    >
    >
    > You need to have the combo
    >
    > --
    > Wayne
    >
    >
    >
    >
    > "Chey" wrote:
    >
    > > Hello,
    > > I have a combo box with a list of the month and year in it. This is a text
    > > field. So I don't know if this will work.
    > > I would like it to go to the current month and year. I have tried turning
    > > this field into a Date field and have not been sucessful. I hope you can
    > > still help.
    > > Thanks
    > > Chey
     

Share This Page