Recent content by BSC5905

I’m trying to calculate the length of service of employees by using the DateDiff Function in a query and have the results displayed in a report. The expression that I am using is: Length of Service: DateDiff("yyyy",[tblDA]![HireDate], Now()) The expression works fine and displays in the...

I have created a data base that consists of two tables. The first table is “Table of Employees” which consists of the employee’s personal information. The second table is “Table of Department” which consists of the employee’s company/department information. I created a query based on the...

Is there a way to apply a dual “Input Mask” to a field in a table? The data is the location of employee’s cubes and offices. We use two different formats. The Input Mask that I am using are: >L0-000 - Office location format. >L0-L000 - Cube location format. Example: A2-123 B2-B308 Or could...

In a report I have a field that contains no data because “Allow Zero Length” is set to yes. This I expected. Is there a way on the report or the query which the report is based on to create an expression that will display “N/A” or any other text that I choose to be displayed when there is no...

Sorry for the wrong terminolgy but the 5 features that I listed above are controls on a form. As for the two date controls on the form, “txtCR_SubmittedDate", and "txtCR_ClosureDate" there data types in the uderlying table are set to date/time. So is it posible to calculate the amount of...

I have created a table that consists of 5 fields. Three of the fields are text boxes and the other two are combo boxes. The two text boxes, “txtCR_SubmittedDate” and “txtCR_ClosureDate” are date fields. Listed below are the 5 fields that I mentioned above. txtCR_Number txtCR_SubmittedDate...

I have a table that has three date fields. They are: CR_SubmittedDate CR_RoutingDate CR_ApprovalDate I need assure that when the dates are entered in a text box on a form they meet the following condition: The “CR_SubmittedDate” must be less than or equal to the “CR_RoutingDate”, and the...

I have created a form based on a table. I have added some new fields to the underlying table. I would like to add these new fields to the existing form. Can I do this with out recreating the form?

I am trying to use the Triple State of a Yes/No Check box. When I change the check box Triple State from “No” to “Yes” on the “Data Tab” in form design review, the check box does not work or function properly. The check box will not toggle through its three states. Is there something I need...

What I need to do is to enter 25 Technicians who has been trained on the same Test Method into the same table all at once. I have created a form named “frmTrainingRecords” based on a table called “tblTrainingRecords”to enter the data. The table “tblTrainingRecords” consists of the following...

Is it posible to replace the system error message with a custom define message when ever the primary key is violated? (ie duplicated records)

I am currently running Microsoft Access 2003 and Windows XP. One day all of my command buttons changed shapes. The buttons appearance changed from the smooth round edges to the boxy square edges. Is it something that I inadvertently set to make this happen? If so how do I change them back so...

I created the form but I do not know how to create the combo box and set a filter in the AfterUpdate-event of the combo box. Could you please give me more detail on how to do this. Thank you very much for your assistance.

How do I to create a form based on my qryTrainingRecords. On the form I want to use a lookup combo box which filters the TestMethID. I would also like to add two additional command buttons. One that will allow me to preview the report before printing and one to print the report.

I'm currently building a database to track employees that have been trained on certain test procedures. So that I can track who has been qualified to perform certain test. I have created three tables. They are, Table of Technicians, Table of Test Methods, and Table of Training Records...