Search results

In AfterUpdate event, do an event procedure: YourComboBox_AfterUpdate() Me.FieldName = Me.YourComboBox.Column(1) For example, I have a form that does the following: Private Sub Combo64_AfterUpdate() Me.LBS_GAL = Me.Combo64.Column(1) Me.LBS_VOC = Me.Combo64.Column(2) End Sub After I enter...

I think I'm confusing myself... I thought the combo box solved my problem, it didn't. Does anyone have a suggestion on what I can do?

I just decided to make it a combo box. That is giving me what I want.

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?

Thank you all for your help! The formula in my form is working now. In addition to using the formula given by Crosmill and changing my number format to General Number made it work. (I'm not sure what the number thing was, but all of a sudden when I changed it, it worked!) Thanks a bunch!!! Summer

OK, OK...I'm working through this. Here's what I need. I need this to show a zero if my result is a negative number, not if the number is less than one. Any suggestions???????

This is what I did: =IIf(5.15*(Sqr([Text1135]))>1,5.15*(Sqr([Text1135])),0) The formula seems OK, but I'm still getting an error. Because the formula is squaring a negative number, it is giving an error as the result should. I don't know if I could get around this. Should I be asking this...

Which property should I put that code in? Or should I fit it into my formula? I'm not very good at this. The following is my formula if that helps: =5.15*(Sqr([Text1135]))

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

Thanks for the info Bob! There is so much to learn with this program!

Now wasn't that simple! Thank you!!!

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

Does anyone know how to clear up this Run-time error?

Rob, I set up the combobox as you suggested. Now my Afterupdate event looks like this: Private Sub Combo40_AfterUpdate() Dim i As Integer i = Me!Combo40 If DLookup("[Test Required]", "[rawmateriallist]", "[Material Number]=" & i) = Yes Then MsgBox "This material requires testing."...

I tried setting it up as a combo box in both, and I'm getting the same error. Can anyone help?

Actaully, in the "Log" it is not a combo box, but in the "Requirements" it is.

Thanks for the tip. Now I'm getting Run-time error '6': Overflow When I click debug, it goes to the same Me! statement. I clicked on help to understand what that means, but don't understand what I did wrong. Any ideas? I appreciate your help!

Here's what I did with your suggestion: Private Sub MATERIAL_NUMBER_AfterUpdate() Dim i As Integer i = Me!MaterialNumber If DLookup("[No Test Required]", "[rawmateriallist]", "[rawmateriallist id]=" & i) = Yes Then MsgBox "This material requires testing.", vbOKOnly Else MsgBox "This material...

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

Now wasn't that easy... Thank you Newman!