Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Access '07 require field if other field

Comment:

I'm trying to create a db in office '07 for man hour accounting. Upon closing a job order I want to make sure that the Date Completed and Hours fields are filled in. So when somebody sets a combo box labeled "Status" to "Completed" I want to make the "Date_Completed" and "Man_Hours" fields required. Is there an expression I can set in the validation rules for the Date and Hours to say they are required if Status is completed. I tired and if statement but was unsuccessful at figuring out how to set the field as "required" i.e. if [status]="Completed",[Man_hours]=Required?

Optimize the SQL

how to use the microsoft ...

Summary: Im trying to implement a function in Access 2003 to allow the application to find a given field from a give another field in the same record. e.g. I have a table of Assets called tblAssets, im trying ...

Summary: My first try on a relational database! I created an Access 2003 database with two tables, linked by a one to many relationship. I created a form based on a query with both table details. The form en...

Summary: Hi, I am loading a file into multiple tables using SQL Loader: (a) Format of the File is as follows: H|820020080422|03/27/2008|90.00|90.00 D|99.609|ADLT|1|62.00 So each record starts with 'H' or 'D' (...