Barcodes

[Vinny1512]

Hi all,

Can anyone point me in the right direction? I want to be able to put a barcode in a field that when a reader scans the barcode it records the current time. Need it for access control to record who is in and out of the office. Reading other threads I understand it may be possible in Dlookup.

Appreciate any help and advice.

Thanks

Vinny

 

[MarkK]

Add a DateTime field to the table in design view, and set the DefaultValue property of the field to . . . .

=Now()

. . . then, when a new record is added to the table, which is what I assume your scan does, the date/time is recorded in that record automatically.

 

[Vinny1512]

Thanks lagbolt I will try it at the weekend. Very much appreciate your help.

Thanks a million.

Kind regards

Vinny

 

[MarkK]

You bet Vinny. All the best. Post back if you need more info.