Results 1 to 5 of 5

Thread: Main Form

  1. #1
    Join Date
    Oct 2007
    Posts
    3

    Unanswered: Main Form

    hello i want to ask a question about one problem i have.
    I have a form with contacts and i want tha main form , " it is the only form tha i created" i want to open again and again many times at the same time. it is like when you open my computer many times for example. i don't know very much about this can anyone help me?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Code attributed to Allen Browne - http://allenbrowne.com/ser-35.html
    Code:
    Dim frmMulti As Form
    Private Sub cmdNewInstance_Click()
        Set frmMulti = New Form_frmClient
        frmMulti.SetFocus
    End Sub
    George
    Home | Blog

  3. #3
    Join Date
    Oct 2007
    Posts
    3
    now i have another problem the thing is i have a search button in database and the thing is when i put in the text field my search for example Nick and press the button search it's found the record but if i put NiCK does not show me the record.
    The thing is that if i create a new database doesn't do it this problem can anyone help me ?

  4. #4
    Join Date
    Oct 2007
    Location
    Washington D.C.
    Posts
    24
    Quote Originally Posted by Dark_Emperor
    now i have another problem the thing is i have a search button in database and the thing is when i put in the text field my search for example Nick and press the button search it's found the record but if i put NiCK does not show me the record.
    The thing is that if i create a new database doesn't do it this problem can anyone help me ?


    Is the "Match Case" box checked?

    That would make your search case-sensitive, and as such would only return your result if and only if it was typed exactly as found in the database.

    -Friz
    Last edited by Friz; 10-22-07 at 20:18.

  5. #5
    Join Date
    Oct 2007
    Location
    Washington D.C.
    Posts
    24
    ... or, if you're doing this in VBA, it would be the second optional parameter under the DoCmd.FindRecord property

    FindRecord(FindWhat,[Match As AcFindMatch=acEntire],[MatchCase],....

    -Friz

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •