Re: Access 97 - global variables??

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



"Mr B" <mrb_16@xxxxxxxxxxx> wrote in message
news:1153423997.123604.185750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Performance concerns in SPs and Tables
    ... would expect memory to be allocated on declaration; for a varchar, ... procedural code; database access code should be declarative. ...
    (microsoft.public.sqlserver.programming)
  • Re: Relink question
    ... you should Dim dbBE as DAO.Database. ... BTW, EVERY variable you use should be declared. ... using implicit declaration ... there is no law that says an Access database must have the extension ...
    (microsoft.public.access.formscoding)
  • Re: Syntax to connect to A2K DB with a DB password using VBA
    ... You stated that your code below works for a database without a password, ... there are a few lines of code missing from the code snippet you posted ... Tom Wickerath's explanation of why you should _always_ use "Option Explicit" ... I'd also like to point out that your declaration of "strDBName" (which, ...
    (microsoft.public.access.externaldata)
  • Re: Accuracer C/S Database?
    ... > the database including the declaration of the referential integrity ... >, stored procedure, views, users, user groups and database object ... but also default value, validation, RI, FileEngine, RecordEngine, Encryption, ... > program it in code and re-compile the server. ...
    (borland.public.delphi.thirdpartytools.general)