Access 97 - global variables??

[Mr B]

Hi guys,

Urgent problems that I need to sort before Monday, I will be so
grateful for ANY help received! I am not familiar with Microsoft Access
with Visual Basic, I only really practice basic C++. I'm working on an
Access Application, and i have alot of repetitive variables for the
forms i use. Is there a way of declaring these variables globally
instead of declaring them each time fresh in a new event procedure?
(Is it also possible to initialise them globally as these values are
constants throughout the database)?

Also, my database makes an ODBC connection to a back-end DB2 database
and I use make-table and append queries on ODBC Linked tables. I'd like
the user to not have to enter the connection details every time a query
is ran (Database name and password) I have seen examples for
pass-through queries, where on the query properties a ODBC connect
string is specified or a wizard is ran...but for whatever reason on
mine the only fields that bair a resemblance are a 'source connect str'
and 'dest connect str'??

Thanks alot
Daniel

 

[Marshall Barton]

Urgent problems that I need to sort before Monday, I will be so
grateful for ANY help received! I am not familiar with Microsoft Access
with Visual Basic, I only really practice basic C++. I'm working on an
Access Application, and i have alot of repetitive variables for the
forms i use. Is there a way of declaring these variables globally
instead of declaring them each time fresh in a new event procedure?
(Is it also possible to initialise them globally as these values are
constants throughout the database)?

Create a standard module with no procedures. Just declare
your constants:

Public Const aaa As Long =123
Public Const sss As String = "qwerwer"

 

[Michel Walsh]

Hi,


As for the first question, you can define variables in the declaration
section of a standard module, their scope will be the whole application, but
can be hidden by another declaration of the same variable name in a class,
or in a procedure. You can use a database property to get them remembered
between runs of your applications. Here an example how to create one, read
it, and assign it.


CurrentDb.Properties.Append CurrentDb.CreateProperty("yoyo", dbText, "yo")

? CurrentDb.Properties("yoyo")
yo

CurrentDb.Properties("yoyo") = "rather not"


Hoping it may help,
Vanderghast, Access MVP