Search results

I've got a form where the user can only enter the character asterisk or numbers. No letters or other special characters allowed. The asterisk is a problem since its a wildcard. How do I allow the user to use it or numbers only? I've tried Validation Rules, I've tried vba but I don't seem to...

Hey, I'm just throwing this out there because I'm not sure if this can be done.. Is there a way to create a report that will show inventory location capacity in a graphical form. So if a location is determined to be utilized 25% a picture A is used, if 50% picture B is used, 75% picture C is...

I have a form where a user enters data. One of the things the user enters is a "lot size". I need this lot size field to be checked against a query in the database to determine if the quantity is acceptable or not. The order number in this query is in certain cases missing a leading zero, so I...

I have a form that is bound to a query. The user inputs their id in a text box and the form should find the corresponding record with 5 different pieces of data displayed in separate text boxes. There is at any given time only one record set per id. The query has in the EmpID the criteria...

I have a query where I'm trying to calculate when an order is expected to be completed. I have a lot size and a time standard with an efficiency for production. The result gives me a text string of time but I need it to be in the hh:mm format without doing a custom function (I later use this in...

Help! I have a form called frmStartTimeEntry where a user inputs data using a barcode scanner. In this form there is a field called Part_No where after a value is inserted, I'd like the form to check if table_lines_per_part includes this part. If not found, then I'd like the form to open...