Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Thu Mar 18 08:42:23 CDT 2010
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