Barcode reading and Security

[spectrolab]

Hi Guys,

This might be pretty simple, but I haven't found anything on it (might not have looked hard enough!). What I am trying to do is scan a barcode label that I created in Access, when this is scanned, it goes to a table and opens the record that contains this ID and allows me to enter further data in this record. The further data will be data capture from a balance, which works fine if you select the location where the data is to go (using the mouse), what I need is for this location to be automatically accessed when I scan the barcode, hope that makes sense.
Also, is there any way in Access to either prevent data in a table from being changed once it is entered, or alternatively to mark the data as changed/edited from the original input?

Any help would be greatly appreciated.

Nigel

 

[neileg]

First point, you don't enter data in tables, you use a form.

Most barcode scanners can be programmed to add extra characters at the end of the code to simulate key presses, eg the enter key or the tab key. You need to look here, rather than in Access to denote the end of the code input. Then you can get a form event to trigger a query to return the data relating to that record.

Again, using a form, you can allow users to view data but not change it, or by adding some fields to store dates and user IDs you can log who last changed the data. Search in these forums for a thread called Audit Trail or something similar which covers this in great detail.