Search results

Hi, I have a form and was wondering if it was possible to set it so that a user is not able to click the submit [Submitcmd] unless certain text boxes are filled (however SampleOuttxt needs to be able to remain blank). Any help would be appreciated J

Hi everyone, Basically what I have is a form where operators can input certain information about a production process, in particular the kg input which has gone into the 'basket'. However this is divided by customer order number and sometimes more than one customers order is placed into the...

So something I've tried to do now is to have two text boxes which are next to each other; one where BJ/CJ/etc is typed and one where its just numbers and auto adds the zeros. I've managed to do both these boxes seperately which then link back to the main table and combine to create the order...

I have managed to get it to add leading zeros by using the following code Private Sub OrderNumbertxt_LostFocus() OrderNumbertxt = Format([OrderNumbertxt], ">@@00000000") However this will basically return 8 0s no matter how many numbers are in the order number? I'm trying to make the...

If I could do anything close to anything on Access I'd try something fancy but for now unless someone has a simple solution just gonna go with the input mask. Just wondering though is it possible to get it so that lets say you miss a zero out and are a digit short you can go back and add that...

This is what I tried originally but we have a lot of these order numbers so it just looked like a mess and I didn't know whether it was possible to have the order numbers leave the box once they'd been processed/shipped. I have set an input mask so that it only allows for a certain amount of...

Hi, I have a form which a order number is put in and is compared to data which has been pulled from the system. The issue I'm having is that that on the software we take the orders on it adds zeroes in front of the numbers to make it up to an 8 digit sequence, but generally when people input...

I tried that and it gave me an error of it missing a bracket so after moving things around a bit managed to make it work with this: Private Sub SuffixTxt_AfterUpdate() ItemNumbertxt = DLookup("item", "dbo_job", ("[suffix] =" & Forms![**INPUT - Theta A]![SuffixTxt]) & " And ([job] = '" &...

Hi everyone, I have been trying to find a solution to why I can't get a Dlookup with multiple criteria to return the value I need. Essentially I am trying to use an Order Number to find the item number which is contained within another table. However the order number has multiple lines...