Results 1 to 3 of 3

Thread: quary to form

  1. #1
    Join Date
    Jul 2002
    Posts
    2

    Talking Unanswered: quary to form

    I want to make a window(form) in access that can serach a phone nuber for me in phone directory i try quarty but my information in access 2000 is poor ,,,, please can any buddy help me in faster time and second thing I need online access 2000 or xp tutorial but it should be full not interoduction
    thanks for all

  2. #2
    Join Date
    Jun 2002
    Posts
    33
    First of all you need a form with this controls:
    Text Box where you write the name of that person from who want the phone number
    Button
    Onclick event of that button you place the following code:
    Dim strSQL as String
    strSQL="select * from PhoneBook where Name=' " & Me.TextBox.Value & " ' "
    DoCmd.OpenForm "Form1",strSQL

    You have to look in your help for the last command. I don't remember very well the syntax
    Now, that form Form1 will have as DataSource the table containing the phone numbers

    If you more details just give me a sign

    Bye
    PacuIonut

  3. #3
    Join Date
    Jun 2002
    Posts
    33
    First of all you need a form with this controls:
    Text Box where you write the name of that person from who want the phone number
    Button
    Onclick event of that button you place the following code:
    Dim strSQL as String
    strSQL="select * from PhoneBook where Name=' " & Me.TextBox.Value & " ' "
    DoCmd.OpenForm "Form1",strSQL

    You have to look in your help for the last command. I don't remember very well the syntax
    Now, that form Form1 will have as DataSource the table containing the phone numbers

    If you more details just give me a sign

    Bye
    PacuIonut

Posting Permissions

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