Cancelled Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AW - 28 Dec 2004 16:12 GMT

Hi.
I'm a newbie to Access and have a problem for which I am looking for some
assistance. I'm sure the issue is pretty basic,however I would be grateful
if any person could pass on their experience via this group.

The issue:
I have a table (tblMaster) into which I load projects that pass across my
desk, Job No.s, types, sizes etc. This table is used to generate numerous
reports via Queries I have generated.

I would like to know, if when a job is "cancelled" or "completed"
addedwithin the master table, if the record can be transferred to another
table automatically. This table (tblComp) to be added to and not replaced
each time a record is added.

Can this be done, and if so, how?

Any assistance would be appreciated.

TIA

Al@n

Reply to this Message

Rick B - 28 Dec 2004 16:20 GMT

This could be done, but shouldn't. When you only want to see active tasks,
just filter out the completed ones. It is not standard database practice to
move records to another table just because thier status changes.

Hope that helps,
Rick B

> Hi.
> I'm a newbie to Access and have a problem for which I am looking for some
[quoted text clipped - 18 lines]
>
> Al@n

Reply to this Message

John Vinson - 28 Dec 2004 21:53 GMT

>Hi.
>I'm a newbie to Access and have a problem for which I am looking for some
[quoted text clipped - 10 lines]
>table automatically. This table (tblComp) to be added to and not replaced
>each time a record is added.

As Rick says, it's best not to have separate tables for this purpose;
doing so causes a lot of overhead and complexity which is not
necessary. Instead put a Yes/No field Active, or an integer field with
values 0=active, 1=cancelled, 2= completed and base your form on a
Query which selects the appropriate records for display and editing.
(Use an Option Group control for the three-value integer).

John W. Vinson[MVP]

Reply to this Message

AW - 30 Dec 2004 17:03 GMT

Thanks for the response, not exactly what I wanted but sound advise.

Cheers

Al@n

> Hi.
> I'm a newbie to Access and have a problem for which I am looking for some
[quoted text clipped - 18 lines]
>
> Al@n

Reply to this Message