Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 22nd, 2005, 09:40 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default Constant declared on a module

Hi,
I have a constant declared on a module that would be changed depending of the circunstances.
Would it be possible to settle the constant value when opening the form criteria of a report?
rgds Penta
 
Old June 22nd, 2005, 10:15 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Well, you're contradicting yourself. If the value is going to change based on the circumstances, then you do NOT have a CONSTANT. You have a VARIABLE. You should not declare anything using the CONST keyword if its value is going to change.

As for variables, you can settle their values at any time in the form or before/after a report opens.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
 
Old June 22nd, 2005, 12:49 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 159
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks Greg,
U are wright. I'll use a select case statement. The constant is not a constant
anymore and i'll use a variable instead.
rgds P:(





Similar Threads
Thread Thread Starter Forum Replies Last Post
Name 'CAM' is not declared. belmin45 ASP.NET 1.0 and 1.1 Basics 2 May 27th, 2008 02:13 AM
BC30451: Name 'My' is not declared abc052107 Visual Studio 2005 0 July 2nd, 2007 11:01 PM
"Name My " not declared error ajkumar Visual Basic 2005 Basics 0 April 19th, 2007 11:29 PM
Name 'Container' is not declared. surendran ASP.NET 1.0 and 1.1 Professional 1 August 17th, 2004 10:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.