Hello and happy newyear all.

I'm working on redesigning an MS access system. In this thing there's a
button that ends the year (endyear button). At the moment it does some
things but i have no real clue what exactly. More important is what i
want it to do, and that is the following:

- End Year Button -

1) CLEAR -> result_nextyear

2) COPY -> contract_general
-> contract_savings INTO result_nextyear

3) CLEAR -> contract_savings
-> contract_general
-> budget_opco
-> budget_person

(these are all table's)
- - -
I think I got it worked out as it is, I just need to build these 3
action querie's and link them to the button?!

Detail, the old current button uses somesort of Macro, i have
absolutely no clue where the macro is used for and where it can be used
for, it looks to me as some kind of index (XML?) thing. Do you know if
i need to use a macro to get the result i want. And could you tell me
where macro's are commonly used for?

Thx for any help, it's much appreciated.

Tim

Geel schreef:

> Hello and happy newyear all.
>
> I'm working on redesigning an MS access system. In this thing there's a
> button that ends the year (endyear button). At the moment it does some
> things but i have no real clue what exactly. More important is what i
> want it to do, and that is the following:
>
> - End Year Button -
>
> 1) CLEAR -> result_nextyear
>
> 2) COPY -> contract_general
> -> contract_savings INTO result_nextyear
>
> 3) CLEAR -> contract_savings
> -> contract_general
> -> budget_opco
> -> budget_person
>
> (these are all table's)
> - - -
> I think I got it worked out as it is, I just need to build these 3
> action querie's and link them to the button?!
>
> Detail, the old current button uses somesort of Macro, i have
> absolutely no clue where the macro is used for and where it can be used
> for, it looks to me as some kind of index (XML?) thing. Do you know if
> i need to use a macro to get the result i want. And could you tell me
> where macro's are commonly used for?
>
> Thx for any help, it's much appreciated.
>
> Tim

I got it fixed, the endyear button is up and working in the appropriate
way, guess good preparation makes it quite easy to get things done the
way they have to be done.

BTW, i had to use the macro function. Ofcourse i now understand what
they are commonly used for