help

[dmims]

I need to create a macro that will allow me to move old information from my
current up-to-date information into another table. I need help.

 

[Steve Schapel]

Dmims,

It sounds like you need to make an Append Query or Update Query. And
then if you want to automate with a macro, you would use an OpenQuery
action to run the Append or Update.

 

[KARL DEWEY]

Have you considered adding a flag field to mark a record as old? Add
criteria to your queries to only pull records not marked as old. Then all
your data would be available including old and current for reports.

 

[dmims]

I have a yes/no check box. It indicates which ones are the ones we no longer
use. I tried to add the criteria to pull the old ones but then it only pulls
the one and leaves the rest and I want to have the information complete moved
from the current table in to the archive table. So what happens is that I
keep getting an error message.

 

[dmims]

So well this make the table automated or will I have to run the macro in
order to have the table updated? Thanks for all of your help.

 

[dmims]

I am sorry I forgot to say thank you. so thank you.

 

[Steve Schapel]

Dmims,

Macros only run in response to Events. You would need to assign the
macro to a suitable event. For example, the Unload event of a
menu/switchboard form that is normally always open whenever your
application is open. Or maybe you only want it to run once a month or
something, in which case you would need to record the date it runs in
your database. There are lots of options, and so far I can't guess what
would apply in your situation, except to say that it is possible.

 

[dmims via AccessMonster.com]

Well if I wanted to to have the archive done once a week, I can mark the
acrhive box, which is a yes or no box, the macros would run it and place the
data is a query? Is that correct? Then my next question is I have tried to
create a query that would update my current table to get all the old contacts
out of my current contacts but it will only run and get some of the data not
all of it. So if I create the macro to get the data from the table to move
to the query will it get all the data or just some it if llike the query does
now? THanks.