Search results

I am getting a runtime error -2147352567(80020009) while using this code if the employee types a number into a combo box instead of using the scanner, is there a way to stop the error from popping up? Private Sub Shop_Order_Number_AfterUpdate() Static abort As Boolean If abort Then abort...

Hello, I have this code that when the cursor is in the combo box and scans the bar code it leaves the left 5 numbers in the combo box and then drops the next 3 down to the next text box. It works fine with the limit to list set to no in the (shop order number) combo box. I really need it to...

Can you set a validation rule to look at a list of numbers that a query created or look to see if it is in a list of numbers ina table? I have a table that has a list of numbers in one column and then there is another column that states if the the number can be used "Yes" or "No" in that column...

I have a calculated field in a table and what I need it to do is to look at the Time On and the shift and if the shift is "3" and the time on is between 7am and midnight to take the date and add 1 day to it. Here is what I got but it does not seem to add a day no matter what I have in for a...

Bob, Here it is, also can you tell me why this opens like to databases so when I close I have to X out twice JC