Public (Global) variables

[Ninad]

I capture the userid via a Login form and I need to use this userid for
other forms as well. How and where can I declare this variable
"strLoginID " such that its value can be used throughout the
application.

Regards,

Ninad.

[Sunil]

Re: Public (Global) variables

You should declare it in the 'General' section of a module. You
probably have one module containing your utility functions etc. You can
use the same.

HTH

Sunil Korah

[altacct@yahoo.com]

Re: Public (Global) variables

Ack! Don't build your own security system. There's a perfectly good one
built in to access. When the person logs in, you'll be able to get
their login with the built in function CurrentUser().

Jeremy

Ninad wrote:[color=blue]
> I capture the userid via a Login form and I need to use this userid[/color]
for[color=blue]
> other forms as well. How and where can I declare this variable
> "strLoginID " such that its value can be used throughout the
> application.
>
> Regards,
>
> Ninad.[/color]

[pietlinden@hotmail.com]

Re: Public (Global) variables


Ninad wrote:[color=blue]
> Thanks for pointing towards a good direction. Is there any reference
> material on the web where I can learn how to use it. I am not[/color]
familiar[color=blue]
> with Access security system and will need a lead. TIA.
>
> Ninad.[/color]

MS has a white paper on it. Check their website.

[Ninad]

Re: Public (Global) variables

Thanks for pointing towards a good direction. Is there any reference
material on the web where I can learn how to use it. I am not familiar
with Access security system and will need a lead. TIA.

Ninad.