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

John, I don't think that is what I need but it is pretty cool and I have another application that I could use your sample on. Bar code scanning in this case is really no different then typing it in by hand. If I typed in 55555123 and hit enter it (the code) would leave the 55555 in the shop...

Thanks John I will take a look at it.

Thanks for replying, I can set it to "Yes" or "No" unless I am looking at it wrong "True" is not an option. As far as your advice I am only a rookie when it comes to Access so I am not sure how to do that. Any adevice?

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

Hey thanks Booty I will give that a try.

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

All, Thanks for your reponses, here is what I got to work this morning, our 3rd shift starts at 10pm the date prior to the actual pay date so this will move the shift data ahead one day if they punch in before midnight, if after midight it leaves it the same which is what I was looking for...

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

Thanks for all your help.

Bob, I also might have messed the database I sent to you up as I deleted a bunch of names in the employee table, the query I was having problems with was the one I called Edit Test Thanks JC

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