Search results

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

pdx_man, Thanks for your help! summer

customize error message? Well wasn't that simple! Thanks for your help. Is there a way to customize the error message?

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

David, This is working great! You were right about the debit amount field - it is the sum of the costs. I put an unbound text box on the form to calculate this amount. For the control source I have: =Sum([Subtable Subform].Form!Cost) My result is #Error. Am I doing something wrong?

WOW! Thanks for the great information. I'll give it a try and report back to you. Thanks again! Your help is much appreciated!

Here's the situation... We get a debit from a customer. We have to enter these onto a spreadsheet (which I am re-creating to a database). Fields are MRA, CK#, Cust#, Invoice#, Debit Amount, Date, Part Number, Item Number, Qty, Cost, and DMR#. The debit will usually have many part numbers...

When I put PartNumber.SetFocus in the string, I get an error that says Object Required. If I put Me.PartNumber.SetFocus I get Compile Error: Method or data member not found. Any ideas?

I have 11 fields. The first 6 may be the same in the next record. So the easiest way I could figure to copy those 6 to the next was to put a duplicate command button. Then, the 7th field, Part Number, is where the data may change, so I want the cursor there. I'll try what you both suggested...

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

It is based on a table field.

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

Well, the weird thing is, is that it was working fine when I first created it, then the next day, it started to round the numbers!

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

Thanks for your help!

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 think I'm getting somewhere. The fields that are not showing the default value are linked to combo boxes. Sometimes, the combo box may not be selected. The following is my expression: Private Sub Combo166_AfterUpdate() Me.LBS_GAL10 = Me.Combo166.Column(1) DoCmd.RunCommand acCmdRefresh End...

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

David, Your advice helped alot. Everything is working great now. Thanks alot! Summer

This is weird. I opened the query and clicked off of the Totals button. Now I can enter data. I will now try your suggestion.