Search results

  1. S

    Check for an existing record and add if it doesn't exist

    I think I got it I changed the statement from: Dim rs AS DAO.Recordset to Dim rs AS Object This took care of the problem
  2. S

    Check for an existing record and add if it doesn't exist

    tried it, Access hates DAO Scott, I decided that the user will hae to give just a little on this project. So I incorporated the form and the code into the project. When testing this, it stops at the line: Dim rs AS DAO.Recordset Access 2000 apparently hates DAO. How can I recode this or...
  3. S

    Check for an existing record and add if it doesn't exist

    check for existing record Scott, Thanks for the reply. This would work except I am needing for the user to be able to enter the phone number in the phone number field in the form, then check for an existing record and bring up the record if it exists. If it doesn't then allow the user to add...
  4. S

    Check for an existing record and add if it doesn't exist

    I am working on an Access 2000 database in which I need to be able to verify that a record exists when the user enters the phone number (this is the first field and the Key). If it does exist, I need the record to be the current record for the user to view. If it doesn't exist I need it to...
  5. S

    Option group question

    When I select the first option button and check the properties I have no option of "on click". If I select the page tab there is one. I need to enter the coding on the option button, correct?
  6. S

    Option group question

    I have a main form that contains an option box that has eight options. There are 9 page tabs that are subforms within this main form. The options are labled to correspond to the 9 page tabs in the subform. My goal is to allow the user to select one of the options and the corresponding page be...
  7. S

    Auto Fill Forms with existing data

    I have a Main form that includes a couple of subforms. When the user enters a specific key number I would like the description of the key to automatically be filled in. I have a separate table created that holds the information of the key number and the description to the specific key number...
Back
Top Bottom