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

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

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

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

I need to enter a fraction into one of the fields on my form. I want to use a letter for each fraction like w=1/16, e=1/8, etc up to k=15/16. I would like to be able to enter the letter into the field but have the fraction displayed and the decimal equivalent available for other uses. I am...

I want to have the option of having a value either repeat from the previous record or be over written with a new value. I know about the ctrl ' but I believe that it can be written into the properties of the value. The repeating data is called description and is a text format. Thanks, Greg

I search but found nothing about inputting fractions into a table. I need to input fractions of an inch into a table. I would like to be able to enter fractions with denominators from 1/2 to 1/16. I am sure this has come up before. I can do this in Excel but not in Access. Thanks, Greg

My application tracks job number and mark number for our production. Each job number could have similar mark numbers. So the only way to get a unique identifier is to consider both fields. I am using a list box and I can store a single field. Is there a way for me to save both values? This...