Access Report Headings annual change name and location

[jimDownUnder]

Greetings from Sydney Australia.

I have been prowling the internet looking for information to solve
a problem I have with Access.
I do have a background in dBase and have used it extensively.

My wife is a member of Inner Wheel, a volunteer womens organisation
and they have an annual conference every year.
They have been given a management program using Access 2003.

I have run the program under Access 2007 and it behaves quite
differently, I suspect, due to additional security facilities.

As all their other programs are integrated on their laptop they
would prefer to persist with Office 2003.

Every year the Conference discription changes
i.e. "30th Annual conference Ballarat Victoria"
changes to "31st Annual Conference Coffs Harbour NSW."
Dates
also change e.g. "19th -23rd Nov" changes to "17th - 21st Nov"

As present the heading fields of every report need to be individually
changed every year.

Is there a facility within Access 2003 similar to that which used to
exist in dBase Macro function where a memory variable could be
inserted using &memvar or, similar function subtituting a variable
from a parameter file which could be changed once each year?

If you are unable to assist could you perhaps suggest where I might
locate appropriate information. I have not been able to locate information
that I can understand through Microsoft Q and A's or FAQ.
Best regards,
Jim Reid

 

[Duane Hookom]

Data should be stored in tables. You can use code, DLookup(), subreports,
subforms, and other methods to display changeable data in your reports and
forms.