Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: automatic updates

    well as I get further into this project of automatic updates I'm fining more and more barriers. The combo list box which indicates whether the employee is terminated or active might be a problem with sql since you cant create a Row source and a Row source type in a sql table. that combo box exsist in the properties of the form. The Row Source Type is a Value List. Shoot

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I guess I don't understand why this is a deal-breaker. You can:

    A) Change your combo-box row source type to a query.

    B) Use VB Code to set the Row Source to the results of a query.

    C) If you know there are limited possible values for the field (Active, Terminated) then leave it hard-coded in the interface and just perform error checking before you insert data into the database.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Thumbs up sorry

    Ok blindman I'm sorry but I dont know VB code so for me that is a deal breaker. Please explain error checking, I will read about it I have booksonline to refer to.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Are your dealing with an Access interface? Adding VB code to an Access module is very easy.

    By error checking, I just mean that the database should verify that the submitted data is an acceptable value, and should return an error message if it is not.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    rowsource

    I tried that but thats not an option, but I figured it out I'm good thanks

Posting Permissions

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