Search results for query: *

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...

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'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...

Is there away to create a form based on a query. Then add a combo box to filter the the query and then print the results of the filterd data? In other words in the criteria section of the Query design view window, can I create a combo box to use a a filter. Then create a form of the query and...

How do I create an option group where I can select more than 1 option?

In my database I need the user’s to select multiple choices from an Option Group. For example, the Option Group has 30 choices. The operator can chose from 0 to all 30 choices. Once the user has made there selection, I will need to query only the selected data and put it in a report. My...