Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Scanner Continuous Form
Stephen Kuperman 
    
5 years ago
I would like to create a continuous form to record products at various stages of production. I need to be able to pull up the product record by barcode and scan it update a date/time field. This will let me record all the products at each stage of manufacturing and how long each stage takes to complete.
Basically, I would be continuously scanning products and Access would be updating their date/time field without having to hit enter or tab.
Would appreciate any help on this
Richard Rost  @Reply  
          
5 years ago
Hi Stephen. That doesn't sound too hard. Just set up a continuous form where the scan field is the only field in the Tab Order. Have another field with a date/time value in it defaulted to =Now(). Then when you scan your barcode, it gets entered, focus should move to the next record, ready to capture another one. Piece of cake. :)
Stephen Kuperman OP  @Reply  
    
5 years ago
While I think this looks pretty trivial, it has it's issues. The Date field on a form will not update without being in a Tab. ie, if you don't Tab over it the field will not update.
I have created a form and just use the records from my ProductT table. I created a Combo / Searchbox and the Date field. And not matter what I do I cannot get this to just let me scan the 1 AssetTag field update a date field and go to the next record. I have tried to set the default for the date in the Table or on the form and it makes no difference. I thought maybe putting it into the BeforeUpdate on the form but could not get that to work either. I would not think this application was so unique but I don't even see much on it when searching. I know I'm getting old and have lost some brain cells along the way but this has me stuck. Would appreciate any help or suggestions on this.
Steve
Adam Schwanz  @Reply  
            
5 years ago
Have you tried the AfterUpdate event on the product field that your scanning into? Then when it tabs down it should set that fields date. Something like
Adam Schwanz  @Reply  
            
5 years ago
FieldName = Now()
Stephen Kuperman OP  @Reply  
    
5 years ago
Thanks Adam! works great. It looks a bit strange as the date field on the form does not look like it updates and the background color on the form turns gray. But looking at the datalog it does show the updates.
Richard Rost  @Reply  
          
5 years ago
The date field does update, but it gets the date/time that the new record line is created, not when the item is scanned. Adam is correct. Use an After/BeforeUpdate event for the scanned field to reset the time.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 12:57:43 AM. PLT: 1s