Variables and Forms

[jeff_i]

Not sure if this even makes sense:

I would like to use a form to hold the values of some variables, so that if thing change (ie name of the mail server), they could just be updated on the form.

I can't figure out how to get a text box to hold the value, once I close it's gone.

Most likely I am missing something simple.

Thanks

Jeff

 

[Mile-O]

Do you know that if you declare a variable like this:

Public strExample As String

then it can be used throughout the database without the need to store it on a form?

 

[NJudson]

Jeff, you can create a table and each field in the table can correspond to the variable you want to hold. Then create a form (you can use the form wizard) and base the form data on the new variable table that you just created. The wizard is good and really easy for something like this. HTH

 

[jeff_i]

Thanks to you both for the Help.

I am very new to this Code thing and but I keep getting myself furhter into by constantly complicating things.

Basically what I have is three databases that make up an "Application"

1. FE for Users (as .MDE file 35 users, 8-10 concurrent)
2. BE tables on Server (as .MDB file)
3. Admin Interface (as .MDB file, runs about 15 tasks a Day via task scheduler)

I am trying to streamline the Admin Interface which handles all of the automatic imports and exports. As it stands I use the Do command send object method to perform the exports, etc. The problem I have with this is if Outlook goes down it needs to be restarted before an emails can go out from my database. So I am trying to elminate the need for outlook by using the CDO methods talked about on this site. Which results in my variable question to use the CDO method I have to define the mail server which may change. (this also would allow me to move the Admin package to a machine without outlook)

So could I store the variables in a table then use a Dlookup to find the value of the variable?

Thanks again.

Jeff