Search results

Thank you sir. Oddly enough, this solution also allowed me to fix the same issue in another database that our assemblers use to pass/fail items tested. After updating Office they would need to tab four times for each item scanned. Now it just auto tabs! That DB was developed by our in...

Sorry for the late response but was able to figure it out....quite simply I might add. Had to add code to the After Update event for the one field that was pausing waiting for input. If field is not null then GotoControl next field The code still exists in the On Got Focus to copy down data...

OMFG, I need to go home!! I get sooo focused on one thing I get tunnel vision. Looks like I will catch this up on Monday. Thank you thus far and have a great weekend.

I am using the macro builder option for the On Got Focus property. I see no way of adding an else branch to the If Statement

I'm not sure where the hick-up is. After the first record for a new order, I would think the If is NOT NULL would just see that the field data from the previous Order Number record has been Filled Down (^') and move on. But when I move the GoToControl down to the Is NOT Null if statement it...

If I do this, it skips right past the Order Number field and jumps to the Sold To field. If [Forms]![Order Entry Form]![SERIAL NUMBERS.OrdNumber] Is Null Then Sendkeys Keystrokes ^' Wait = Yes GoToControl Control Name = Sold To End if If [Forms]![Order Entry Form]![SERIAL NUMBERS.OrdNumber] Is...

Yes, exactly like that. Also changed the wait to No for the ^' Keystrokes.

If [Forms]![Order Entry Form]![SERIAL NUMBERS.OrdNumber] Is Null Then Sendkeys Keystrokes ^' Wait = Yes End if If [Forms]![Order Entry Form]![SERIAL NUMBERS.OrdNumber] Is Not Null Sendkeys Keystrokes {tab} Wait = No. Sendkeys Keystrokes {tab} wait = No End if. I even had the extra {tab} in the...

Thank you. Yes, added extra Sendkey {tab}. To be honest, I even made a new DB with three fields to mimic the live and have yet to get it working. I failed to mention the embedded macros are in the On GetFocus properties. I even tried putting the code in On Enter, no change.

Thank you to whom ever put my post in the right spot. Sorry about that. The macro code in my post is exactly the way it has been for many many years. I did not develop the database but now get to fix the breaks.

Greetings Access gurus. First time posting here so be gentle. While I am not an Access expert, I know enough to be dangerous. I have recently did some updating/upgrading to a database that my company uses and have a "bug". For a new order our Shipping clerk would scan in a serial number (for...