How to use global/public variable

[mrbabji]

Hi




The only info I know about global variable is Once it is declared,that can be used anywhere in your project. Is it true? Further, how to declare? where to declare? and how to use it is completely blank for me.

I have a "log on" form from which I will capture the user name into a variable.

I would like to use that variable in other forms and Basing on which I would like to generate reports on other forms and give permissions for editing etc.


Request anyone to help me in understanding and using the global variable concept in the above scenario.

Thanks & Regards
Nag

[orange]

You could leave that form Open, but hidden and still be able to reference controls on the Form

[rzw0wr]

What you ask is true.
I would declare it in a module.
In the code editor click on the Insert Module icon.
Double click the new module and declare you variable there.
Dim variable as whatever

Note: You can not give the variable a value in the module you opened. That has to be done in a sub or function.

It will be declared (Dim) when the database opens and should be available to all modules and subs.

EDIT: Usage is just like any variable, YourVariable = SomeThing.

Dale

[mrbabji]

Sorry.

I Tried with simple two attach a db with simple 2 forms and 1 table. The size is572 KB which is not permitted. I am unable to reduce the file size further.

Pls help.
Atleast I will try to elobarate what I need.

I have a user table, logon form, update form

Once username and password is fed on log on form. The username should be assigned to the global variable declared and update form shoud open.

In update form, the updae button should be enabled only if the user name is "admin".

Hope I am little clear now.

[rzw0wr]

Select the file in your folder window. Right click and select send to the zip.

The zip file will upload.

Dale

[mrbabji]

Zip file is not accepted for upload

[rzw0wr]

Did you try the zipped folder or the file?


Dale

[Missinglinq]

Since you're running v2003, in deciding how to approach this, you need to be aware that Public (global) variables are reset (i.e. 'zeroed out') if an Unhandled Error occurs anywhere in the app!

In later versions (2007 forward) something called TempVars was introduced, which eliminated this problem.

If losing this bit of data won't cause any critical damage, by all means use a Public (Global) Variable, but if it is important, in v2003 you would probably be safer using orange's suggested approach of leaving the logon Form open, but hidden, and referencing the appropriate Control(s).

Linq ;0)>