Storing a variable between sessions

[Guest]

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)

 

[Guest]

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.

You will need to create a table to store it in.
gm