How do I display file path in Access 2003 (was currentdb.name)

[Guest]

We have moved to Office 2003 and cannot print file path at 'Page Footer'.
Previously =[currentDB].[name] and =[name] have provided enough information
for report retrieval but now only =[name] works.

 

[Brendan Reynolds]

Try "=CurrentProject.FullName"

CurrentDb is one of the functions that are blocked in Jet 4 sandbox mode ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698#XSLTH3175121122120121120120

 

[Guest]

Yes, this is just the fix I need, thanks. This was my first attempt in
'Discussion Group', great service! Now to find out what "Jet 4 sandbox mode
is all about.

Try "=CurrentProject.FullName"

CurrentDb is one of the functions that are blocked in Jet 4 sandbox mode ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698#XSLTH3175121122120121120120

--
Brendan Reynolds (MVP)

We have moved to Office 2003 and cannot print file path at 'Page Footer'.
Previously =[currentDB].[name] and =[name] have provided enough
information
for report retrieval but now only =[name] works.

 

[Guest]

If I was at the Opera I would shout "BRAVO" and stand up whilst applauding!

I had exactly the same problem and the quickest of "looks" in the discussion
group gives me the answer!!

Just for interest, this is what I actually put in the text box:

="Full file name: " & [CurrentProject].[FullName] & "
File name: " & [CurrentProject].[Name] & "
Report name: " & [Name]

Clearly there is a chice to be made over whether or not you want the full
path to appear . . . .

Thank you very much "Brendan Reynolds"

PS The "Sandbox" thing seems to be a red herring . . . . I regularly use
Office update and accepted the offer of the latest Jet Engine (I thought
that they were for aircraft!) and I have no problems . . .

Nothing quite like the blind leading the partially sighted eh?


Once again TVM "Brendan Reynolds"

Yours aye
Charles


--
Thank You

Yes, this is just the fix I need, thanks. This was my first attempt in
'Discussion Group', great service! Now to find out what "Jet 4 sandbox mode
is all about.

Try "=CurrentProject.FullName"

CurrentDb is one of the functions that are blocked in Jet 4 sandbox mode ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698#XSLTH3175121122120121120120

--
Brendan Reynolds (MVP)

We have moved to Office 2003 and cannot print file path at 'Page Footer'.
Previously =[currentDB].[name] and =[name] have provided enough
information
for report retrieval but now only =[name] works.

 

[Guest]

Thanks again, I have used part of your expression to improve our documents.

I have no involvement with security issues or departmental policy and have
to just "get on with" whatever changes arrive my way. However I do appreciate
your help and it has increased my understanding of these issues.

If I was at the Opera I would shout "BRAVO" and stand up whilst applauding!

I had exactly the same problem and the quickest of "looks" in the discussion
group gives me the answer!!

Just for interest, this is what I actually put in the text box:

="Full file name: " & [CurrentProject].[FullName] & "
File name: " & [CurrentProject].[Name] & "
Report name: " & [Name]

Clearly there is a chice to be made over whether or not you want the full
path to appear . . . .

Thank you very much "Brendan Reynolds"

PS The "Sandbox" thing seems to be a red herring . . . . I regularly use
Office update and accepted the offer of the latest Jet Engine (I thought
that they were for aircraft!) and I have no problems . . .

Nothing quite like the blind leading the partially sighted eh?


Once again TVM "Brendan Reynolds"

Yours aye
Charles


--
Thank You

Yes, this is just the fix I need, thanks. This was my first attempt in
'Discussion Group', great service! Now to find out what "Jet 4 sandbox mode
is all about.

Try "=CurrentProject.FullName"

CurrentDb is one of the functions that are blocked in Jet 4 sandbox mode ...

http://support.microsoft.com/default.aspx?scid=kb;en-us;294698#XSLTH3175121122120121120120

--
Brendan Reynolds (MVP)

message We have moved to Office 2003 and cannot print file path at 'Page Footer'.
Previously =[currentDB].[name] and =[name] have provided enough
information
for report retrieval but now only =[name] works.