currentproject.path as a global variable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I am trying to declare a global variable in my module that stores the value of path of my database with the following codes

Global Const currDir As String = CurrentProject.Path

when i tried to access the variable, currDir in my Sub procedure, my program does not run.

Please advise what's wrong with my declaration.

Thanks & regards
yann
 
yann said:
I am trying to declare a global variable in my module that stores the value of path of my database with the following codes

Global Const currDir As String = CurrentProject.Path

when i tried to access the variable, currDir in my Sub procedure, my program does not run.

Please advise what's wrong with my declaration.
Click to expand...

The Const statement does not accept functions, methods, etc,
it only knows how to interpret expression that use literal
calues and other constants.

You could change that to a string variable:

Public currDir As String

and then assign its value in your startup form:

currDir = CurrentProject.Path
 
Thank you Marshall for your prompt reply.

I've tried changing my declaration for currDir as you mentioned but now when i click the button on my form, my codes cannot be executed. Any idea what could be the cause?

Thanks!
yann
----- Marshall Barton wrote: -----
The Const statement does not accept functions, methods, etc,
it only knows how to interpret expression that use literal
calues and other constants.

You could change that to a string variable:

Public currDir As String

and then assign its value in your startup form:

currDir = CurrentProject.Path
 
What does "my codes cannot be executed" mean?

And the code currently looks like?

Where is the public variable declared? It must be in the
declarations portion (top) of a standard module, not a
form's module.
 
Hi Marshall,

Thanks. I found out why my codes was not running. I should have assigned the value for my public variable in the Form module which I didn't.

Sorry for my mistake.

Thanks!
yann
 
Back
Top