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 :(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.|||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.|||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.|||I tried that but thats not an option, but I figured it out I'm good thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment