Search results

I have a field that is the primary key and is set up to have no duplicates. How do I get the field (Ink Number) to warn me that the value is a duplicate right after I exit that field and not after I enter all the data and go to enter a new record?

I have some formulas in a form. The formulas are computing square roots. If the result of the formula is a negative number, it gives an error (as a result of the square root calculation). How do I change the formula to tell it to show a zero as the result in the case of an error or negative...

Hi, I am trying to put a label onto my form as a title. The title is FMEA (Failure Mode & Effects Analysis). Can anyone tell me why it won't accept the & symbol? When I switch to form view, I am getting FMEA (Failure Mode_Effects Analysis). Thanks! Summer

Here is my dilemma: I have 2 separate forms - Incoming Test Log and Material Test Requirements. The first has new data entered daily. The second is a reference tool. As new materials are received, they are entered into the "Log". The operator then must open the "Requirments" form to see if...

Hello- I would like to combine the following two IIf expressions: =IIf(IsNull([Due Date]),"No") =IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION") How do I accomplish that? I've tried semi-colons, commas, parentheses... Can anyone help??

I am working on a validation rule. I can't figure out what expression to use. I have a form where you type in an item number and all the details for that item pop up into their respective fields. When an item number that is typed in that does not appear in the database, I'd like to have a...

I set up a command button on my form to duplicate the current record to a new record. The following is the event procedure that it created: Private Sub dup_Click() On Error GoTo Err_dup_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar...

Upon entering data into 1 cell of my form, I am getting the error: Field Cannot Be Updated When I click on the help button it says the field may be locked or being used by another person. BUT, the properties are not set to locked anywhere, and I am the only person who has access to this. Can...

I have 2 cells of data that are driven from a combo box. The table in which the data for the combo box comes from shows the numbers correctly (not rounded), but when I select something in the combo box, it is delivering the results rounded up. My properties are set as: Field Size: Double (I've...

How do I set up an expression in a field saying I want to move to a different field that is not the next field? For example, my form has combo box "Reason Code" which gives a value in "Reason Description". How do I skip over "Reason Description" and go directly to the next cell I need to enter...

I have many fields set up to have a default value of 0. The properties I set up are: Format: Standard Decimal Places: 2 Default Value: 0 My problem is that some of the fields aren't showing the 0. I've also tried changing the Format to Fixed and General. Is there anything I can do? I need...

I have a combo box that after I enter the data it returns a value to another cell. The following is the code I am using and it is working fine... Private Sub new_record_Click() On Error GoTo Err_new_record_Click DoCmd.GoToRecord , , acNewRec Exit_new_record_Click: Exit Sub...

Here is my question... 3 fields in my form are Out, In, and Grams Ink Used (which is a formula). I enter numbers into Out and In and that gives me my number in Grams Ink Used. How do I get the data in the Grams Ink Used cell to also appear in my table? All three are fields in the table, but...

Hi, I have 2 fields that relate to one another, Part Number and Item Number. When I type in the part number, I would like the item number to "pop" in automatically in it's field. How do I do that? Thanks!

Here is my situation. I am creating a form in a new database. The database is for debits. One debit check may have 1 to 90 parts associated with it. We are going to start logging these into a database. The first 5 fields (MRA#, CK#, Customer#, Invoice#, and Debit Amount) may have to be...

I have database that tracks calibration due dates. The formula I am using in the report to show whether a device is out of calibration is: =IIf([Due Date]>Now(),"OK","OUT OF CALIBRATION") The result of this formula gives the value in my “Status” column. Here's what I want to do. I need to add...

I have a database that lists test requirements for certain materials. Here's what I want to do. I want to set up a form where I can type in the material number, hit enter (or a command button [macro?])and have the form automatically display the test requirements. Can anyone help me?

I am trying to set up some formulas in a form I have created. I need to do a formula for standard deviation. I've been trying to use the expression builder, but it's confusing. I've selected StdDev, but I'm not sure how to enter my info. Can anyone help and show me examples?