Search results

Yes, EmpID is a text field (don't ask why).. I'm not sure what you mean by a non existent filter record? Can you help on that a little more?

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

Ok, I managed to fix it with just a few small tweaks (the PauseDuration was causing problems as well as the general calc). But, I've got one small issue that still needs to be figured out if someone can help? The code is: The problem I get is when the minutes are single digits, so if there...

Thanks again for all the help!! The query is still causing problems for me, here's what I got right now: The first part, the DueTime looks like this (it works fine without any problems) But the TimeLeft calculation is causing a problem: The results for the Time Left are either an #error...

That's perfect, the Minutes part I hadn't thought about, thanks! What about a count down, so If I want to see how many minutes I have left on an order? A DateAdd wouldn't work for that would it? Thanks Again!

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

Ok, I got it to work using: Private Sub Part_No_AfterUpdate() If IsNull(DLookup("Part_No", "table_lines_per_part", "Part_No = '" & [Forms]![frmStartTimeEntry]![Part_No] & "'")) Then DoCmd.OpenForm "frmLinesPerPart" Else Lot_Size.SetFocus End If End Sub hope this helps...

Ok, I've been able to sort out most of the problems, the issue is with the dlookup. After I've read the Part_No field in the frmStartTimeEntry, it should check the table_lines_per_part for this part and if not found then direct to another form where the user can enter the missing information...

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