View Single Post
Old 06-14-2017, 02:48 PM   #3
Uncle Gizmo
Nifty Access Guy
Uncle Gizmo's Avatar
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 9,771
Thanks: 425
Thanked 837 Times in 796 Posts
Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough Uncle Gizmo is a jewel in the rough
Send a message via Skype™ to Uncle Gizmo
Re: Automatically creating new form after data entry?

Originally Posted by stell View Post
I'm trying to avoid having the employee have to put down the scanner and manually create a new form every time.

Instead of scanning the barcode directly into a text box attached to a field in the underlying table, scan into an unbound text box. When you make a scan the barcode scanner is set up to key in the data from the barcode and then mimic pressing the enter key. The "Enter Key Press simulation" triggers the after update event of the unbound text box. Write code in the after update event which takes the information from the unbound textbox, places it into the relevant bound textbox, clears the unbound textbox ready for the next entry. I've found this arrangement enables quite a high speed of data entry, and completely under your control.

|                                     |
|      Uncle Gizmo              |
|                                     |
|                                     |
| Get $20 worth of "Nifty Code"       |
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| | Ooo | |_________________ooO____( )________| ( ) ) / \ ( (_/ \_)
Uncle Gizmo is online now   Reply With Quote