[AccessD] Global Variable???

Mark A Matte markamatte at hotmail.com
Mon Sep 18 11:22:47 CDT 2006


Thanks for the feedback...I found my brain cramp...you have to declare a 
global variable in a module...not a class module?.?.?...I think...lol

But it works now.

Thanks,

Mark A. Matte

>From: "Robin " <Robin at rolledgold.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Global Variable???
>Date: Mon, 18 Sep 2006 16:43:48 +0100
>
>Hi Mark,
>If I understand you correctly you need to assign the dlookup value to a
>variable....
>
>eg strlocation = dlookup("location","tblLocations","ID=2")
>
>Then use strlocation in your module....
>Rgds
>Robin
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte
>Sent: 18 September 2006 16:44
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Global Variable???
>
>
>Hello All,
>
>I have an A2k db...and apparently am having a brain cramp.  On a
>form...click a button...uses Dlookup to find which path to a folder we
>are
>going to use...  Location = dlookup("location","tblLocations","ID=2")
>
>The Dlookup works fine...but I need to pass this value to a function in
>a
>module...whenever I put "location" in the Module...it says variable not
>defined.  I've tried everything I can think of.
>
>
>Please help?
>
>Thanks,
>
>Mark A. Matte
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list