H
Hank
I posted this question elsewhere before realizing there's
a dedicated Table forum. Please accept my apologies.
I'm developing a simple data base with one table to keep
track of memo's that are signed by my boss. Each of us
(who works for him), upon writing the memo is required
to fill out a coordination sheet containing various
information about the memo, including the date signed by
my boss.
I was thinking about creating a form so we can fill it
out, then use a report to print the coordination sheet.
The problem is I don't know when my boss will sign the
memo, which means later we need to come back to edit the
data. The problem is the people I work with are not
computer savvy enough to find the right record and
correctly edit it unless I make it really easy and fool-
proof for them. I'm concerned that they might mess up
the existing records.
I was thinking about creating a temporary table that has
the same fields with the main table to store these info.
Once I have the signed date, if I can somehow write codes
to cut/copy this data row and paste it as a new record in
the main table then delete the record in the temporary
table. Is this a good way to do it? I have a feeling
it's not but I barely know Access and database. I'd
appreciate any help and/or pointers you'd give.
Thanks, Hank
Hank
a dedicated Table forum. Please accept my apologies.
I'm developing a simple data base with one table to keep
track of memo's that are signed by my boss. Each of us
(who works for him), upon writing the memo is required
to fill out a coordination sheet containing various
information about the memo, including the date signed by
my boss.
I was thinking about creating a form so we can fill it
out, then use a report to print the coordination sheet.
The problem is I don't know when my boss will sign the
memo, which means later we need to come back to edit the
data. The problem is the people I work with are not
computer savvy enough to find the right record and
correctly edit it unless I make it really easy and fool-
proof for them. I'm concerned that they might mess up
the existing records.
I was thinking about creating a temporary table that has
the same fields with the main table to store these info.
Once I have the signed date, if I can somehow write codes
to cut/copy this data row and paste it as a new record in
the main table then delete the record in the temporary
table. Is this a good way to do it? I have a feeling
it's not but I barely know Access and database. I'd
appreciate any help and/or pointers you'd give.
Thanks, Hank
Hank