[AccessD] CurrentProject.Path syntax?

...whatever it is you're drinking, smoking, ingesting, or injecting ...I 
want some :)

William

--------------------------------------------------
From: "Max Wanadoo" <max.wanadoo at gmail.com>
Sent: Thursday, March 18, 2010 9:50 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] CurrentProject.Path syntax?

> Are you saying:-
>
> A. mine doesn't
> B. mine is 20th century too.
>
> Co'mon now. Don't beat about the bush...out with it...
>
> Answers:
> A. Mine does UNCs better than yours.  Stamps foot and sticks tongue out. 
> So
> there!
> C. Mine adheres to the CRAB principle invented by yours truly (Clear,
> Relevant,  Accurate and Brief).
>
> There we go...over and out....
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Thursday, March 18, 2010 1:42 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] CurrentProject.Path syntax?
>
> My function handles UNC paths from the get go. And UNCs are very much 20th
> century. :-)
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Thursday, March 18, 2010 9:12 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] CurrentProject.Path syntax?
>
>
> But the sample below works a lot better and handles UNC :
>
>    str = "\\svr\c\"
>    strL = Left(str, 2)
>    strR = Replace(Mid(str, 3) & "\", "\\", "\")
>    str = strL & strR
>
> Go on.  Be a Devil.  Move to the 21st Century!!
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
> Sent: Thursday, March 18, 2010 12:55 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] CurrentProject.Path syntax?
>
> Good point from Stuart. I think I'll stick with my little function. :-)
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: Wednesday, March 17, 2010 5:46 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] CurrentProject.Path syntax?
>
>
> Bit more complicated.
>
>    str = "\\svr\c\"
>    strL = Left(str, 2)
>    strR = Replace(Mid(str, 3) & "\", "\\", "\")
>    str = strL & strR
>
> Max
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart 
> McLachlan
> Sent: Wednesday, March 17, 2010 9:07 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] CurrentProject.Path syntax?
>
> And what happens when it is a UNC path?
>
> Str = "\\Server\Share\"
>
> :-(
>
> --
> Stuart
>
> On 17 Mar 2010 at 15:49, Max Wanadoo wrote:
>
>> Str = str & "\"
>> Str = replace(str,"\\","\")
>>
>
> --
> 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
>
> --
> 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
>
> --
> 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
>