Entering Data from Barcode

[EliotF]

I work for a small maufacturing company.

We have 3 computers on our shop floor, these are used keeping track of jobs
and stock using our company databases.

It is hoped that we will soon start to use Barcodes to track jobs and stock.

We have a barcode entry system up and running but atthe moment mouse clicks
are required to get to the right form and get focus on the right control
before you can start reading things.

Since we only have 3 computer we can't assign one to purely take barcode
readings as they are required for other uses.

Does anyone have any idea on how I might get around this problem?

Entering barcode information is the same as typing it on a keyboard so I had
though about using an 'OnKeyPress' function but wanted to get other people's
views?

Thanks

EliotF

 

[Tom Wickerath]

Hi Eliot,

You can set the startup form either by using a macro named Autoexec, or by
specifying the form under Tools > Startup. You can set the default control
using the Form_Current event procedure, ie:

Option Compare Database
Option Explicit

Private Sub Form_Current()
On Error GoTo ProcError

Me.txtBarcode.SetFocus

ExitProc:
Exit Sub
ProcError:
MsgBox "Error " & Err.Number & ": " & Err.Description, _
vbCritical, "Error in procedure Form_Current..."
Resume ExitProc
End Sub


where txtBarcode is the name of the textbox that you want to set focus to.
Substitute the name of your control for txtBarcode in the above procedure.

If my answer has helped you, please answer yes to the question that reads
"Did this post answer the question?", which should be visible at the bottom
right corner of your screen.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I work for a small maufacturing company.

We have 3 computers on our shop floor, these are used keeping track of jobs
and stock using our company databases.

It is hoped that we will soon start to use Barcodes to track jobs and stock.

We have a barcode entry system up and running but atthe moment mouse clicks
are required to get to the right form and get focus on the right control
before you can start reading things.

Since we only have 3 computer we can't assign one to purely take barcode
readings as they are required for other uses.

Does anyone have any idea on how I might get around this problem?

Entering barcode information is the same as typing it on a keyboard so I had
though about using an 'OnKeyPress' function but wanted to get other people's
views?

Thanks

EliotF