Global Functions

[bob bisquick]

I am creating a database that will schedule events over the course of three weekends, and I need to reset those weekends each school year. I have created a form for entering those dates, and I think I want to store them in a module as global functions. I set up those global functions, but I am unclear as to how to link what gets entered on the form to the actual functions.

Please help.

 

[bjackson]

storing should be done in a table not a module,unless you mean
you only want to store those values until the data base is closed

if you could be a bit more specific then i may be able
to help you.

 

[bob bisquick]

Hmmm... What I want is for the user to set these dates at the beginning of the school year, and then those dates should be obtainable from anywhere in the database for query's and reports and such. AND, their should be some way to prevent them from getting changed accidentally.

The reason I didn't want to use a table is that the following school year, new dates will be chosen, and I want all the queries and such to still work with new dates. Should I be associating those dates with a callender year, and then all queries are filtered by calender year?

 

[pdx_man]

Create the table ... enter the data ... hide the table.

Reference it from where you want to.

 

[bjackson]

A table seems the only way to go to acheive what you
want to do.pdx_man has a good suggestion


you could then have a button on your form to
open a pop up form for inputting the dates

you may want to have a password to access that pop up form.

Also on that pop up forms on current event

if forms![yourformname].visible=false then
msgbox "You cant Open This form",vbcritical,"Error Loading Form"
application.quit

end if
that way the only way to access the form to change the dates
would be through a password


i have attached a sample db for you to look at
it may be of some help

i use it for my work,its in access2000
unfortunately i work with a 21 inch screen so you may have
to resize it to suit

hope this helps
Bruce jackson