Recent content by vepz

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.