Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vepz
  • Order by date
  1. vepz

    Pulling Info from a different Table/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...
  2. vepz

    Feet-Inches-Fraction Issue

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

    Feet-Inches-Fraction Issue

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

    Feet-Inches-Fraction Issue

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

    Feet-Inches-Fraction Issue

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

    Multiple Input Masks

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

    Specifying One Field for Unique Value

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

    Specifying One Field for Unique Value

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

    Preventing Data Entry Errors

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

    Preventing Data Entry Errors

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

    Substituting letters for fractions

    #Error Is this what you meant?
  12. vepz

    Substituting letters for fractions

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

    Substituting letters for fractions

    =[feet] & "'-" & [inch] & " " & [fraction] &
  14. vepz

    Substituting letters for fractions

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

    Substituting letters for fractions

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

    Substituting letters for fractions

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

    Substituting letters for fractions

    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?
  18. vepz

    Substituting letters for fractions

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

    Substituting letters for fractions

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

    Fractions

    I move the question to the Forms Forum. Thanks

Part and Inventory Search

Back
Top