Copy Close record

[Marcelino B via AccessMonster.com]

Hey guys good morning. I'm working in a Work orders tracking system. I have
a table (workorder) to keep all the work orders. Ok my question is when I
close a work order check mark (close button) and keep it on the table
(workorder). I want a routine or something to take that workorder that is
ready close and copy on (close workorder table) and deleted from the
(workorder) table and that way I keep a history of the work order in diferent
table. I did by query but ask me all the time if I want to do that. Exist
another way w/out use the query.

Thank

Marcelino

 

[Vincent Johns]

Hey guys good morning. I'm working in a Work orders tracking system. I have
a table (workorder) to keep all the work orders. Ok my question is when I
close a work order check mark (close button) and keep it on the table
(workorder). I want a routine or something to take that workorder that is
ready close and copy on (close workorder table) and deleted from the
(workorder) table and that way I keep a history of the work order in diferent
table. I did by query but ask me all the time if I want to do that. Exist
another way w/out use the query.

Thank

Marcelino

I suppose that you're trying to save space in the original [workorder]
table by moving records from it to [close workorder table]. Yes, you
can do that by using some Queries, perhaps with an Append Query to add
the record to [close workorder table] and a Delete Query to erase it
from [workorder]. You can set up a Macro to run both Queries in
sequence and save some manual effort. (I do recommend backing up your
database file frequently, so you can recover using the backup in case
you delete more than you intended.)

But have you considered just leaving the record in its original place?
You could include a Yes/No field in [workorder] that you might call
[workorder].[closed] that you could set to "True" once the workorder in
that record is closed. To list the open records, use a Query that lists
only those records with [workorder].[closed] = False. Or define a
filter that displays only those records. (If you define such a filter,
you can have Access save it as a Query.)

Instead of what I just suggested, you could define [workorder].[closed]
as a Date/Time field, showing the date the order is closed. Then you
could define your filter to display records where that field has a Null
value instead of a date. If you did it this way, you could display
closed orders according to when they were closed.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.