Hi,
I haven't used Access in years and now I've been thrown in at the deep end, so forgive me for any *silly* questions.
Basically, I'm trying to set up a system whereby one element of it is to automatically move a record from the 'Current Campaigns' table to the 'Archive' table when the Expiration Date (a field in the Campaigns table) is reached.
Is this possible? Easy or hard? VBA should do it, right? I'm used to working in Excel and I have created a system where this is done using =TODAY() and performing time&date calculations. Can this be done in Access too?
I haven't used Access in years and now I've been thrown in at the deep end, so forgive me for any *silly* questions.
Basically, I'm trying to set up a system whereby one element of it is to automatically move a record from the 'Current Campaigns' table to the 'Archive' table when the Expiration Date (a field in the Campaigns table) is reached.
Is this possible? Easy or hard? VBA should do it, right? I'm used to working in Excel and I have created a system where this is done using =TODAY() and performing time&date calculations. Can this be done in Access too?