Storing a variable between sessions

[NeilH]

I'm building a membership database for a small Sports Club. we have a fixed
membership year from 1st April to 31st March. I want to have a variable
describing the current membership year e.g 2004 that I can carry over between
sessions.

I can't use the date as in February/March we prepare for the next year e.g
sending out invoices but may still have members choosing to join for the last
month of the previous year.

 

[Arvin Meyer]

Tables are for storing data between sessions. Create a table for default
values that you can load when you open the database. Or use a Fiscal Year
which can be done in code:

http://www.datastrat.com/Code/FiscalYear.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[david epsom dot com dot au]

:~) That's what a database is for.

Create a table, something like tbl_Options, and
use it to store odd bits of persistent data.
Then you can lookup the value when you want:

vDate = dLookup("MemberYearDate","tbl_Options")

and you can use also the table (and the membership
year) in any query.

(david)