Search results for query: *

I have a table where I enter a part number and quantity to track production. I have a query that contains a description of each part number. I would like to create a form where I enter the date, part number and quantity. However, once the part number is entered, I would like to displace some...

Can I get some help applying this code to my form? Thanks,

I like the idea of taking care of each case. How do I incorporate this code, thank you by the way, into my database? I an basically a novice and could use alittle more help. You really have a clear understanding and from the look of the code, I can understand how it will handle the...

Sorry. =[feet] & "' - " & [inch] & " " & [fraction] & """" I am not sure. I know that the above expression returns the desired result when it is not included in the iif statement. How can I tell? Error is just #error. Thanks.

I want to format a cell to display 6'-6 1/2". The trouble occurs when the fractionportion is zero. I get 6'-6 0". To solve this, I created an IIf statement. =IIf([fraction]=0,[feet] & "' - " & [inch] & """",[feet] & "' - " & [inch] & """") When the fraction is 0, I get the correct output...

Can one field on a form cause the input mask in a second field to change based on the value in the first field? Thanks, Greg

Is there a way to create the extra tables required rather than re enter all of the data?

I have a list of part numbers and varying characteristics of the part in a table. I would like to be able to produce a list of unique part numbers along with the characteristics. I can create a query with a single field part number to determine the unique values of part numbers. As soon as I...

Unfortunatley, I need to be able to input the part number more that one time. What I need is a way that notifies me if the same part number is entered with a different length. Then I could check into the problem and get it corrected.

I have a db that track numerous different part numbers along with the length of each part. It is possible for the same part number and length to be recorded numerous times per job. Both the part number and the length are entered for each record. I accidentally entered the part numer with a...

#Error Is this what you meant?

PHV, I used your suggestion which did eliminate the 0 when the fraction was O. However, when there was a fraction, it reutrns an error message. I cannot see why.

=[feet] & "'-" & [inch] & " " & [fraction] &

Another "challenge" I have run into is with the output. I combined [feet],[inch] and [fraction] to produce 5'-6 1/2". However, when the fraction is 0, my output becomes 5'-6 0" whick is not very desirable. I would love to change the output with a 0 fraction to 5'-6". I cannot get a cndition...

I am taking the feet, inches and fractions and calculating the length in linear feet. Feet+inch/12+fraction/12. I have found if I enter a 0 instead of the letter designation for the fraction, the zero value does work.

I cleaned up the code and things are working well. I have one more issue. I used eval to convert the fraction into the decimal equivalent. However, when there is no fraction, the field is null. I have converted the null field into a 0 for calculation purposes but when I try and use the 0, I...

I have gotten the code to work so when I enter a letter, the proper fraction is displayed. I am not sure how to use the eval function to return a decimal equivalent. Any tips?

I already have the table create. For the record, the fractions are limited to 15 set fractions, no more. Please clarify how I will enter a letter, display the fraction and store the decimal equivalent in my form. I am fairly new to this and could use some advice. Thanks, Greg

I tried to use the code because it seemed cleaner than using the combo box. I went to properties/afterupdate and changed it to event procedure. I then opened the code page and cut and pasted your code, switching the fields to match my appication. I received an error ambiguous name detected...

I move the question to the Forms Forum. Thanks