radio buttons in access form

[Edward Letendre]

Okay, this maybe a strange and or easy question for the experts, but here
goes.

In access 97, I have a form that display information according to a series
of dates radio buttons.

Each button is displayed according to data in the database starting with
1995 and ending with the current year of 2005). The data is also stored in
tables according to the year, thus there are two tables for each year (for
example customer information for 1985 and plotting data for 1985)

When a new year comes up (for example, when we rolled back from 2004 to
2005), two new tables are created and a new radio button is added. Both of
these processes are done manually by the administrator of the database.

What I need to know is that is there a way to automate this process so that
when the new year comes around, two new tables are automatically created and
a new radio button is added to the form based on the new year.

Also what is the best way to archive data from the master database to
another database and still be able to get the data back when I need to. Thus
does access offer any kind of archiving processes?

Edward Letendre.

 

[Graham R Seach]

Edward,

What you're doing is anathema to database designers! You should be appending
your data to the existing tables, and uniquely identified by date (or some
other meaningful value).

Do not create a new set of tables for each year! Just use a combo box to
select the appropriate year's data from the tables.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia