N
nesalc
Hi Access Group.
Can somebody help me with my problem.
Scenarium:
I have an Access backend, only with tables ;-). These tables are
updated with data written from a program which is not developed in
Access. I have no forms in the backend in which I can call dules or
Subcodes.
What I need is that when the table "tbl_prod" has been updated with
new data, then the text value of field "tbl_prod.Article" is to be
copied into the emty field "tbl_prod.Barcode" of the updated record.
Is it possible to made this copy only in the table field setting, or
can it be done without Forms.
How can I get the "copycode" executed when new data has been written
to the table.
This backend is then used by a machine in which it is not possible to
change the software or field relations (interface).
If You can help me with this, then it will minimize a lot of errors
with wrong manual keyed in Barcodes.
Best Regard
Class Olsen
Can somebody help me with my problem.
Scenarium:
I have an Access backend, only with tables ;-). These tables are
updated with data written from a program which is not developed in
Access. I have no forms in the backend in which I can call dules or
Subcodes.
What I need is that when the table "tbl_prod" has been updated with
new data, then the text value of field "tbl_prod.Article" is to be
copied into the emty field "tbl_prod.Barcode" of the updated record.
Is it possible to made this copy only in the table field setting, or
can it be done without Forms.
How can I get the "copycode" executed when new data has been written
to the table.
This backend is then used by a machine in which it is not possible to
change the software or field relations (interface).
If You can help me with this, then it will minimize a lot of errors
with wrong manual keyed in Barcodes.
Best Regard
Class Olsen