Access 97 - global variables??

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: Edit rights to linked Oracle databases
    ... The lack of a Primary key index on the tables in the Test environment will ... The following example creates an index on an ODBC linked table. ... remote database is unaware of and unaffected by the new index. ... example won't work if you simply paste it into Microsoft Access; ...
    (microsoft.public.access.externaldata)
  • Edit rights to linked Oracle databases
    ... I have ODBC connections established to a Production Oracle ... database and a Test Oracle 9.2 Database - using ... Using the ODBC channel to Prod in Microsoft Access 2000, ...
    (microsoft.public.access.externaldata)
  • Edit rights to Oracle database
    ... I have ODBC connections established to a Production Oracle ... database and a Test Oracle 9.2 Database - using ... Using the ODBC channel to Prod in Microsoft Access 2000, ...
    (microsoft.public.access.security)
  • Re: asp - db problem with connection.
    ... Stop using ODBC! ... i cant seem to get my asp stuff to interact with a database. ... > Microsoft OLE DB Provider for ODBC Drivers ... > [ODBC Microsoft Access Driver]General error Unable to open ...
    (microsoft.public.inetserver.asp.general)
  • Re: Nameless CREATE
    ... The starting point is either an existing database or one that is ... "Describe" involves issuing an SQLDescribeCol function to ODBC ... essentially much the same as character data type apart from all 8 bits ... ALTER TABLE tablename ADD COLUMN BinaryColumn BINARY ...
    (comp.lang.forth)
Loading