Allow User to Change Form Colours and Captions Each Year

[samjh]

Hi,

My database has a front end that uses forms to allow the user to navigate within it, each year we create a new database which is based on the previous year's database but with all the variable information removed.

Within the database each form has a caption that starts with '2014-15' then goes on to say the form name.

Most of my forms also have a yellow background, (last year it was pink).

Both these areas were set up so that each year our users can distinguish between our databases, as they may have last years and this years open at the same time.

What I would like if possible is to know whether I can get a user to change both these things from within a form. So something along the lines of a button that when clicked would check all form captions and if within the caption it finds 2014-15 then change it to 2015-16 (or whatever the user specifies) but keep the rest of the caption.
I would also want the same type of thing to happen with the colour so again within the background of the forms, if you find colour X then replace it with colour Y.

If this can't be done within a front end form, then could it be done behind the scenes, and if so how would I go about doing it?

Any help here would be great.
Thanks.

 

[plog]

I smell an improperly structured database, and more importantly a painful system for users to use. Why must you create a new one each year? Especially if user's still need access to last year's data? I really think you are doing a disservice to your user's with this setup.

For your actual issue, I don't understand that either.

What I would like if possible is to know whether I can get a user to change both these things from within a form.

Change what things? You're creating a new database for them, right? Aren't you setting the colors and captions of the thing?

I really think you need to reevaluate your system. You've overcomplicated things, now you want to make it a little less complicated by adding more complication.

 

[samjh]

Hi, thanks your reply, however the database I have built will not be getting changed any time soon, it was the first one I have built and works fine. We only need to access previous years data for a very limited time.

I base the new years database on the old years database and only delete the variable data from 4 of the tables, everything else stays the same.

Essentially all I am trying to do is see whether there is an easy way of changing the Caption within a form if it meets a specific criteria, and change the background colour of a form if it meets a spcific criteria.

Thanks.