text to be updated periodically

[roger]

I have this one form in my application which has these
dates for the dates the sweepstakes is going to be
happening. These dates are changed/updated every month and
I want the users to be able to do this rather then me
agoing and changing the dates thru Access.

1)Someone told me I can use .ini files for this? How is
that done?

2)Also, any other way? like say I create a .txt file and
have the file embedded in to the form as an object by
setting its control source property to this .txt fle
location. Can I do that?

 

[Ron Weiner]

By you post I am assuming that the Dates are HardCoded into your app. If
this is the case create a new table (tblGlobal) that will ever have only one
record. That record has all of the fields that you need to change on a
(ir)regular basis. Rewrite your code to pull the data from tblGlobal with a
simple Dlookup statement, and you are half way there.

Last step is to give your users some method of updating this table when they
need to. You can write code that uses Access Startup parameters, ini files,
and other cool stuff like that. But I recommend you KISS your users. Make
a form that is bound to the fields in this table that they need to change
and give em' a way to open the form.

Ron W