Not sure if this is possible, but...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all!

I was wondering if you can trap a CR/LF character, and force a form to go to a new record. Here's what I want to do: I have a hand-held bar-code scanner, and I want to create a new record in my database every time I scan in a barcode. Is this even possible? If it is, your help would be appreciated.

Thanks in advance.
 
You might try using the AfterUpdate event of the control into which you're
putting the bar code results:

Private Sub BarCodeControlName_AfterUpdate()
DoCmd.RunCommand acCmdRecordGoToNew
End Sub


--
Ken Snell
<MS ACCESS MVP>

GP said:
Hello all!

I was wondering if you can trap a CR/LF character, and force a form to go
Click to expand...
to a new record. Here's what I want to do: I have a hand-held bar-code
scanner, and I want to create a new record in my database every time I scan
in a barcode. Is this even possible? If it is, your help would be
appreciated.
 
I've done this before and I just used the KeyPress event (it's usualy either
an Enter (vbKeyReturn) or a Tab (vbKeyTab) on a barcode).
 
Back
Top