Filtration problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • darrel
    New Member
    • Nov 2006
    • 72

    #1

    Filtration problem

    hi vb wizards, just wanna ask sumthing i have a database created in access, with diffirent primary id, now i want to know how can i able to filter those data from my database, its like i have 30 records consists of different id, the first has the letter "a" on the first character, the second 10 has letter "b" and last 10 has letter "c", the question is how will i able to filter it if i only want to view the database that has the letter "a" on its id and display it on a labels ,, using adodc in visual basic 6. i hope somebody can help on its, my graduation will depend on this project.. please help me...!!! thank you in advance, any help will be a great help for me.....
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by darrel
    hi vb wizards, just wanna ask sumthing i have a database created in access, with diffirent primary id, now i want to know how can i able to filter those data from my database, its like i have 30 records consists of different id, the first has the letter "a" on the first character, the second 10 has letter "b" and last 10 has letter "c", the question is how will i able to filter it if i only want to view the database that has the letter "a" on its id and display it on a labels ,, using adodc in visual basic 6. i hope somebody can help on its, my graduation will depend on this project.. please help me...!!! thank you in advance, any help will be a great help for me.....
    I'm not familiar with the use of filters, but the SQL expression to limit the records in this way would be something along the lines of PrimaryId Like "a*".

    Comment

    • darrel
      New Member
      • Nov 2006
      • 72

      #3
      thanks you for that, can you give the whole syntax of that query,,, am not very familiar in SQL language, but ithink it will work... thank you for the idea...

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Originally posted by darrel
        thanks you for that, can you give the whole syntax of that query,,, am not very familiar in SQL language, but ithink it will work... thank you for the idea...
        Well, the simplest version would be...

        Select * From TableName Where PrimaryID Like "a*"

        Note, I'm not sure whether you need to use single or double quotes (' or ").

        For more information on SQL, I'd advise you tel check out the Access forum. Especially the" Tutorials and Code Samples" item near the top.

        Comment

        • darrel
          New Member
          • Nov 2006
          • 72

          #5
          thank you from the advise. i have a code its like this:

          if cboSem.text = "1st Sem" and cboCourse.text = "BS.Tourism " then
          SELECT * From dbTimeSchedule. mdb WHERE PrimaryID Like "T0101*"

          For i = 1 to __________
          label1 to 10.caption = ______
          "this is the area where all records must be placed".

          Next
          end if


          My problem is i dont know what will i do, i dont know how, its like this i have a total of 14 labels, and the record of the said condition is only ten, so want i wanted to do that i can hide the rest of the labels that is not neccessary needed for a specific records. i hope you can help i badly need some ideas and help.

          Thank you hoping for your reply!

          Comment

          Working...