Go to new record after reading Serial number from barcode reader

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Go to new record after reading Serial number from barcode reader

Post by siamandm »

Hello All,
I would like to create a form, with one field (serial number), and I'm using a barcode reader to read the serial numbers from products,
when I scan a serial number, I would like to go to a new record for time-saving automatically.

I have tried on change, after update on dirty event with this code

Code: Select all

DoCmd.GoToRecord , , acNewRec
but not working,

your help is much appreciated.
Regards

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go to new record after reading Serial number from barcode reader

Post by HansV »

See if the barcode reader software has a feature that sends a Tab or Enter automatically after scanning a code.
Best wishes,
Hans

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: Go to new record after reading Serial number from barcode reader

Post by siamandm »

Thank you for the reply, How to find out this feature, the model I'm using is: Honeywell Adaptus 3800g handheld

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Go to new record after reading Serial number from barcode reader

Post by HansV »

Best wishes,
Hans

Gasman
StarLounger
Posts: 81
Joined: 22 Feb 2022, 09:04

Re: Go to new record after reading Serial number from barcode reader

Post by Gasman »

Using Access 2007.
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Please, please use code tags when posting code snippets, click the </>icon.
Debug.Print is your lifesaver.

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: Go to new record after reading Serial number from barcode reader

Post by siamandm »

Thank you very much dear @HansV and @Gasman
with your helps, I figured out how to program the handheld.

Regards