Microsoft Access 2003 SP2 and Visual Basic application

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • stuart wieder
    New Member
    • Jan 2007
    • 11

    Microsoft Access 2003 SP2 and Visual Basic application

    i have an application containing a header with 5 filters (combo boxes) and 2 search boxes (text boxes).
    When the search boxes are used and return no records in the detail of the form, the actual search word in the header becomes invisible, though the text box is still populated with the search data.
    How do i prevent the search data from becoming invisible?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Have you set the listindex of the combo to -1 some where ?

    Comment

    • stuart wieder
      New Member
      • Jan 2007
      • 11

      #3
      Originally posted by debasisdas
      Have you set the listindex of the combo to -1 some where ?
      my problem is with the text boxes used for entering search criteria.
      (in any case i do not see such a setting in the text boxes)

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        What version of VB are you using?

        Comment

        • debasisdas
          Recognized Expert Expert
          • Dec 2006
          • 8119

          #5
          I think you said .......

          Originally posted by stuart wieder
          ............... ..... though the text box is still populated with the search data.

          Comment

          • stuart wieder
            New Member
            • Jan 2007
            • 11

            #6
            Originally posted by debasisdas
            I think you said .......
            i did say that the problem is with the data in the text box that i am using as my search word.

            Comment

            • stuart wieder
              New Member
              • Jan 2007
              • 11

              #7
              Originally posted by Killer42
              What version of VB are you using?
              Visual basic version is 6.3

              Comment

              • Killer42
                Recognized Expert Expert
                • Oct 2006
                • 8429

                #8
                Originally posted by stuart wieder
                Visual basic version is 6.3
                6.3? So that would mean, though you refer to a "Visual Basic application" you are actually using the VBA macro language that's built into Access, correct? Not the standalone Visual Basic development environment.

                It's an important distinction, because while they are very similar, there are differences in the language, and differences in the way the forms and controls work.

                Comment

                • stuart wieder
                  New Member
                  • Jan 2007
                  • 11

                  #9
                  Originally posted by Killer42
                  6.3? So that would mean, though you refer to a "Visual Basic application" you are actually using the VBA macro language that's built into Access, correct? Not the standalone Visual Basic development environment.

                  It's an important distinction, because while they are very similar, there are differences in the language, and differences in the way the forms and controls work.
                  Yes - you are correct

                  Comment

                  Working...